Senior Database Migration Expert
About this role
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, pgdump/pgrestore, 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.
Company at a glance
For nearly 40 years, Abacus has been offering cutting-edge business solutions helping organisations to transform their visions into realities through a combination of latest business methodologies and technological tools. The business value offered by Abacus has a deep scale, is industry focused and technology driven with a world class delivery capability. We help to transform the businesses of clients who want to be leaders in their industry.
Abacus is founded on one simple belief, that change is the only constant in our world and that as enterprises and individuals, we must all respond to change with vision, courage and integrity. We are passionate about being partners to our clients, as advisers, consultants, technology specialists, systems integrators and outsourcers. For the people at Abacus, fulfillment is seeing our clients transform into truly great organisations.
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?