12 Sep
|
AHEAD
|
Gurugram
AHEAD builds platforms for digital business. By weaving together advances in cloud infrastructure, automation and analytics, and software delivery, we help enterprises deliver on the promise of digital transformation.
At AHEAD, we prioritize creating a culture of belonging, where all perspectives and voices are represented, valued, respected, and heard. We create spaces to empower everyone to speak up, make change, and drive the culture at AHEAD.
We are an equal chance employer, and do not discriminate based on an individual's race, national origin, color, gender, gender identity, gender expression, sexual orientation, religion, age, disability, marital status, or any other protected characteristic under applicable law, whether actual or perceived.
_
We are seeking a highly skilled SQL Server Database Administrator (DBA) responsible for ensuring the availability, performance, security, and scalability of critical database systems. This role demands deep expertise in High Availability (HA) technologies—especially Always On Availability Groups, data archiving strategies,
and table partitioning for large-scale OLTP/OLAP workloads and database development
Key Responsibilities:
- 1. High Availability & Disaster Recovery
- Design, configure, maintain, and troubleshoot SQL Server Always On Availability Groups for mission-critical environments.
- Manage Failover Clustering (WSFC), quorum configuration, and multi-subnet deployments.
- Monitor and optimize replication lag, failover readiness, and AG health states.
- Develop, maintain, and test DR strategies, including geo-replication and failover runbooks.
- Implement backup/restore strategies using Full, Differential, Log backups, copy-only backups, and automated validation.
- 2. Database Development & Optimization
- Develop and optimize T-SQL code, stored procedures, functions, views, triggers, and scripts.
- Review SQL code for performance, security, and standards compliance.
- Tune workloads using execution plan
📌 SQL Database Administrator (Gurugram)
🏢 AHEAD
📍 Gurugram