Offer summary

Qualifications:

5+ years of experience as an Oracle DBA with expertise in multitenant architecture (CDB/PDB) in Oracle 12c/19c/21c., Strong proficiency in Shell scripting on Unix/Linux environments., Experience with RMAN, Oracle Enterprise Manager (OEM), and SQL*Plus., Familiarity with cloud-based Oracle environments (OCI, Azure) and advanced automation tools like Python..

Key responsibilities:

Design and maintain Shell scripts to automate daily DBA tasks in multitenant environments.

Automate PDB-level operations including creation, cloning, and performance monitoring.

Implement backup and recovery strategies using RMAN with automated scheduling.

Manage and monitor CDB and PDB performance, ensuring high availability and compliance.

Job description

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.

Required profile