Senior Execution Engineer leading capital maintenance and operational projects across Enbridge’s Prairie Region pipeline network. Providing engineering leadership, contractor coordination, and safe project delivery.
About the role
- Database Migration Engineer at TELUS Digital, migrating enterprise databases from Oracle to PostgreSQL. Collaborating with global teams to ensure performance parity and operational excellence.
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.
Requirements
- 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.
Benefits
- Flexibility: Willingness to maintain at least 4 hours of overlap with the team based in Montreal (Eastern Time Zone).
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Acoustic Engineer delivering noise and vibration control for mission - critical data centre projects. Supporting acoustical design, modelling, compliance, construction, and commissioning across multidisciplinary teams.
Aircraft stress engineer analyzing damage tolerance and fatigue in primary aircraft structures for SOGECLAIR. Supporting design, repairs, certification, suppliers, and maintenance documentation.
Risk Model Engineer building explainable, validated gas distribution risk models for Irth’s AI - driven pipeline integrity platform. Defining threat frameworks and prioritization outputs for utilities.
Environmental Engineer/Scientist conducting contaminated - site assessments, remediation, and field investigations for GHD in Calgary. Preparing reports and overseeing sampling, drilling, monitoring, and hydrogeological projects.
Electrical Engineer - in - Training designing protection, control, and metering systems for Qualus substations. Supporting utility projects from concept through construction and commissioning.
Engineer - in - Training designing protection, control, and metering systems for Qualus substation projects. Supporting utility power infrastructure delivery from concept through construction and commissioning.
Ingénieur instrumentation et contrôle chez AtkinsRéalis, organisation mondiale de services d’ingénierie et d’énergie nucléaire. Conception de systèmes d’automatisation et coordination de projets industriels multidisciplinaires.
Senior Forward Deployed Engineer building and deploying production networking, AI, and cloud solutions for Extreme Networks customers. Owning integrations, automation, and technical outcomes from design through production readiness.
Prompt Engineer designing LLM workflows for Innodata, a global data engineering company. Automating data annotation, localization, and human - evaluation processes.