Data Engineer: Database Migration

Job Description

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 Requirements

Database 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.