Roles (L1,L2,L3) in SQL Server DBA

Share via:

Dear Readers,

In this article, we will discuss Roles (L1,L2,L3) in SQL Server DBA.

Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a SQL Server Administrator.)

L1 Roles:
➼Check to make sure the SQL Server is online and connectivity is working fine.
➼Check error logs and if found any critical errors then escalate to L2 DBA
➼Ensure all (Full,differential and log)backups are running fine.
➼Check open tickets/issues and be sure issues/requests are addressed whitin SLA.
➼Ensure that no SQL Server job has failed and follow the SOPs if any job is failing.
➼Check the general health of the server (space, CPU utilization, memory) to confirm there are no issues.
➼Acknowledge every mail within SLA and if required escalte to L2 DBA.
➼Join bridge calls for P1(SEV1) and P2 (SEV2) incidents along with L2/L3 DBAs.
➼Make sure to respond to all the SQL DB alerts and take proper action.
➼Work on DB Refresh activity

L2 Roles:
➼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 intigrity 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.

L3 Roles:
➼Responsible for physical database architecture and design,capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
➼Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
➼Attend CAB ( Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
➼Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
➼Work on Writing custom stored procedures, t-sql queries , powershell scripts , views, and triggers based on requiremens for DB maintenance and automate tasks.
➼Work on writing technical and RCA(Root Cause Analysis) documentation.
➼Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
➼work on performance tuning like provide suggestions to crete indexes and tune stored procedures.
➼Troubleshoot recurring problems and fix them permanantly.
➼Conduct DB DR Drill activity , ensure to bring the DR site online if any outage at Primary site.


Thank you for giving your valuable time to read the above information.
Follow us on 
Facebook Page KTExperts Facebook
Linkedin Page : KT EXPERTS Linkedin

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Add Comment