Description:

ProArch is seeking a skilled and proactive Oracle DBA with deep expertise in automation and shell scripting, specifically within Oracle’s multitenant (CDB/PDB) architecture.
The role focuses on optimizing and automating routine DBA operations to enhance efficiency, scalability, and reliability across multiple database instances.
Key responsibilities include designing, building, and maintaining shell scripts to automate daily DBA tasks in multitenant environments, such as backups, health checks, patching, and provisioning.
The DBA will automate PDB-level operations, including creation, cloning, unplug/plug, refreshes, and performance monitoring.
The position involves implementing backup and recovery strategies using RMAN with automated scheduling and logging.
The DBA will manage and monitor CDB and PDB performance, storage, and security.
Development of automation for startup/shutdown, tablespace monitoring, and user/role management across all PDBs is required.
Clear documentation for automation scripts and standard operating procedures must be maintained.
The role ensures high availability, disaster recovery readiness, and compliance in multitenant setups.
Shift timings are from 6 PM to 3 AM, and the candidate must be available for extended work hours and weekends.
This is a permanent work-from-home opportunity, and immediate joiners are preferred.

Requirements:

Candidates must have 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 is required.
Proven experience in automating Oracle DBA tasks, including monitoring, backups, user management, and cloning, is essential.
Strong knowledge of RMAN, Oracle Enterprise Manager (OEM), and SQL*Plus is necessary.
Familiarity with database security, patching, and performance tuning is expected.
Experience with Python or tools for advanced automation is preferred.
Candidates should have exposure to cloud-based Oracle environments, such as OCI and Azure.
An understanding of licensing and consolidation best practices for multitenant databases is required.

The position offers a permanent work-from-home opportunity, providing flexibility in work location.
Candidates will have the chance to work in a leading technology company, enhancing their skills in automation and multitenant database management.
The role allows for the development of expertise in advanced DBA tasks and cloud-based environments.
Employees will be part of a dynamic team focused on optimizing database operations and ensuring high availability and compliance.