The Role
The SQL Database Administrator is responsible for maintaining the performance, security, and availability of SQL databases. Responsibilities include implementing High Availability solutions, optimizing database structures, developing T-SQL code, managing data archiving, and ensuring adherence to security standards.
Summary Generated by Built In
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 opportunity 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 embrace all candidates that will contribute to the diversification and enrichment of ideas and perspectives at AHEAD.
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 analysis, indexing strategies, statistics maintenance, parameter sniffing mitigation, etc.
- Collaborate with development teams to design efficient schema, indexing, and query strategies.
- 3. Data Archiving & Retention Management
- Design and implement database archiving frameworks for large/older datasets.
- Build automated archiving and purge jobs—while ensuring referential integrity and application continuity.
- Define data retention policies aligned with compliance and business requirements.
- Migrate historical data to secondary storage systems.
- 4. Partitioning & Large Dataset Management
- Implement and manage table partitioning for large-scale transactional data.
- Create and maintain partition functions, schemes, sliding windows, and partition switch strategies.
- Optimize data loading, maintenance jobs (index rebuilds, compression), and storage utilization.
- 5. Performance Monitoring & Tuning
- Monitor and troubleshoot CPU, memory, IO, tempdb, locking/blocking, and wait statistics.
- Optimize high-volume transaction environments and resolve performance bottlenecks.
- Configure and maintain SQL Server monitoring solutions (DMVs, Extended Events, PerfMon, third-party tools).
- 6. Database Maintenance & Operations
- Perform routine maintenance—indexing, statistics updates, integrity checks, growth management, filegroup management.
- Administer SQL Server instances across DEV, QA, UAT, PROD environments.
- Ensure security best practices—roles, permissions, encryption, auditing, and compliance.
- Support release deployments and schema changes using version control pipelines.
Why AHEAD:
Through our daily work and internal groups like Moving Women AHEAD and RISE AHEAD, we value and benefit from diversity of people, ideas, experience, and everything in between.
We fuel growth by stacking our office with top-notch technologies in a multi-million-dollar lab, by encouraging cross department training and development, sponsoring certifications and credentials for continued learning.
India Employment Benefits include:
Comprehensive health insurance coverage for employees, with options to extend coverage to dependents
Paid time off and company holidays, along with additional leave benefits as per policy
Flexible work arrangements, supporting work-life balance
Learning and development opportunities to support continuous growth and upskilling
Employee wellness initiatives and programs focused on physical and mental well-being
Retirement and statutory benefits in line with India regulations
Inclusive and people-first culture, with a strong focus on collaboration and ownership
Skills Required
- Deep expertise in SQL Server Always On Availability Groups
- Experience with Failover Clustering and multi-subnet deployments
- Proficiency in T-SQL for development and optimization
- Skills in data archiving strategies and partition management
- Ability to monitor performance and troubleshoot issues
AHEAD Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about AHEAD and has not been reviewed or approved by AHEAD.
-
Retirement Support — 401(k) contributions are matched dollar-for-dollar on the first $5,000 each year, with matching made each pay period and immediate 100% vesting. This structure signals above-standard employer support for retirement savings.
-
Affordable Benefits — Medical options include low employee premiums for PPO and HDHP plans, and the HDHP adds employer HSA funding plus a dollar-for-dollar HSA match up to stated amounts. Dental and vision plans list very low per-paycheck costs, helping keep overall healthcare spend manageable.
-
Wellbeing & Lifestyle Benefits — No-cost telemedicine (including virtual mental health when enrolled), free Calm access for the employee and dependents, and an EAP with counseling are included. Company-paid life and disability plus voluntary protections (legal/ID, pet insurance) and other extras round out a comprehensive set of supports.
AHEAD Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
AHEAD builds platforms for digital business. By weaving together cloud infrastructure, intelligent operations, and modern applications, we help enterprises deliver on the promise of digital transformation.
