About the role
Database Migration Engineer (Oracle to PostgreSQL)
Duration 6+ Months Remote
Position Overview
We are seeking two highly skilled Database Migration Engineers for a critical, long-term (2-year) project focused on migrating a large-scale enterprise database environment from Oracle to PostgreSQL. The environment includes both OLTP and Data Warehouse (OLAP) components. The primary focus of this role is the manual and programmatic refactoring of a significant codebase from PL/SQL to PL/pgSQL, ensuring performance parity, data integrity, and
Project Scope
The bulk of the work involves the conversion of programming logic between database dialects. This includes converting legacy Oracle packages, stored procedures, functions, and triggers to PostgreSQL equivalents; transitioning SQL*Plus scripts to psql/PostgreSQL procedures; schema redesign; and ETL orchestration for massive datasets.
Key Responsibilities
Code Conversion: Manually and programmatically translate complex Oracle PL/SQL code (including Packages and Triggers) into high-performance PostgreSQL PL/pgSQL. ETL Refactoring: Re-engineer complex Data Warehouse ETL logic for optimal performance in a PostgreSQL environment. Schema Migration: Translate data types, constraints, and indexes while optimizing for PostgreSQL’s architectural strengths. Performance Tuning: Identify and resolve bottlenecks in the migrated code using query plan analysis and advanced indexing. Data Integrity: Develop and execute rigorous validation scripts to ensure 100% data consistency between source and target systems. Collaboration: Work as part of a high-capability development team, reporting to the Team Lead and coordinating with application developers. Documentation: Maintain detailed documentation of architectural changes and mapping logic.
Required Qualifications
Expertise in Oracle: 5+ years of experience (12c/19c) with deep proficiency in PL/SQL. Expertise in PostgreSQL: 3+ years of experience developing in PL/pgSQL. Migration Experience: Proven track record of at least one full-lifecycle Oracle to PostgreSQL migration. Advanced SQL: Mastery of ANSI SQL and deep knowledge of the nuances between Oracle and Postgres dialects. Linux/Scripting: Proficiency in Shell scripting (Bash) or Python for automation. Languages: Fluency in English is required; French is a strong asset.
Preferred Skills & Competencies
Experience with cloud database services (e.g., GCP CloudSQL). Knowledge of migration tooling (e.g., Ora2Pg). Analytical Thinking: Ability to deconstruct complex legacy logic and rebuild it efficiently. Communication: Excellent verbal and written communication skills.
Working Conditions
Flexibility: Willingness to maintain at least 4 hours of overlap with the team based in Montreal (Eastern Time Zone).
Not the right fit? Search for Database Migration Engineer jobs in Canada
About Gala Solutions
We are happy to talk in detail about our services and how we can assist your business. We specialize in end-to-end solutions for your entire web-related needs. Self-optimizing systems and the need for new ideas powered by intelligent technologies have been a keen interest in meeting the needs of growing customer expectations. We contribute to our client's aspirations by driving real innovation and ideas that transform and grow their organizations.
We offer a wide range of services which include Application Services, Business Consulting, Infrastructure Services, IT Outsourcing Services and System Integration Services, ASIC design services, etc.
We strive to serve our clients by establishing their brand name and developing their portfolio in the market. Continuous profitable growth is a testimony to the confidence of our clients in us. The commitment of our members is to provide exponential growth to shareholders and the best return on their investment.
We systematically rethink how our clients can create an impact on their organizations by analyzing the exceptions of the end customers.
Similar Jobs
About the role
Database Migration Engineer (Oracle to PostgreSQL)
Duration 6+ Months Remote
Position Overview
We are seeking two highly skilled Database Migration Engineers for a critical, long-term (2-year) project focused on migrating a large-scale enterprise database environment from Oracle to PostgreSQL. The environment includes both OLTP and Data Warehouse (OLAP) components. The primary focus of this role is the manual and programmatic refactoring of a significant codebase from PL/SQL to PL/pgSQL, ensuring performance parity, data integrity, and
Project Scope
The bulk of the work involves the conversion of programming logic between database dialects. This includes converting legacy Oracle packages, stored procedures, functions, and triggers to PostgreSQL equivalents; transitioning SQL*Plus scripts to psql/PostgreSQL procedures; schema redesign; and ETL orchestration for massive datasets.
Key Responsibilities
Code Conversion: Manually and programmatically translate complex Oracle PL/SQL code (including Packages and Triggers) into high-performance PostgreSQL PL/pgSQL. ETL Refactoring: Re-engineer complex Data Warehouse ETL logic for optimal performance in a PostgreSQL environment. Schema Migration: Translate data types, constraints, and indexes while optimizing for PostgreSQL’s architectural strengths. Performance Tuning: Identify and resolve bottlenecks in the migrated code using query plan analysis and advanced indexing. Data Integrity: Develop and execute rigorous validation scripts to ensure 100% data consistency between source and target systems. Collaboration: Work as part of a high-capability development team, reporting to the Team Lead and coordinating with application developers. Documentation: Maintain detailed documentation of architectural changes and mapping logic.
Required Qualifications
Expertise in Oracle: 5+ years of experience (12c/19c) with deep proficiency in PL/SQL. Expertise in PostgreSQL: 3+ years of experience developing in PL/pgSQL. Migration Experience: Proven track record of at least one full-lifecycle Oracle to PostgreSQL migration. Advanced SQL: Mastery of ANSI SQL and deep knowledge of the nuances between Oracle and Postgres dialects. Linux/Scripting: Proficiency in Shell scripting (Bash) or Python for automation. Languages: Fluency in English is required; French is a strong asset.
Preferred Skills & Competencies
Experience with cloud database services (e.g., GCP CloudSQL). Knowledge of migration tooling (e.g., Ora2Pg). Analytical Thinking: Ability to deconstruct complex legacy logic and rebuild it efficiently. Communication: Excellent verbal and written communication skills.
Working Conditions
Flexibility: Willingness to maintain at least 4 hours of overlap with the team based in Montreal (Eastern Time Zone).
Not the right fit? Search for Database Migration Engineer jobs in Canada
About Gala Solutions
We are happy to talk in detail about our services and how we can assist your business. We specialize in end-to-end solutions for your entire web-related needs. Self-optimizing systems and the need for new ideas powered by intelligent technologies have been a keen interest in meeting the needs of growing customer expectations. We contribute to our client's aspirations by driving real innovation and ideas that transform and grow their organizations.
We offer a wide range of services which include Application Services, Business Consulting, Infrastructure Services, IT Outsourcing Services and System Integration Services, ASIC design services, etc.
We strive to serve our clients by establishing their brand name and developing their portfolio in the market. Continuous profitable growth is a testimony to the confidence of our clients in us. The commitment of our members is to provide exponential growth to shareholders and the best return on their investment.
We systematically rethink how our clients can create an impact on their organizations by analyzing the exceptions of the end customers.