Data Engineer: Database Migration at Enroute | Torre

Data Engineer: Database Migration

You'll modernize enterprise systems, driving innovation by migrating Oracle to optimized Azure SQL environments.
Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time

Legal agreement: Employment

USD75.4K - 100K/year

~COP150M - 200M/year

+ Equity

+ Bonuses

location_on
Remote (for Mexico residents)
Match
skeleton-gauges
You have opted out of job matches in .
To undo this, go to the 'Skills and Interests' section of your preferences.
Review preferences
Shared by
Emma of Torre.ai
23 days ago

Requirements and responsibilities


We love technology, and we enjoy what we do. We are always looking for innovation and continuous improvement. At Enroute, we are looking for a Data Engineer with strong database migration expertise to support the migration of enterprise Oracle environments into Azure SQL.This role will focus on analyzing existing Oracle databases, migrating schemas and data structures, converting PL/SQL logic into Azure SQL-compatible solutions, and ensuring migrated environments are optimized, scalable, and reliable.The ideal candidate has strong hands-on experience with Oracle, SQL Server/Azure SQL, Transact-SQL, database migrations, and performance optimization across enterprise environments.Requirements✅ Must-Have RequirementsDatabase Engineering & Migration5+ years of professional experience working with relational databases and data engineering initiativesStrong experience with SQL Server and/or Azure SQL environmentsStrong hands-on experience with Oracle databases, including SQL and PL/SQLExperience migrating schemas, tables, views, stored procedures, functions, indexes, and related database objectsAbility to analyze and convert Oracle SQL / PL-SQL logic into Azure SQL-compatible equivalentsStrong understanding of relational database design principlesExperience with query optimization, indexing strategies, and performance tuningStrong experience troubleshooting database compatibility and migration issuesData Migration & ValidationExperience performing data profiling, source-to-target mapping, and migration analysisStrong experience with data validation, reconciliation, and migration testingExperience identifying and resolving data quality and consistency issuesAbility to support production migration and post-migration stabilization activitiesSQL Development & OptimizationAdvanced Transact-SQL (T-SQL)Strong SQL development experience across Oracle and Microsoft SQL environmentsExperience optimizing complex queries, stored procedures, and database objectsStrong understanding of scalability, maintainability, and database performance best practicesCloud & CollaborationExperience working with Azure SQL environmentsExperience collaborating with ETL and Azure Data Factory (ADF) teamsStrong documentation and communication skillsAbility to work cross-functionally with QA, architecture, engineering, and business stakeholders🎯 ResponsibilitiesAnalyze existing Oracle schemas, tables, views, stored procedures, functions, indexes, and related database objectsSupport the migration of database structures and data from Oracle to Azure SQLIdentify compatibility gaps between Oracle and Azure SQL and propose remediation approachesConvert or refactor Oracle SQL, PL/SQL, stored procedures, functions, and views into Azure SQL-compatible equivalentsSupport source-to-target mapping, data profiling, and migration analysisPerform data validation, reconciliation, and quality checks between Oracle and Azure SQLOptimize migrated database objects for performance, scalability, and maintainabilityCollaborate with ETL / ADF engineers to ensure pipelines align with the target data modelDocument migration findings, conversion decisions, validation results, and technical recommendationsSupport testing, defect resolution, production migration, and post-migration stabilization activitiesTroubleshoot performance, compatibility, and data quality issues throughout the migration lifecycle✨ Nice-to-Have Requirements (Extras)Experience with Azure Data Factory (ADF)Exposure to cloud-native data architecturesExperience with automated migration tools and schema conversion toolsFamiliarity with CI/CD workflows for database deploymentsExperience supporting enterprise-scale modernization initiativesKnowledge of data governance and database security best practicesExposure to Agile/Scrum environmentsBenefitsMonetary compensation Year-end Bonus IMSS, AFORE, INFONAVIT Major Medical Expenses Insurance Life Insurance Funeral Expenses Coverage TDU Membership MediAccess Health Check-Up Subsidy Preferential rates for car insurance Vacations Official Mexican Holidays Life Happens Days Bereavement Leave Civil Marriage Leave English Classes Certifications Educational Agreements (Talisis, U-ERRE, UNID, TecMilenio, Tec de Monterrey, UDEM, SPIS) Corporate Agreements & Discounts (Sorteos Tec, Envia Flores, TopGolf)Taquitos Rewards Birthday Bonus </
Optionally, you can add more information later (benefits, pre-screening questions, etc.)
check_circle

Payment confirmed

A member of the Torre team will contact you shortly

In the meantime, continue adding information to your job opening.