MS SQL Database Administrator Job at Tata Consultancy Services, Framingham, MA

VWpRZWN1UWJQNjNzOFR1cWlKNTlIWlVYVEE9PQ==
  • Tata Consultancy Services
  • Framingham, MA

Job Description

Job Description Database Installation, Configuration, Upgrades, Management and Administration. Performance Tuning and Troubleshooting Backup, Recovery and High availability Cloud and automation experience is added plus Experience in Cost optimization and following Security and compliance is added plus. Installation, Configuration and Upgrade of MS SQL Database Managing database schemas, tables, indexes, users and security roles Performing backups, restore and recovery Monitoring database performance and optimizing queries and capacity Identify and resolve bottlenecks tuning and optimizing to ensure HA and responsiveness manage resource usage and to ensure scalability and reliability including blocking, deadlock and tempdb performance Expertise in SQL profiler, tuning, Query store Experience in Disaster recovery strategies and maintaining data integrity, log shipping, mirroring and failover clustering Experience in executing backup and recovery procedures Automating jobs with SQL server agent and PowerShell. Roles & Responsibilities Installation, Configuration and Upgrade of MS SQL Database Managing database schemas, tables, indexes, users and security roles Performing backups, restore and recovery Monitoring database performance and optimizing queries and capacity Identify and resolve bottlenecks tuning and optimizing to ensure HA and responsiveness manage resource usage and to ensure scalability and reliability including blocking, deadlock and tempdb performance Expertise in SQL profiler, tuning, Query store Experience in Disaster recovery strategies and maintaining data integrity, log shipping, mirroring and failover clustering Experience in executing backup and recovery procedures Automating jobs with SQL server agent and PowerShell. 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: Commute r 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.

# LI-RJ2

Salary Range - $100,000-$130,000 a year Seniority level Entry level Employment type Full-time Job function Information Technology Industries IT Services and IT Consulting Referrals increase your chances of interviewing at Tata Consultancy Services by 2x Boston, MA $89,301.33 - $114,816 2 months ago Massachusetts, United States $65 - $75 2 days ago Bedford, MA $115,000 - $125,000 8 hours ago Randolph, MA $73,000 - $75,000 2 weeks ago Boston, MA $112,597.33 - $152,810.66 3 weeks ago Massachusetts, United States $119,000 - $169,500 4 days ago Sr. Data Engineer - High-Growth Tech Startup Massachusetts, United States $108,000 - $182,500 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr Tata Consultancy Services

Job Tags

Full time,

Similar Jobs