Senior Database Migration Expert

abacus-consulting-3; Lahore; On-site; PKR 1,800,000 - 3,200,000; Full time

Job summary

Senior Database Migration Expert is sought to lead end-to-end migration from Oracle RAC to PostgreSQL or AlloyDB on GCP, with focus on minimal downtime and optimal performance for mission-critical systems.

You will design migration strategies, assess existing environments, convert schemas, and automate pipelines using DMS, Dataflow, or scripts, while mentoring junior DBAs and coordinating with Cloud and DevOps teams.

Qualifications

• 5–10 years of experience in database administration and migration.
• Hands-on experience with Oracle RAC (11g/12c/19c) and RAC architecture.
• Proven experience migrating Oracle to PostgreSQL or AlloyDB in GCP.
• Strong SQL/PLSQL and schema conversion (Oracle to PostgreSQL/AlloyDB).

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 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 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.

Skills

Oracle RAC experience

SQL/PLSQL

Database migration

Cloud migration planning

GCP migration tools

Tools

DMS

AlloyDB

pg_dump/pg_restore

GoldenGate

Ora2Pg

Job description

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.