LP
Senior Technical Engineer
LinkedIn Recruiter Post
Senior Technical Engineer needed for nuclear engineering contract in Pickering, ON. Requires 6 - 8 years experience and ECC systems knowledge.
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.
Environmental Engineer/Geoscientist at a forensic engineering firm in Halifax. Responsible for overseeing environmental investigations and liaising with clients.
Senior Project Engineer overseeing capital project execution for Agropur in Bedford, Nova Scotia. Leading multidisciplinary teams and ensuring alignment with business objectives in a fast - paced environment.
Lead Verification Engineer developing high - performance physical IP at Cadence. Responsible for digital RTL verification and developing re - usable verification components and environments.
Senior Digital Verification Engineer at Ciena focusing on implementing innovative strategies for validating Forward Error Correction IP subsystems. Collaborating with design engineers to ensure functional integrity.
Ingénieur(e) en mécanique du bâtiment concevant des systèmes (plomberie, chauffage, ventilation). Coordination des projets dans le cadre du développement des trains à grande vitesse au Canada.
Lead Release Train Engineer managing Agile delivery systems for financial services. Fostering collaboration, continuous improvement, and alignment between strategy and execution.
Data Engineer managing data ingestion, modeling, and reporting using Microsoft Fabric at BDO. Collaborating with stakeholders and maintaining pipelines, reports, and documentation.
Project Engineer coordinating project activities and engineering deliverables for mining projects at Sedgman, based in Vancouver. Involves diverse projects from feasibility studies to construction.
Engineer architecting and building AI - powered products at an AI - first company. Join a dynamic startup with a mission to empower everyone in drafting legal documents using AI.