Database Migration Engineer

DATABASE MIGRATION ENGINEER (ORACLE TO POSTGRESQL)

LOCATION: GUATEMALA / EL SALVADOR

WORK STYLE: HYBRID

WHO WE ARE

Welcome to TELUS Digital https://www.telusdigital.com/, where innovation drives impact at a global scale. As an award-winning digital product consultancy and the digital division of TELUS https://www.telus.com/en/, one of Canada’s largest telecommunications providers, we design and deliver transformative customer experiences through cutting-edge technology, agile thinking, and a people-first culture.

With a global team across North America, South America, Central America, Europe, and APAC, we offer end-to-end expertise across eight core service areas: Digital Product Consulting, Digital Marketing Services, Data & AI, Strategy Consulting, Business Operations Modernization, Enterprise Applications, Cloud Engineering, and QA & Test Engineering.

ABOUT THE ROLE

We are seeking a highly skilled Database Migration Engineer for a critical 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 operational excellence.

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 EXPERIENCE

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

GREAT TO HAVE

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

WHAT’S IN IT FOR YOU

• Private medical and life insurance from day one
• Budget for professional growth (certifications)
• Schedule flexibility.
• Extra bonus based on performance.