MS SQL Database Administrator

TATA Consulting Services•Framingham, MA

51d

About The Position

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.

Requirements

Database Installation
Configuration
Upgrades
Management and Administration
Performance Tuning and Troubleshooting
Backup, Recovery and High availability
Cloud and automation experience
Cost optimization
Security and compliance

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.

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume