Oracle DB Migration Lead

Oracle DB Migration Lead (Manager) Job Description

Role Overview :

Oracle Database Specialist is responsible database migration across Data Center and cloud platforms (AWS to AWS, Azure to Azure, and DC-to-DC). The ideal candidate will have strong hands-on experience in Oracle Exadata and Oracle Exadata Cloud@Customer (ExaCC) environments, including backup/recovery, replication, and monitoring with strong leadership and project management skills to ensure successful migrations, minimal downtime, and seamless delivery across all phases of the program.

Key Responsibilities :

- Lead the end-to-end migration lifecycle across assessment, planning, execution, validation, and post-migration optimization.

- Define and drive migration strategy, methodologies, and best practices (zero/near-zero downtime, HA/DR).

- Plan, design, and execute Oracle database migrations across :

a. Data Center-to-Data Center

b. AWS-to-AWS cloud setups

c. Azure-to-Azure cloud setups

- Oracle Exadata (Exadata to Exadata, Exadata to ExaCC)

- Oracle Exadata Cloud@Customer (ExaCC) environments

- Perform end-to-end database backup and recovery using :

a. Rubrik for backup orchestration and recovery

b. RMAN (Recovery Manager) for backup/restore operations, incremental (delta) syncs, and PITR (Point-in-Time Recovery)

- Implement delta data synchronization strategies for near-zero downtime migration.

- Use Oracle Enterprise Manager (OEM) for :

a. Database performance monitoring

b. Health checks and proactive alerting

c. Migration tracking and validation

- Execute data purging and archival strategies to optimize database size and performance pre/post-migration.

- Collaborate with cloud architects, infrastructure teams, and application owners to ensure smooth migration with minimal business disruption.

- Document migration runbooks, rollback procedures, and knowledge transfer.

Must-Have Skills :

- 12+ years of Oracle Database experience, with 5+ years in leadership/managerial roles overseeing database migration programs.

- Proven track record of managing large-scale Oracle migrations in multi-cloud, Exadata, and ExaCC environments.

- Strong experience with :

a. Oracle Exadata administration, migration, and performance tuning

b. Oracle Exadata Cloud@Customer (ExaCC) implementation and management

c. Oracle Data Guard setup, switchover, failover, and role transitions

d. Rubrik for backup, restore, and DR integration

e. RMAN for backup/recovery, delta sync, cloning, and duplication

f. OEM (Oracle Enterprise Manager) for monitoring and migration validation

- Hands-on experience with cloud-native database solutions in AWS (RDS, EC2, S3) and Azure (Azure SQL, Blob Storage, Recovery Vaults).

- Experience in data purging, retention policies, and compliance for regulated environments.

- Strong troubleshooting, performance tuning, and problem-resolution skills, particularly in Exadata/ExaCC environments.

- Excellent communication, documentation, and stakeholder management capabilities.

Nice-to-Have Skills :

- Knowledge of GoldenGate for real-time replication.

- Familiarity with Terraform/Ansible for IaC-based DB provisioning.

- Experience in hybrid migration scenarios (on-prem to Exadata, Exadata to ExaCC, ExaCC to cloud).

- Exposure to DevOps pipelines for automated DB deployment.