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 Bangalore Metropolitan Area (India)
🏢 Mindsprint
📍 India