10 Aug
|
Mindsprint
|
Bengaluru
10 Aug
Mindsprint
Bengaluru
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 DBA/Administrator with robust production
📌 Senior Database Administrator (Bengaluru)
🏢 Mindsprint
📍 Bengaluru