System Administrator
Tata Consultancy Services - Plano, Texas, us, 75086
Work at Tata Consultancy Services
Overview
- View job
Overview
Must Have Technical/Functional Skills: Primary Skill: SQL server development DBA Admin. Secondary: Tableau. Experience: Minimum 10 years. Roles & Responsibilities:
Install, configure, and maintain SQL Server instances (on-premises and/or cloud). Monitor system health and performance, ensuring high levels of performance, availability, and security. Perform database backups, restores, and disaster recovery planning. Implement and maintain database security (authentication, authorization, encryption). Manage and automate maintenance plans, indexing, statistics, and job schedules. Troubleshoot database issues including blocking, deadlocks, and performance bottlenecks. Design and implement HA/DR solutions (e.g., AlwaysOn Availability Groups, Log Shipping, Clustering). Perform capacity planning and manage storage growth. Apply patches and updates, and upgrade database versions when necessary. Collaborate with developers and analysts on schema design, queries, and stored procedures. Maintain documentation of processes, configurations, and best practices. Salary Range - $85,000-$115,000 a year
#LI-NS2