Role: Lead Database Migration Engineer Azure & SQL Development Expert
Experience: 8+
Location: Remote
Overview
We are seeking an experienced Senior Database Migration Engineer with strong expertise in SQL development, on-premise to Azure cloud migration, and Azure Data Factory (ADF). The specialist will drive design, development, and execution of database migration projects, focusing on scalable, optimized cloud data solutions and seamless integration with Azure services.Key Responsibilities
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Lead end-to-end migration of SQL Server databases from on-premises to Azure cloud.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Design, develop, and maintain robust Azure Data Factory (ADF) pipelines for modern data integration and orchestration.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Develop complex T-SQL queries, stored procedures, and functions to support efficient data transformation and migration.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Modernize legacy SSIS workflows by migrating them to ADF pipelines.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Collaborate with data architects and infrastructure teams to integrate ADF with Azure Blob Storage, Synapse Analytics, Key Vault, and other services.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Optimize SQL and data pipelines for cloud performance, scalability, and reliability.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Implement CI/CD for data workflows and pipelines using Azure DevOps, PowerShell, and Logic Apps.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Plan and execute migration strategies ensuring data quality, security, and minimal downtime.
Required Skills And Experience
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> 6+ years of proven SQL development and cloud migration experience.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Expertise in Microsoft SQL Server with strong T-SQL scripting capabilities.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Hands-on experience with on-premise to Azure database migration projects.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Deep proficiency in designing and managing Azure Data Factory (ADF) pipelines.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Experience migrating SSIS packages to ADF and implementing modern cloud ETL/ELT solutions.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Knowledge of Azure services including Blob Storage, Synapse Analytics, Key Vault, and Databricks.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Familiarity with CI/CD tools and automation using Azure DevOps, PowerShell, and Logic Apps.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Strong analytical and troubleshooting skills in cloud data environments.
Must-Have Tools and Technologies
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Microsoft SQL Server & T-SQL
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Azure Data Factory (ADF)
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Azure Blob Storage, Synapse Analytics, Key Vault
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> SSIS (experience migrating to ADF)
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Azure DevOps
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> PowerShell / Logic Apps
Preferred Qualifications
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Microsoft Certified: Azure Data Engineer Associate or equivalent certifications.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Experience with big data services such as Azure Databricks or Delta Lake.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0> Understanding of cloud data security and compliance best practices.
Skills: database development,azure data factory,database migration,ssis,ci/cd,devops,database,sql server intergation services,azure,sql,etl,azure key vault,powershell scripting,azure blob storage,azure synapse,transact-sql (t-sql),pipelines
