SQL Server Administration
- Install, configure, and harden Microsoft SQL Server (2016/2017/2019/2022) in standalone and Always On (AGs) / cluster configurations.
- Own patching, service packs, cumulative updates , and in‑place/side‑by‑side upgrades with rollback plans.
- Implement and maintain backup/restore strategies (Full/Diff/Log), log shipping , and DR (site failover tests).
- Manage security : logins, roles, permissions, encryption (TDE), auditing, and compliance (e.g., CIS benchmarks).
- Performance management: indexing strategies, query tuning (execution plans), statistics maintenance, I/O & memory tuning , and baseline + capacity planning .

Migration to AWS
- Lead end‑to‑end migrations from on‑prem SQL Server to AWS using AWS DMS and native tools (BACPAC, backup/restore, log shipping, replication, SSDT).
- Migrate to Amazon RDS for SQL Server or Amazon EC2 SQL Server , and perform heterogeneous migrations to Aurora MySQL/PostgreSQL, MySQL, or PostgreSQL when required.
- Assess schema and code compatibility (e.g., SQL Server features not supported in target engines),



recommend refactoring or alternatives, and plan cutover strategies (full load + CDC, blue/green, canary).
- Build migration runbooks: discovery, assessment, PoC, dry runs, cutover , and post‑migration validation (data parity, performance, security).
- Optimize network and connectivity (VPC, security groups, VPN/Direct Connect, parameter groups, option groups).

Troubleshooting & Reliability
- Diagnose and resolve issues during and after migrations: DMS task failures, CDC lag, data type mismatches, collation conflicts, LOB handling, constraint/index rebuilds, long‑running queries , and replication/log shipping breaks .
- Respond to P1/P2 incidents , conduct root cause analysis (RCA), and implement preventive measures (alerts, runbooks, automation).
- Monitor and tune AWS RDS/Aurora parameters, storage autoscaling, IOPS, and CloudWatch alarms.

Required Qualifications
- 6–9 years as a SQL Server

📌 Senior Database Administrator (India)
🏢 Mindsprint
📍 India