Sql Server Dba

Tata Consultancy Services; 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

Job Requirements

• Strong hands on experience as a SQL Server DBA
• In depth knowledge of SQL Server architecture, indexing, and internals
• Expertise in backup, recovery, and DR strategies
• Experience with Always On Availability Groups, Failover Clustering, and Log Shipping
• Strong skills in T SQL, performance tuning, and troubleshooting
• Experience working on Windows Server and basic OS administration
• Familiarity with monitoring tools and performance counters
• Understanding of database security and compliance best practices
• Good communication, documentation, and problem solving skills
• Install, configure, and administer Microsoft SQL Server (2012/2014/2016/2019/2022) environments
• Manage day to day database operations across Dev, Test, UAT, and Production
• Monitor database performance and availability; proactively identify issues
• Perform backup and recovery using full, differential, and transaction log backups
• Design and support High Availability & Disaster Recovery solutions using Always On Availability Groups, Failover Clustering, Log Shipping, and Replication
• Monitor and tune database performance using Query Store, DMVs, Execution Plans, and SQL Server Profiler
• Optimize queries, indexes, statistics, and database design for performance improvement
• Manage database storage including data files, log files, filegroups, and capacity planning
• Implement database security: logins, users, roles, permissions, encryption, and auditing
• Apply SQL Server patches, service packs, and cumulative updates
• Support database upgrades and migrations across SQL Server versions and environments
• Troubleshoot production incidents, perform root cause analysis, and resolve issues within SLA
• Coordinate with application and infrastructure teams during deployments and outages
• Automate routine DBA tasks using T SQL and PowerShell scripting
• Maintain database documentation, SOPs, and operational runbooks
• Participate in 24x7 production support and on call rotations

Salary Range: $110,000 - $130,000 a year

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.