Senior Database Administrator

SQL Server Administration

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

Migration to AWS

\n
• 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).
\n
• 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.
\n
• 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).
\n
• Build migration runbooks: discovery, assessment, PoC, dry runs, cutover, and post‑migration validation (data parity, performance, security).
\n
• Optimize network and connectivity (VPC, security groups, VPN/Direct Connect, parameter groups, option groups).
\n

Troubleshooting & Reliability

\n
• 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.
\n
• Respond to P1/P2 incidents, conduct root cause analysis (RCA), and implement preventive measures (alerts, runbooks, automation).
\n
• Monitor and tune AWS RDS/Aurora parameters, storage autoscaling, IOPS, and CloudWatch alarms.
\n

Required Qualifications

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

Education

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

Soft Skills

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