Data Migration Specialist

Required Skills & Experience

Microsoft SQL Server

• SQL Server 2014/2016/2017/2019 – Installation, configuration, administration, and migration
• SQL Server High Availability: Always On Availability Groups, Failover Cluster Instances, log shipping
• SQL Server security: Authentication modes, TDE, column-level encryption, auditing
• Performance Tuning: Query optimization, index management, wait statistics, execution plans, DMVs
• T-SQL – Expert-level scripting for database administration, migration validation, and automation
• SSIS, SSRS, SSAS – Compatibility assessment and migration considerations

Amazon RDS for SQL Server

• RDS SQL Server deployment: Instance class selection, storage configuration, parameter/option groups
• RDS Multi-AZ: Synchronous replication, automatic failover, maintenance windows
• RDS cross-region read replicas: Configuration, promotion, replicati...