Senior SQL DBA - High Availability & T-SQL Expert

JPS Tech Solutions Pvt Ltd; Cary (NC); On-site; USD 110,000 - 160,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd is seeking an Expert-Level SQL Database Administrator with hands-on experience across all aspects of SQL Server database administration. The ideal candidate will have strong expertise in SQL Server 2016 or later, Windows Server administration, performance tuning, backup and recovery, security, and high availability.

The role requires extensive experience with maintenance tasks, security controls, and disaster recovery planning.

Qualifications

• Six+ years of SQL Server 2016 or later DBA experience.
• Experience installing, upgrading, and maintaining SQL Servers, including service packs.
• Proficient in creating and scheduling SQL Server jobs for maintenance.
• Experience rebuilding indexes and updating statistics; running DBCC checks.
• Proficient with SQL Server native tools: Profiler, Extended Events, DMVs, and monitoring.
• Experience with security, auditing, encryption, and access controls for backups.
• Capacity planning for storage, WFSC, and object growth.
• Develop recovery procedures to meet RPO/RTO; test DR plans.
• Proficient in T-SQL, performance tuning, and ETL methodologies.
• Experience with high-availability methods including Always On and mirroring.

Responsibilities

• Design and implement SQL Server backup standards and schedules.
• Develop and test disaster recovery plans and run PIT restore drills.
• Perform routine maintenance: index rebuilds and statistics updates.
• Monitor logs, health checks, and performance metrics; respond to alerts.
• Configure security, authentication, encryption, and auditing for data at rest/in transit.
• Plan capacity and storage; manage WFSC and failover configurations.

Skills

SQL Server

T-SQL

Performance tuning

Backup & recovery

Security & auditing

High availability

Windows Server

PowerShell

Disaster recovery

Monitoring & diagnostics

Tools

SQL Server Profiler

Extended Events

DMVs

Index Tuning Advisor

SQL Server Configuration Manager

Performance Monitor

Linked Servers

MSDTC

SQL Server Broker

Job description

JPS Tech Solutions Pvt Ltd is seeking an Expert-Level SQL Database Administrator with hands-on experience across all aspects of SQL Server database administration. The ideal candidate will have strong expertise in SQL Server 2016 or later, Windows Server administration, performance tuning, backup and recovery, security, and high availability.

The role requires extensive experience with maintenance tasks, security controls, and disaster recovery planning.