Senior Database Migration Expert

  • Lahore, Pakistan
  • Full-Time
  • On-Site
  • -
Apply now Refer
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.