• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

Regular activities of SQL DBA

Can some one please help me in listing out L1,L2 & L3 activities for SQL DBA.

Thanks
0
stadmin
Asked:
stadmin
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
This depends a lot on the company landscape.
Basically I would say that on L1 there won't be any DBA. It's a first line of support so they only follow a script with questions to get more information and depending on the answer they can try to solve the issue or escalate to L2.
L2 in some companies also don't have DBA's but in some there are.
L3 is where the DBA's fits. If in L2 there are also DBA's then in L3 should be only for Senior DBA's / Specialists.

So, I would say these are the more common tasks for each level:

1.

Collecting information / Start, Cancel and Restart jobs / Start stopped services / Execute backups

2.

Collecting information / Start, Cancel and Restart jobs / Start stopped services / Execute backups and restores / Patch management / Kill processes

3.

Collecting information / Start, Cancel and Restart jobs / Start stopped services / Execute backups and restores / Patch management / Kill processes / Performance & Tuning / SQL Server install & uninstall / SQL Server configuration / Database upgrades & migration / Solve other incidents
And much more for L3 for sure but can't remember all now.
0
 
Kanti PrasadCommented:
Here is a full list for an Oracle DBA which will be more or less in line with what any DBA will do for any DB. Just tweak the Oracle word with the type of DB that is required to support...

http://datatab.blogspot.ie/2012/07/roles-and-responsibilities-of-oracle.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now