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