Senior Database Administrator

Mindsprint; Bengaluru; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Mindsprint in Bengaluru, India seeks an experienced SQL Server DBA to install, configure, and harden SQL Server across standalone and Always On/cluster setups. You will own patching, upgrades, backups, DR planning, and performance tuning while migrating workloads to AWS using DMS and RDS/EC2 options.

Expertise in HA/DR, security, and cost-aware licensing is required, with strong incident management and cross-functional coordination during cutovers.

Qualifications

• 6–9 years of experience as a SQL Server DBA/Administrator with production support.

Responsibilities

• Lead end-to-end migrations from on-prem SQL Server to AWS using AWS DMS and native tools.

Skills

SQL Server DBA

HA/DR

Performance Troubleshooting

Security

Incident Management

CloudWatch

DMS migrations

AWS services

Education

Bachelor's degree in CS/IT

Tools

AWS DMS

Amazon RDS for SQL Server

Aurora MySQL/PostgreSQL

MySQL

PostgreSQL

CloudWatch

Performance Insights

Job description

• 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

• 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.