SQL Server DBA – HA/DR, T-SQL & 24x7 Ops

Tata Consultancy Services Limited; St. Louis (MO); On-site; USD 110,000 - 130,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Medical Coverage (Medical, Dental, Vis

Disability Insurance

Pet Insurance Plans

Parental Leaves

Commuter Benefits

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services Limited is seeking a skilled SQL Server DBA in the United States to manage and optimize SQL Server environments across Dev, Test, UAT, and Production. You will implement HA/DR strategies, optimize queries, and ensure high availability and security of databases.

The ideal candidate has extensive experience with Always On, Failover Clustering, Log Shipping, and Windows Server administration, plus strong scripting and documentation skills.

Qualifications

• Demonstrated hands-on experience as a SQL Server DBA with enterprise workloads.
• Deep knowledge of SQL Server architecture, indexing, and internals.
• Proven ability to implement backups, recovery, and DR strategies across environments.
• Experience with Always On Availability Groups, Failover Clustering, and Log Shipping.
• T-SQL proficiency, performance tuning, and troubleshooting across multiple versions.
• Experience on Windows Server and basic OS administration; monitor performance
• Familiarity with monitoring tools and performance counters; security practices.
• Strong documentation, communication, and problem-solving skills.

Responsibilities

• Manage day-to-day operations across Dev, Test, UAT, and Production databases.
• Monitor performance and availability; pro-actively identify issues and bottlenecks.
• Perform backups and restores using full, differential, and log backups.
• Design HA/DR solutions using Always On, Failover Clustering, and Log Shipping.
• Tune queries, indexes, statistics, and designs for performance gains.
• Coordinate deployments with app and infra teams during outages.
• Automate routine tasks with T-SQL and PowerShell scripting.

Skills

SQL Server DBA

SQL Server Architecture

Backup & DR strategies

Always On Availability Groups

Failover Clustering

Log Shipping

T-SQL

Performance tuning

Windows Server

Monitoring tools

Security & compliance

Documentation

PowerShell scripting

Tools

SSMS (SQL Server Management Studio)

SQL Server DMVs

Query Store

SQL Server Profiler

PowerShell

Job description

Tata Consultancy Services Limited is seeking a skilled SQL Server DBA in the United States to manage and optimize SQL Server environments across Dev, Test, UAT, and Production. You will implement HA/DR strategies, optimize queries, and ensure high availability and security of databases.

The ideal candidate has extensive experience with Always On, Failover Clustering, Log Shipping, and Windows Server administration, plus strong scripting and documentation skills.