SQL Database Administrator

Role: MSSQL Database administrator

Experience: 6 to 12 Years

Job Location: Bangalore/Hyderabad/Chennai

Hybrid Mode

Shift Timings: 24x7 rotating shifts - 2-11 PM IST

Full Time Employment with LTIMindtree

Notice Period: Immediate to 30 days

Please do not apply Notice Period with more than 30 days

Primary Skill: MS-SQL Database administrator

Secondary Skill: PostgreSQL DBA

• Installation/Upgradation/Migration of SQL Servers.
• Apply any patches or service packs for SQL Server.
• Configure High Availability/Disaster recovery solutions.
• Configure automated alerts to send mail to the team if there are any issues.
• Work on incidents, change tickets and problem tickets.
• Setup Maintenance plans for Backups, Database integrity check, Rebuild index, Update statistics, and make sure to run all the jobs without any issues.
• Troubleshoot locking issues, including deadlocks, blocking, lock timeouts and fix them.
• Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
• Hands on Experience in on Always on and DB Mirroring
• Execute all changes of db schema and maintain controlled development database environment.
• Work closely with application developers to test, configure, and optimize servers based on application demands.
• Handle database object deployment to Integration, QA, UAT, and Production
• Provide day to day support of high OLTP HA of SQL Server databases- Identify root causes of production problems and work with developers to resolve such problems.
• Work on performance tuning like creating missing indexes.
• Willingness to work in 24X7 projects (Shifts)
• Experience in scripting using perl, power shell.
• Experience in AWS/Azure.

Added Advantage:

• Any of the following certificate:
• SQL Server certifications.
• SQL Cloud based solutions and experience.

Thanks & Regards,

Prabal Pandey

Prabal.Pandey@alphacom.in