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 tickets3. Work on dev/test/perf/... tickets4. Work on project tasks5. Proactive administration (performance mostly)6. Automating things when I can...Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://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 |
|
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 DBAravi |
|
|
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 sirsureshsuresh |
|
|
gsuresh
Starting Member
22 Posts |
Posted - 2012-11-13 : 12:02:48
|
THANKSsureshsuresh |
|
|
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) Coffee2) Any Fatal page\email alerts?3) Failed SQL Server Agent Jobs in the last 24 hrs4) Server System Errors in the last 24 hrs5) SQL Server Logs Critical in the last 24 hrs (includes Backup failures)6) SQL Server Login Failed Critical in the last 24 hrs7) DB2 diagnostics in the last 24 hrs (error and severe) 8) Performance Issues9) Consulting Key Questions:1) Are there any production systems not available? If so, Fix it2) Are there any Dev\Test\QA servers not available? If so, Fix it3) Are there any issues which might impact RPO,RTO and SLA? Fix ThemJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|