Database Administrator

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/Postgre

SQL, MySQL, or Postgre

SQL  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  Cloud Watch  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/Postgre

SQL), MySQL, or Postgre

SQL .
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  Cloud Watch ,  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
Strong 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.