Data Engineer: Database Migration

2 weeks, 1 day ago
Full-time
Senior
Data Science and Analytics
Enroute

Enroute

Enroute provides comprehensive IT services including QA & Testing, Software Development, 3D Printing, Data Management, and more, delivering tailored solutions for partners.

Internet Software & Services
51-250
Founded 2005

Description

  • 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 recommend remediation approaches.
  • Convert and refactor Oracle SQL and PL/SQL logic 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 and Azure Data Factory engineers to align pipelines 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.

Requirements

  • 5+ years of professional experience with relational databases and data engineering initiatives.
  • Strong experience with SQL Server and/or Azure SQL environments.
  • 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 and 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.
  • Advanced Transact-SQL (T-SQL) skills and strong SQL development experience across Oracle and Microsoft SQL environments.
  • Experience with data profiling, source-to-target mapping, migration analysis, validation, reconciliation, and migration testing.
  • Ability to identify and resolve data quality and consistency issues.
  • Experience supporting production migration and post-migration stabilization activities.
  • Experience working with Azure SQL environments.
  • Experience collaborating with ETL and Azure Data Factory teams.
  • Strong documentation and communication skills.
  • Ability to work cross-functionally with QA, architecture, engineering, and business stakeholders.
  • Experience with Azure Data Factory (preferred).
  • Exposure to cloud-native data architectures (preferred).
  • Experience with automated migration tools and schema conversion tools (preferred).
  • Familiarity with CI/CD workflows for database deployments (preferred).
  • Experience supporting enterprise-scale modernization initiatives (preferred).
  • Knowledge of data governance and database security best practices (preferred).
  • Exposure to Agile/Scrum environments (preferred).

Benefits

  • Monetary compensation with a year-end bonus.
  • IMSS, AFORE, and INFONAVIT benefits.
  • Major medical expenses insurance and life insurance.
  • Funeral expenses coverage.
  • TDU membership, MediAccess, and health check-up subsidy.
  • Preferential rates for car insurance.
  • Vacations and official Mexican holidays.
  • Life Happens Days, bereavement leave, and civil marriage leave.
  • English classes, certifications, and educational agreements.
  • Corporate agreements and discounts.
  • Taquitos Rewards, birthday bonus, work-from-home bonus, and laptop policy.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

OFSAA - Basel Technical Consultant

Unison Group Technology consulting

An experienced OFSAA Basel Technical Consultant is needed to design, develop, and support Basel regulatory reporting solutions for Oracle Financial Services Analytical Applications at a banking environment.

6 hours, 13 minutes ago

Oracle Security & Controls consultant 6 Months Contract

Belmont Lavan 11-50 Professional Services

Belmont Lavan Ltd is hiring an Oracle Security & Controls Consultant for a 6-month contract to assess, design, and implement security controls across Oracle environments that support data integrity, confidentiality, and regulatory compliance.

Oracle
6 hours, 28 minutes ago

Senior Database Developer

Astor & Sanders 51-250 Internet Software & Services

Astor & Sanders Corporation is hiring a remote Senior Database Developer to design, support, migrate, and optimize Oracle database solutions in multi-tiered, high-transaction environments.

6 hours, 28 minutes ago

Director, Data Management and Systems

Apogee Therapeutics 1-10 Biotechnology

Apogee Therapeutics is hiring a Director of Data Management and Systems to lead clinical data management operations, systems, and cross-functional data strategy across its clinical development programs.

GCP
6 hours, 43 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers