Day to Day Responsibilty of DBA

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Day to Day Responsibilty of DBA

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2009-11-27 : 09:54:28

Dear All,
I just want to know what are all the day to day activities of DBA who is having 2.5 to 3 years of experience.Don't refer any links for this i just want to know from real practical DBA's here.Also if anybody tell me the what is an approximate salary for an 3 years DBA in India.
As i see most of the time DBA job is automated for some extent, what he will be doing in the remaining working hours.
If you answer from your real experience it will be very helpful for me to make my carrier as DBA.

Thanks in Advance,
Gangadhar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-27 : 12:54:15

I can't remember what I did when I only had 2.5-3 years of experience, but I'll describe my day anyway.

1. Check the email alerts to see if anything needs to be addressed. We use MOM to monitor our environments, so MOM notifies us of issues.
2. Work on production tickets
3. Work on dev/test/perf/... tickets
4. Work on project tasks
5. Proactive administration (performance mostly)
6. Automating things when I can
...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

support.sql
Starting Member

15 Posts

Posted - 2009-11-28 : 18:37:51

Please review this article, it contains interesting information about your question.

http://www.mssqltips.com/tip.asp?tip=1240

SNM

Try Free Microsoft SQL Server Data Collector & Performance Monitor.

http://www.analyticsperformance.com

@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

chunduri
Starting Member

3 Posts

Posted - 2010-02-26 : 07:37:11

what are the daily activities on sql dba?

ravi

chunduri
Starting Member

3 Posts

Posted - 2010-02-26 : 07:39:14

How to perform Log Shipping at Real time?

ravi

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2010-02-26 : 12:31:33

Most of the things are same as mentioned by Tara, but it depends where u work, i.e. production support dba or developer dba.

chunduri
Starting Member

3 Posts

Posted - 2010-02-28 : 23:45:24

I need production support DBA

ravi

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2010-03-01 : 16:33:06

Then follow Tara instructions.

gsuresh
Starting Member

22 Posts

Posted - 2012-11-13 : 12:00:37

thanks sir
suresh

suresh

gsuresh
Starting Member

22 Posts

Posted - 2012-11-13 : 12:02:48

THANKS
suresh

suresh

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-11-14 : 11:02:12

My normal routine - if everything goes according to plan.

1) Coffee
2) Any Fatal page\email alerts?
3) Failed SQL Server Agent Jobs in the last 24 hrs
4) Server System Errors in the last 24 hrs
5) SQL Server Logs Critical in the last 24 hrs (includes Backup failures)
6) SQL Server Login Failed Critical in the last 24 hrs
7) DB2 diagnostics in the last 24 hrs (error and severe)
8) Performance Issues
9) Consulting

Key Questions:
1) Are there any production systems not available? If so, Fix it

2) Are there any Dev\Test\QA servers not available? If so, Fix it

3) Are there any issues which might impact RPO,RTO and SLA? Fix Them

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources