JOB ID:QT-MA-09-743
We are seeking an experienced Azure SQL Server DBA with strong hands-on expertise in migrating SQL Server databases and infrastructure from on-premises environments to Azure Cloud. The role focuses primarily on lift-and-shift migrations of SQL Server VMs to Azure IaaS, along with installing, configuring, and managing SQL Server instances on Azure Virtual Machines, including Always On Availability Groups (AOAG) for high availability and disaster recovery. The candidate will assess existing on-prem SQL Server environments, including versions, sizing, dependencies, clustering, and existing AOAG configurations, and plan the appropriate Azure target architecture. Responsibilities include performing pre-migration compatibility, storage, network, and downtime assessments; executing migrations using Azure Migrate, Azure Database Migration Service (DMS), backup/restore, or log shipping; configuring SQL Server and OS settings; setting up WSFC, AOAG listeners, multi-subnet configurations, and AG replicas; and migrating existing on-prem AOAG topologies to Azure or implementing new configurations post-migration. The role also involves post-migration optimization and configuration of storage, disk types, caching, security, VNets, NSGs, firewalls, SQL Server settings, backups, maintenance plans, monitoring, and connectivity. The DBA will validate data integrity, failover functionality, synchronization, latency, and application connectivity, support cutover and rollback activities, conduct regular failover testing, troubleshoot AOAG and connectivity issues, and provide post-migration stabilization support. The candidate will work closely with infrastructure, networking, and application teams during migration windows and failover testing and will be responsible for maintaining detailed migration runbooks, AOAG architecture documentation, configurations, and lessons learned for each migration cycle.
