Oracle Database Administrator

Summary

Join ProArch, a leading technology company, as a skilled Oracle DBA specializing in automation and shell scripting within Oracle's multitenant architecture. This permanent work-from-home position requires optimizing and automating routine DBA operations to enhance efficiency and reliability across multiple database instances. The role demands expertise in designing, building, and maintaining shell scripts for various tasks, including backups, health checks, patching, and provisioning. You will manage and monitor CDB and PDB performance, storage, and security, ensuring high availability and disaster recovery readiness. The position requires 5+ years of experience as an Oracle DBA with solid exposure to multitenant architecture and expertise in shell scripting. Immediate joiners are preferred. Note that this role involves a night shift (6 PM to 3 AM) with potential for extended hours and weekend work.

Requirements

• 5+ years of experience as an Oracle DBA with solid exposure to multitenant architecture (CDB/PDB) in Oracle 12c/19c/21c
• Expertise in Shell scripting on Unix/Linux environments
• Proven experience automating Oracle DBA tasks (monitoring, backups, user management, cloning, etc.)
• Strong knowledge of RMAN, Oracle Enterprise Manager (OEM), and SQL*Plus
• Familiarity with database security, patching, and performance tuning

Responsibilities

• Design, build, and maintain Shell scripts to automate daily DBA tasks in multitenant environments (e.g., backups, health checks, patching, provisioning)
• Automate PDB-level operations: creation, cloning, unplug/plug, refreshes, and performance monitoring
• Implement backup and recovery strategies using RMAN with automated scheduling and logging
• Manage and monitor CDB and PDB performance, storage, and security
• Develop automation for startup/shutdown, tablespace monitoring, and user/role management across all PDBs
• Maintain clear documentation for automation scripts and standard operating procedures
• Ensure high availability, disaster recovery readiness, and compliance in multitenant setups

Preferred Qualifications

• Experience with Python or tools for advanced automation
• Exposure to cloud-based Oracle environments (OCI, Azure)
• Understanding of licensing and consolidation best practices for multitenant databases

Benefits

This is permanent work from home opportunity