Data Migration Specialist

Required Skills & ExperienceMicrosoft SQL ServerSQL Server 2014/2016/2017/2019 – Installation, configuration, administration, and migrationSQL Server High Availability: Always On Availability Groups, Failover Cluster Instances, log shippingSQL Server security: Authentication modes, TDE, column-level encryption, auditingPerformance Tuning: Query optimization, index management, wait statistics, execution plans, DMVsT-SQL – Expert-level scripting for database administration, migration validation, and automationSSIS, SSRS, SSAS – Compatibility assessment and migration considerationsAmazon RDS for SQL ServerRDS SQL Server deployment: Instance class selection, storage configuration, parameter/option groupsRDS Multi-AZ: Synchronous replication, automatic failover, maintenance windowsRDS cross-region read replicas: Configuration, promotion, replication lag monitoringRDS security: VPC security groups, encryption at rest (KMS), SSL/TLS, IAM database authenticationRDS monitoring: Enhanced Monitoring, Performance Insights, CloudWatch metricsRDS backup: Automated backups, snapshots, cross-region snapshot copy, point-in-time restoreRDS limitations: CLR, linked servers, SQL Agent, FILESTREAM constraintsDatabase Migration Tools & TechniquesAWS DMS –