- Microsoft SQL Server (2014/2016/2017/2019) Administration & Migration
- AWS Database Migration Service (AWS DMS)
- Amazon RDS for SQL Server
- AWS Schema Conversion Tool (AWS SCT)
- SQL Server High Availability (Always On, Failover Clustering, Log Shipping)
- Performance Tuning, Query Optimization, T-SQL Scripting
- Database Security (TDE, Encryption, Auditing)
- Terraform or CloudFormation
- Migration Testing, Cutover Planning & Rollback Strategy
Responsibilities:
- Plan and execute SQL Server migrations to AWS.
- Configure and manage Amazon RDS for SQL Server environments.
- Use AWS DMS and AWS SCT for database migration and schema conversion.
- Implement high availability, backup, recovery, and security solutions.
- Perform migration validation, performance testing, and troubleshooting.
- Develop migration runbooks, cutover plans, and rollback procedures.
- Automate infrastructure provisioning using Terraform or CloudFormation.
Preferred Certifications:
- AWS Certified Database Specialty
- AWS Certified Solutions Architect Associate
- Microsoft SQL Server Certifications