Title:  Team Lead

ROLE AND RESPONSIBILITIES
L2 Job Description
•    Routine Administrative Activities
•    Resolve incidents escalated by L1 as per the agreed SLAs and timelines.
•    L2 escalates the problem to L3.
•    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 a mail to team if any issues.
•    Work on incidents, change tickets and problem tickets.
•    Setup Maintenance plans for Backups, Database integrity check, rebuild index and 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.
•    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.
QUALIFICATIONS AND EDUCATION REQUIREMENTS
•    Bachelor’s degree in related field or equivalent work experience. 
•    Must have SQL server administration certificate.
PREFERRED SKILLS
•    DB alert monitoring and troubleshooting, Installation & configuration of SQL servers
•    Patching, AlwaysOn, Cluster, Mirroring, Replication and Log shipping