Senior Database Migration Expert

We are seeking a Senior Database Migration Expert with deep expertise in migrating complex, high-availability Oracle RAC environments to Google Cloud Platform (GCP) using PostgreSQL or AlloyDB. The ideal candidate will be responsible for planning, designing, and executing end-to-end database migration strategies for mission-critical systems, ensuring minimal downtime and optimal performance in the target environment.

Key Responsibilities:

• Lead the planning and execution of database migration from Oracle RAC to PostgreSQL or AlloyDB on GCP.
• Assess existing database environments, identify migration risks, and propose optimal cloud-native solutions.
• Design and implement data migration strategies, including schema conversion, data mapping, and transformation.
• Collaborate with cloud architects, application teams, and DevOps for seamless integration.
• Automate and optimize migration pipelines using tools such as Database Migration Service (DMS), Dataflow, or custom scripts.
• Ensure performance tuning, high availability, and scalability in the target GCP environment.
• Provide technical leadership and mentoring to junior DBAs and cloud engineers.
• Prepare detailed documentation and support operational handovers.

Required Skills & Experience:

• 5-10 years of experience in database administration and migration.
• Strong hands-on experience with Oracle RAC (11g/12c/19c) and deep understanding of RAC architecture.
• Proven experience migrating databases from Oracle to PostgreSQL or AlloyDB in GCP.
• Strong SQL/PLSQL and experience in schema conversion (Oracle to PostgreSQL/AlloyDB).
• Proficiency in using Google Cloud services such as DMS, AlloyDB, Cloud SQL, Compute Engine, and Cloud Storage.
• Familiarity with tools like Ora2Pg, pg_dump/pg_restore, GoldenGate, or other relevant migration tools.
• Solid understanding of cloud-native database security, backup, and disaster recovery principles.
• Strong troubleshooting skills and ability to work in high-pressure migration windows.

Preferred Qualifications:

• Google Cloud Certified Professional Database Engineer or Cloud Architect.
• Experience with Terraform, Ansible, or other IaC tools.
• Background in scripting (Python, Bash) to support automation.
• Exposure to multi-cloud environments (AWS, Azure) is a plus.