Top Skills:
SqlPerformance MonitoringDatabase SystemsComplianceStatisticsDisaster RecoveryStorage SystemsHigh AvailabilityAuditingSql ServerQaDatabase AdministratorVersion ControlDatabase DevelopmentEncryptionDbaClusteringAuditingComplianceCompressionDatabase DevelopmentDatabase MaintenanceDisaster RecoveryEncryptionIndexingMitigationPerformance MonitoringQaQuorumSqlSql ServerT-sqlVersion Control
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) technologiesespecially 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 jobswhile 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 maintenanceindexing, statistics updates, integrity checks, growth management, filegroup management.
- Administer SQL Server instances across DEV, QA, UAT, PROD environments.
- Ensure security best practicesroles, permissions, encryption, auditing, and compliance.
- Support release deployments and schema changes using version control pipelines.
SQL Database Administrator
Ahead
naukri
Gurugram
3-6 years Not Disclosed
Full time
04 May 2026
Top Skills:
SqlPerformance MonitoringDatabase SystemsComplianceStatisticsDisaster RecoveryStorage SystemsHigh AvailabilityAuditingSql ServerQaDatabase AdministratorVersion ControlDatabase DevelopmentEncryptionDbaClusteringAuditingComplianceCompressionDatabase DevelopmentDatabase MaintenanceDisaster RecoveryEncryptionIndexingMitigationPerformance MonitoringQaQuorumSqlSql ServerT-sqlVersion Control
96
Get Personalized Job Matches with 1 Click
Job Description
Download ResumeWe 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) technologiesespecially 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 jobswhile 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 maintenanceindexing, statistics updates, integrity checks, growth management, filegroup management.
- Administer SQL Server instances across DEV, QA, UAT, PROD environments.
- Ensure security best practicesroles, permissions, encryption, auditing, and compliance.
- Support release deployments and schema changes using version control pipelines.