SQL Server DBA

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