Job Summary
The Oracle DBA (Database Migration & DMS Specialist) will administer, monitor, maintain, and optimize Oracle databases across production and nonproduction environments. The role focuses on database administration, performance tuning, high availability, disaster recovery, and database migration using Oracle Database Migration Service (DMS), Oracle GoldenGate, Data Pump, RMAN, and related tools. The specialist will plan and execute migration strategies, manage cutover and rollback procedures, validate data consistency, minimize downtime, and support business continuity across on-premises and cloud environments.
Key Responsibilities
• Administer, monitor, and maintain Oracle databases across production and nonproduction environments.
• Perform database installation, configuration, patching, upgrades, backup, and recovery activities.
• Manage Oracle RAC, ASM, Data Guard, RMAN, and database performance tuning initiatives.
• Plan and execute database migration projects using Oracle Database Migration Service (DMS), Oracle GoldenGate, Data Pump, RMAN, and related migration tools.
• Assess source and target database environments and define appropriate migration strategies.
• Develop migration plans, cutover schedules, rollback procedures, and risk mitigation strategies.
• Troubleshoot migration issues, validate data consistency, and ensure minimal downtime during cutovers.
• Implement high availability and disaster recovery (HADR) solutions to support business continuity requirements.
• Maintain migration runbooks, operational procedures, and technical documentation.
• Configure and execute database migration plans using appropriate migration tools and processes.
• Support critical production environments and resolve database performance, availability, and migration issues.
• Automate database administration and migration tasks using scripting and automation tools.
Required Qualifications
• 8 years of experience in Oracle database administration.
• Strong Oracle DBA experience with Oracle Database versions 11g, 12c, 19c, and 21c.
• Expertise in Oracle RAC, ASM, Data Guard, RMAN, Oracle Enterprise Manager (OEM), and SQL performance tuning.
• Hands-on experience with Oracle Database Migration Service (DMS) and Oracle database migrations.
• Experience with Oracle Cloud Infrastructure (OCI), Exadata, ExaCC, or cloud migration projects.
• Knowledge of Oracle GoldenGate replication and zero-downtime or minimal-downtime migration strategies.
• Strong troubleshooting and scripting skills using Shell, SQL, and PL/SQL.
• Experience supporting critical production database environments.
• Ability to develop migration execution plans, cutover procedures, rollback plans, and technical documentation.
Preferred Qualifications
• Experience with cross-platform database migrations and database modernization initiatives.
• Exposure to AWS RDS for Oracle or Oracle workloads in Azure environments.
• Knowledge of Oracle Cloud Infrastructure and related database services.
Certifications
• Oracle Cloud Infrastructure (OCI) certification is preferred.
