Job Summary:
We are seeking an experienced Data Migration Lead to lead a large-scale cloud database modernization initiative involving the migration of transactional and analytical data workloads into AWS. This is a hands-on technical leadership role requiring direct ownership of enterprise database migrations from discovery and architecture through production cutover and stabilization. The candidate will define migration strategies, establish repeatable processes, provide technical direction to Data Engineers, and remain actively involved in resolving complex migration and data challenges. The role is expected to be approximately 50% hands-on technical execution and 50% technical leadership, with opportunities to influence migration standards and architecture as the AWS-based environment evolves.
Key Responsibilities:
• Lead the end-to-end execution of large-scale database and data migration initiatives.
• Own and continuously improve migration runbooks, playbooks, standards, and repeatable processes.
• Plan and lead mock migrations, production migrations, data validation, reconciliation, cutover, and post-migration stabilization.
• Provide day-to-day technical direction and oversight to Data Engineers performing migration activities.
• Review and validate migration designs, engineering approaches, implementation plans, and technical deliverables.
• Define and establish processes for migration preparation, execution, validation, troubleshooting, and production transition.
• Identify migration risks, architectural issues, data-quality concerns, and technical dependencies before they affect production.
• Participate in architecture and design discussions and recommend improvements based on previous enterprise migration experience.
• Work across transactional and analytical data environments to ensure reliable data movement between operational systems and downstream analytics platforms.
• Support data cleansing, transformation, source-to-target mapping, reconciliation, and validation activities.
• Guide schema conversion, data movement, and migration execution from SQL Server and/or Azure SQL to PostgreSQL-based environments.
• Establish and promote migration best practices as the AWS-based environment continues to evolve.
• Identify opportunities to improve existing migration approaches while working within established architectural guardrails.
• Collaborate with stakeholders and engineering teams to ensure successful migration delivery and production readiness.
Required Qualifications:
• Significant experience leading enterprise-scale database migration or modernization programs.
• Demonstrated ownership of database migrations throughout the complete lifecycle, including discovery, current-state assessment, migration architecture, and design.
• Hands-on experience with schema conversion, source-to-target mapping, data movement, and transformation.
• Experience planning and executing mock migrations, data validation, reconciliation, production cutover, troubleshooting, and stabilization.
• Strong hands-on experience with AWS data and database technologies.
• Strong understanding of transactional and operational databases and their differences from analytical data platforms.
• Experience migrating data from SQL Server and/or Azure SQL into PostgreSQL-based environments.
• Strong SQL skills and the ability to troubleshoot complex migration issues directly.
• Hands-on experience with data cleansing, transformation, and data-quality validation.
• Ability to provide technical leadership and guide Data Engineers while remaining actively involved in technical execution.
• Experience working with large-scale transactional and analytical data workloads.
• Ability to operate effectively in evolving environments, handle ambiguity, make technical recommendations, and improve existing approaches.
Preferred Qualifications:
• Direct experience leading SQL Server/Azure SQL to Amazon Aurora PostgreSQL migrations.
• Experience with Databricks, including data ingestion, cleansing, transformation, and data modeling using Medallion Architecture.
• Understanding of data movement between transactional databases and analytical platforms.
• Experience with large-scale analytical and compute workloads.
• Familiarity with downstream reporting and data consumption through Power BI.
• Experience with Amazon Aurora PostgreSQL, AWS Database Migration Service (DMS), AWS Schema Conversion Tool (SCT), AWS Glue, and Amazon S3.
• Familiarity with AWS-based data integration and migration patterns.
• Ability to personally lead an enterprise database migration end to end, including technical execution, engineering oversight, production cutover, and stabilization.
