Database Migration Engineer

TELUS Digital

Database Migration Engineer specializing in Oracle to PostgreSQL migrations at TELUS Digital. Responsible for code conversion, schema migration, and ensuring data integrity during the transition.

Posted 5/7/2026full-timeSan Salvador • 🇧🇷 BrazilMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ETLLinuxOraclePostgresPythonShell ScriptingSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Oracle PL/SQLPostgreSQL PL/pgSQLETL logicData WarehousePerformance TuningSQLShell scriptingBashPythonData Integrity

Soft Skills

CollaborationDocumentation