Oracle DBA- Automation and Scripting

ProArch, a leading technology company, is seeking a skilled and proactive Oracle DBA with deep expertise in automation and shell scripting, specifically within Oracle’s multitenant (CDB/PDB) architecture. This role focuses on optimizing and automating routine DBA operations to enhance efficiency, scalability, and reliability across multiple database instances.

Key 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.

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.
• 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.

Please Note

• Shift timings 6PM to 3 AM , need to be available for extended work hours and stretch during weekends. 
• This is permanent work from home opportunity
• We are looking for immediate joiners.