MS SQL Database Administrator
Tata Consultancy ServicesFramingham, MA, United States1 day ago
Job type
- Full-time
Job descriptionDatabase 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.
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.
- 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.
TCS Employee Benefits Summary :
# LI-RJ2 Salary Range - $100,000-$130,000 a year
Create a job alert for this search
Sql Database Administrator • Framingham, MA, United States