SQL Server DBA

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

Benefits offered by this job

Annual incentive

Medical coverage

Parental Leaves

Insurance options

Commuter benefits

Training reimbursement

Vacation & holidays

Legal assistance

401K plan

Job summary

Tata Consultancy Services is seeking a senior SQL Server DBA to manage large production databases in a Windows environment. You will install, configure, and optimize SQL Server instances across multiple environments, ensuring performance, security, and availability.

Responsibilities include daily operations, backups, HA/DR design, patching, and collaboration with application and infrastructure teams. Strong T-SQL and scripting skills are required; 24x7 support duties may apply.

Qualifications

• Experience as SQL Server DBA in large prod environments.
• Strong knowledge of SQL Server internals and indexing.
• Experience with HA/DR and backups in Windows Server environments.
• Familiarity with monitoring tools and performance counters.

Responsibilities

• Install, configure, and administer SQL Server environments (2012-2022).
• Manage daily DB operations across Dev, Test, UAT, Production.
• Monitor performance and availability, proactively address issues.
• Perform backups and recoveries using full, differential, and log backups.
• Design HA/DR solutions with Always On, Failover Clustering, Log Shipping, Replication.
• Tune queries, indexes, and storage for performance.
• Apply patches and upgrades across SQL Server versions.
• Support deployments with other teams during outages.
• Automate tasks with T-SQL and PowerShell.
• Maintain documentation and runbooks; participate in 24x7 support.

Skills

SQL Server DBA

SQL Server architecture

Backup and recovery

Always On Availability Groups

T-SQL

Windows Server

Monitoring & performance

Security & compliance

Production databases

Communication & documentation

Education

Bachelor of Computer Science

Job description

Job Description

Must Have Technical/Functional Skills

• 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
• Experience supporting large, mission critical production databases
• Good communication, documentation, and problem solving skills

Roles & Responsibilities

• 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.

Qualifications: BACHELOR OF COMPUTER SCIENCE