01 Sep
|
Mindsprint
|
Bangalore Metropolitan Area
01 Sep
Mindsprint
Bangalore Metropolitan Area
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 AWSLead 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 My SQL/Postgre SQL, My SQL, 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, Po C, 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
Qualifications6–9 years as a SQL Server DBA/Administrator with robust 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 (My SQL/Postgre SQL), My SQL, 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.
📌 Senior Database Administrator (Bangalore Metropolitan Area)
🏢 Mindsprint
📍 Bangalore Metropolitan Area