MS SQL Server DBA - On Prem to AWS Migration

Cognizant Technology Solutions Corporation

Annapolis, MD, United States

12 days ago

Apply on www.techcareers.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

8 years minimum

Compensation

$110,000.0 - $130,000.0

Working hours

Regular working hours

Job source

www.techcareers.com

Tech stack

Amazon Web Services Amazon Elastic Compute Cloud User Authentication Backup Devices Cloud Computing Databases Disaster Recovery Failover Failover Clustering Log Shipping Microsoft SQL Server Windows Servers

+15 more

Performance Tuning SQL Server Reporting Services SQL Server Agent SQL Server Integration Services SQL Server Analysis Services System Availability Database Performance Indexer Amazon Virtual Private Cloud (VPC) Database Migration Database Mirroring Hardware Infrastructure Cloud Migration SQL Server Management Studio (SSMS) Network Server

Job description

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.

Requirements

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.