MS SQL Server DBA - On Prem to AWS Migration

Cognizant; Carson City (NV); On-site; USD 110,000 - 130,000; Full time

Job summary

Cognizant is seeking an experienced MS SQL Server DBA L3 to support a large-scale migration of SQL Server environments from on-premises to AWS. The ideal candidate will have strong expertise in SQL Server administration, cloud migration, performance tuning, high availability, and production support.

The role is open to remote candidates located in the US. Applicants must be authorized to work in the US without visa sponsorship.

Qualifications

• 8+ years of hands-on Microsoft SQL Server DBA experience.
• Experience migrating SQL Server workloads to AWS or other cloud platforms.
• Strong knowledge of EC2, EBS, VPC, Security Groups, and cloud-based SQL Server operations.
• Expertise in installation, configuration, patching, backup/recovery, performance tuning, and troubleshooting.
• Experience with High Availability and Disaster Recovery technologies (Always On AGs, WSS/WFC, FCIs, Replication, Log Shipping, Mirroring).

Responsibilities

• Lead end-to-end migration of Microsoft SQL Server databases from on-premises to AWS (primarily SQL Server on Amazon EC2).
• Assess existing SQL Server environments, dependencies, backups, HA/DR configurations, and migration readiness.
• Design and execute migration, cutover, validation, and rollback plans.
• Install, configure, and maintain SQL Server environments on AWS.
• Perform database migrations using Backup/Restore, Log Shipping, Replication, Always On, and other migration approaches.
• Support cutover activities and post-migration stabilization (hypercare).
• Troubleshoot database performance, availability, connectivity, backup, and security issues.
• Create migration runbooks, SOPs, validation checklists, and operational documentation.
• Collaborate with application, cloud, infrastructure, security, and business teams throughout the migration lifecycle.

Skills

Microsoft SQL Server

SQL Server 2019

SQL Server 2022

High Availability

Performance tuning

Always On

Backup/Recovery

Failover Clustering

Log Shipping

Replication

Security

AWS migration

Amazon EC2

Tools

SSIS

SSRS

SSAS

SQL Agent Jobs

Job description

Cognizant is seeking an experienced MS SQL Server DBA L3 to support large-scale migration of SQL Server environments from on-premises infrastructure to AWS. The ideal candidate will have strong expertise in SQL Server administration, cloud migration, performance tuning, high availability, and production support. Applicants must be authorized to work in the US without any visa sponsorship. Cognizant will not sponsor visas now or anytime in the future.

Key Responsibilities

• Lead end-to-end migration of Microsoft SQL Server databases from on-premises environments to AWS (primarily SQL Server on Amazon EC2).
• Assess existing SQL Server environments, dependencies, backups, HA/DR configurations, and migration readiness.
• Design and execute migration, cutover, validation, and rollback plans.
• Install, configure, and maintain SQL Server environments on AWS.
• Perform database migrations using Backup/Restore, Log Shipping, Replication, Always On, and other migration approaches.
• Support cutover activities and post-migration stabilization (hypercare).
• Troubleshoot database performance, availability, connectivity, backup, and security issues.
• Create migration runbooks, SOPs, validation checklists, and operational documentation.
• Collaborate with application, cloud, infrastructure, security, and business teams throughout the migration lifecycle.

Required Skills & Experience

• 8+ years of hands-on Microsoft SQL Server DBA experience.
• Strong experience with SQL Server 2008 R2, 2012, 2014, 2016, 2017, 2019, and 2022.
• Proven experience migrating SQL Server workloads from on-premises to AWS or other cloud platforms.
• Strong knowledge of Amazon EC2, EBS, VPC, Security Groups, and cloud-based SQL Server operations.
• Expertise in SQL Server installation, configuration, patching, backup/recovery, performance tuning, and troubleshooting.
• Experience with High Availability and Disaster Recovery technologies including:
• Always On Availability Groups
• Windows Server Failover Clustering
• Failover Cluster Instances (FCI)
• Replication
• Log Shipping
• Database Mirroring
• Strong experience with Query Store, execution plans, indexing, deadlock analysis, TempDB optimization, and performance tuning.
• Experience supporting SQL Server security, authentication, service accounts, certificates, and encryption.
• Experience migrating SQL Server dependencies including Linked Servers, SQL Agent Jobs, SSIS, SSRS, and SSAS.

Preferred Qualifications

• AWS certifications a plus.
• Experience with large-scale migration programs and migration factory models.
• Strong communication, stakeholder management, and documentation skills.

The role is open to remote candidates located in the US. The salary range for this role is between $110,000 to $130,000 depending on skills and qualifications of the candidate. Applications will be accepted till 9/20/2026.

Cognizant is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.