SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Day to Day Responsibilty of DBA
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gangadhara.ms
Aged Yak Warrior

India
541 Posts

Posted - 11/27/2009 :  09:54:28  Show Profile  Visit gangadhara.ms's Homepage  Reply with Quote
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

USA
35953 Posts

Posted - 11/27/2009 :  12:54:15  Show Profile  Visit tkizer's Homepage  Reply with Quote
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."
Go to Top of Page

support.sql
Starting Member

USA
15 Posts

Posted - 11/28/2009 :  18:37:51  Show Profile  Reply with Quote

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
Go to Top of Page

chunduri
Starting Member

India
3 Posts

Posted - 02/26/2010 :  07:37:11  Show Profile  Reply with Quote
what are the daily activities on sql dba?

ravi
Go to Top of Page

chunduri
Starting Member

India
3 Posts

Posted - 02/26/2010 :  07:39:14  Show Profile  Reply with Quote
How to perform Log Shipping at Real time?

ravi
Go to Top of Page

Peter99
Constraint Violating Yak Guru

481 Posts

Posted - 02/26/2010 :  12:31:33  Show Profile  Reply with Quote
Most of the things are same as mentioned by Tara, but it depends where u work, i.e. production support dba or developer dba.
Go to Top of Page

chunduri
Starting Member

India
3 Posts

Posted - 02/28/2010 :  23:45:24  Show Profile  Reply with Quote
I need production support DBA

ravi
Go to Top of Page

Peter99
Constraint Violating Yak Guru

481 Posts

Posted - 03/01/2010 :  16:33:06  Show Profile  Reply with Quote
Then follow Tara instructions.
Go to Top of Page

gsuresh
Starting Member

India
22 Posts

Posted - 11/13/2012 :  12:00:37  Show Profile  Reply with Quote
thanks sir
suresh

suresh
Go to Top of Page

gsuresh
Starting Member

India
22 Posts

Posted - 11/13/2012 :  12:02:48  Show Profile  Reply with Quote
THANKS
suresh

suresh
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1912 Posts

Posted - 11/14/2012 :  11:02:12  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000