Job Category: Tech Jobs
Hiring For: LTI Mindtree
Job Location: Bangalore Chennai Mumbai
Referral Bonus: Upto 15000
Experience: 5 to 8 Yrs
Salary Upto: Upto 2100000
Job Description:
We are seeking a highly skilled and experienced Senior MS SQL Database Administrator to join our team. The ideal candidate will have 5 to 8 years of experience in MS SQL database administration, with a strong understanding of database architecture, performance tuning, backup and recovery, and security best practices. The candidate should be able to work independently and as part of a team, possess excellent communication skills, and be able to manage multiple projects simultaneously.
Responsibilities:
- Design, implement, and maintain MS SQL database instances across development, testing, and production environments.
- Perform database performance tuning and optimization, including query optimization, index tuning, and database configuration.
- Monitor database system health and performance to ensure high levels of performance, availability, and security.
- Implement and maintain database security policies and procedures, including user access management, data encryption, and auditing.
- Plan and execute database backup and recovery strategies to ensure data integrity and minimize downtime.
- Troubleshoot and resolve database-related issues in a timely manner, including performance problems, database corruption, and connectivity issues.
- Work closely with developers, system administrators, and other stakeholders to support database-related projects and initiatives.
- Document database configurations, procedures, and best practices.
- Stay up-to-date with the latest developments in MS SQL database technology and best practices.
Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 5 to 8 years of experience in MS SQL database administration in a production environment.
- Strong understanding of MS SQL database architecture, including database design, normalization, and optimization.
- Experience with database performance tuning and optimization techniques.
- Proficiency in database backup and recovery strategies, including experience with SQL Server Backup and Restore functionality.
- Experience with database security concepts and best practices, including user access management, encryption, and auditing.
- Excellent troubleshooting and problem-solving skills.
- Strong communication and interpersonal skills, with the ability to work effectively in a team environment.
- Ability to manage multiple projects simultaneously and prioritize tasks effectively.
- Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: SQL Server Database Administrator Associate are a plus.