Data Engineer: Database Migration
About the role
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 & Migration
5+ years of professional experience working with relational databases and data engineering initiatives
Strong experience with SQL Server and/or Azure SQL environments
Strong hands-on experience with Oracle databases, including SQL and PL/SQL
Experience migrating schemas, tables, views, stored procedures, functions, indexes, and related database objects
Ability to analyze and convert Oracle SQL / PL-SQL logic into Azure SQL-compatible equivalents
Strong understanding of relational database design principles
Experience with query optimization, indexing strategies, and performance tuning
Strong experience troubleshooting database compatibility and migration issues
Data Migration & Validation
Experience performing data profiling, source-to-target mapping, and migration analysis
Strong experience with data validation, reconciliation, and migration testing
Experience identifying and resolving data quality and consistency issues
Ability to support production migration and post-migration stabilization activities
SQL Development & Optimization
Advanced Transact-SQL (T-SQL)
Strong SQL development experience across Oracle and Microsoft SQL environments
Experience optimizing complex queries, stored procedures, and database objects
Strong understanding of scalability, maintainability, and database performance best practices
Cloud & Collaboration
Experience working with Azure SQL environments
Experience collaborating with ETL and Azure Data Factory (ADF) teams
Strong documentation and communication skills
Ability to work cross-functionally with QA, architecture, engineering, and business stakeholders
Responsibilities
Analyze existing Oracle schemas, tables, views, stored procedures, functions, indexes, and related database objects
Support the migration of database structures and data from Oracle to Azure SQL
Identify compatibility gaps between Oracle and Azure SQL and propose remediation approaches
Convert or refactor Oracle SQL, PL/SQL, stored procedures, functions, and views into Azure SQL-compatible equivalents
Support source-to-target mapping, data profiling, and migration analysis
Perform data validation, reconciliation, and quality checks between Oracle and Azure SQL
Optimize migrated database objects for performance, scalability, and maintainability
Collaborate with ETL / ADF engineers to ensure pipelines align with the target data model
Document migration findings, conversion decisions, validation results, and technical recommendations
Support testing, defect resolution, production migration, and post-migration stabilization activities
Troubleshoot 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 architectures
Experience with automated migration tools and schema conversion tools
Familiarity with CI/CD workflows for database deployments
Experience supporting enterprise-scale modernization initiatives
Knowledge of data governance and database security best practices
Exposure to Agile/Scrum environments
Benefits
Benefits
Monetary 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
Work-from-home Bonus
Laptop Policy
Equal employment
Enroute is committed to providing equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
Questions about this role
How do I apply to this Data Engineer: Database Migration role at Enroute?
Click "Apply with AI Applyd" above. We auto-fill the application from your resume and answer screening questions in seconds. No copy and paste, no juggling tabs.
What's the typical salary for Data Engineer in your country?
Compensation varies by seniority, employer size, and location. When this listing publishes a salary band you'll see it in the badge row above the description.
How fast does AI Applyd auto-apply?
Most applications complete in under 90 seconds. You can track the status in your dashboard and watch the screenshot proof land the moment the application submits.
What ATS does Enroute use?
AI Applyd supports Greenhouse, Lever, Ashby, Workday, iCIMS, SmartRecruiters, LinkedIn Easy Apply, and most other ATS platforms. If we can submit through the platform, we do.
Want AI Applyd to auto-apply to roles like this?
We tailor your resume per posting, fill the forms, and track replies for you.