Senior Database Migration Expert

Abacus


Date: 12 hours ago
City: Lahore
Contract type: Full time
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.

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Manager, Business Strategy & Operations

Motive, Lahore
2 days ago
Who We AreMotive empowers the people who run physical operations with tools to make their work safer, more productive, and more profitable. For the first time ever, safety, operations and finance teams can manage their drivers, vehicles, equipment, and fleet related spend in a single system. Combined with industry leading AI, the Motive platform gives you complete visibility and control,...

ERP Testing Engineer

Gigalabs (Pvt) Ltd., Lahore
2 days ago
Job Brief:Employment Type: Contract BasedLocation: Remote, Full TimeTime Zone: CET (04 Hours Overlap)Project Duration: 6 months with the possibility of extensionResponsibilities:Work with test service customer management and SMEs to gather testing requirements.Develop and maintain detailed technical documentation as needed.Manage testing platform including user provisioning, security, connection agents. group and role-based configuration etc.Create and maintain tests, test steps, jobs, etc.Configure integrations...

Software Engineer - React Native

Carte Blanche Innovation Integrated, Lahore
5 days ago
The RoleWe’re seeking a React Native Software Engineer with 4-5 years of experience in building and shipping mobile applications using React Native and JavaScript/TypeScript. You’ll be the lead engineer responsible for designing, building, and maintaining a mobile app from the ground up, working alongside a team of developers. You’ll drive the end-to-end development process, mentor junior developers, and ensure the...