SQL Server DBA

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 & amp; 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