GCP Oracle-to-AlloyDB Migration Lead

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