| Author |
 Topic  |
|
|
gangadhara.ms
Constraint Violating Yak Guru
India
497 Posts |
 Posted - 11/27/2009 : 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
USA
35007 Posts |
Posted - 11/27/2009 : 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
USA
15 Posts |
|
|
chunduri
Starting Member
India
3 Posts |
Posted - 02/26/2010 : 07:37:11
|
what are the daily activities on sql dba?
ravi |
|
|
|
chunduri
Starting Member
India
3 Posts |
Posted - 02/26/2010 : 07:39:14
|
How to perform Log Shipping at Real time?
ravi |
|
|
|
Peter99
Constraint Violating Yak Guru
471 Posts |
Posted - 02/26/2010 : 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
India
3 Posts |
Posted - 02/28/2010 : 23:45:24
|
I need production support DBA
ravi |
|
|
|
Peter99
Constraint Violating Yak Guru
471 Posts |
Posted - 03/01/2010 : 16:33:06
|
| Then follow Tara instructions. |
|
|
|
gsuresh
Starting Member
India
22 Posts |
Posted - 11/13/2012 : 12:00:37
|
thanks sir
suresh
suresh |
|
|
|
gsuresh
Starting Member
India
22 Posts |
Posted - 11/13/2012 : 12:02:48
|
THANKS
suresh
suresh |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1773 Posts |
Posted - 11/14/2012 : 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 |
|
|
| |
Topic |
|
Day to Day Responsibilty of DBA
