Job Description
Senior Oracle DBA – Cloud Migrations, Upgrades & APEX Specialist
We are seeking an experienced Oracle DBA to architect, install and maintain Oracle Database infrastructure in on-prem and cloud infrastructgure. In this role, you will be Orchestrating the lift-and-shift of legacy databases, executing structural database upgrades (e.g., non-CDB to multitenant CDB/PDB), configuring enterprise-grade Oracle APEX environments, and tuning cloud data engines.
Key Responsibilities
- Lead the technical planning and execution of database migrations from on-premises datacenters to OCI DB Systems, and Autonomous Databases.
- Install, configure and administer Oracle Database System in on-prem (or) Cloud infrastructure.
- Support and Tune production and non-prod Oracle Databases.
- Minimize business impact during massive cutovers by implementing Oracle Zero Downtime Migration (ZDM), Oracle GoldenGate (logical replication), and optimized Oracle Data Pump architectures.
- Execute major database upgrades (e.g., upgrading legacy 12c or 11g environments to Oracle 19c, 23c, or 26ai). Drive the transformation from traditional architectures into Container Databases (CDB) and Pluggable Databases (PDB).
- APEX Environment Provisioning: Install, configure, patch, and upgrade Oracle APEX instances across development, test, and production environments within CDB/PDB architectures.
- Partner with the cloud infrastructure engineer to instantiate, patch, configure, and scale cloud database services natively launched via OCI or directly mapped through the Oracle Database Service for Azure (ODSA).
- Set up cross-cloud or cross-region Disaster Recovery environments utilizing Oracle Data Guard and Active Data Guard.
- Setup and verify backup/recovery integrating RMAN with OCI Object Storage for both database files and APEX application metadata.
- Perform deep-dive SQL tuning, AWR/ASH analysis, and memory/I/O tuning to resolve post-migration performance discrepancies.
- Diagnose and optimize performance bottlenecks specifically impacting heavy APEX web applications and ORDS connection pools.
- Lead, participate, build and assist Functional and Developers for designing and developing the Archival, custom OLTP and reporting schema and applications for ERP solutions.
Required Qualifications & Skills
- 8+ years as an Oracle Database Administrator, featuring a proven track record of managing at least 3 major enterprise-scale database migrations to the cloud and managing production-grade APEX instances.
- 8+ years of Deep-dive mastery of Oracle Database architectures, CDB/PDB structures, Oracle ZDM, Data Pump, Transportable Tablespaces, and Oracle Recovery Manager (RMAN).
- 3 years of knowledge and experience of Oracle APEX (architecture and administration), ORDS configuration, Tomcat/WebLogic deployment, and RESTful web service security.
- Production experience managing databases hosted on OCI DB Systems, Autonomous Database (ATP), and Exadata Cloud Infrastructure.
- 3 to 5 years of Experience in working with PeopleSoft or other ERP solutions.
- Preferred Certifications: