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 DBA/Administrator with strong production support experience.
- Proven hands‑on delivery of on‑prem → AWS database migrations using AWS DMS (full load & CDC).
- Practical experience with Amazon RDS for SQL Server and migrations to Aurora (MySQL/PostgreSQL), MySQL, or PostgreSQL.
- Deep understanding of HA/DR (Always On AGs, log shipping, backups/restore strategies).
- Proficient with Performance Troubleshooting (execution plans, waits, locks/latches, tempdb, memory & storage).
- Solid grasp of security (TDE, auditing, least privilege, secrets management).
- Comfortable with CloudWatch, Performance Insights, and general AWS services (VPC, IAM, KMS, S3, EC2, RDS).
- Excellent incident management, communication, and stakeholder coordination during cutovers.
- Knowledge of cost optimization and licensing considerations for SQL Server on AWS.
- Certifications: AWS Certified Database – Specialty, AWS Solutions Architect – Associate/Professional, Microsoft DP‑300 / MCSE (or equivalent).

Education

- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent practical experience).

Soft Skills

- Solid ownership and problem‑solving mindset.
- Excellent documentation and communication skills (clear runbooks, status updates, RCAs).
- Ability to work in fast‑paced, on‑call environments and lead cross‑functional war rooms.

📌 Senior Database Administrator (Karnataka)
🏢 Mindsprint
📍 Karnataka