April 19, 2011 at 7:33 am
What DBA tasks can be given to a developer who can help me in some of my DBA tasks who is not a DBA but i would like to train her in few areas so that she can be of some help to me.
Just want to through out here so that i get some ideas who were already in this situation.
April 19, 2011 at 7:53 am
Won't speak for everyone, but I was given the grunt work. When jobs failed, it was my job to find out why and report them to the DBA and provide an answer on what is the correct course for correcting the issue. Additionally, small task like restoring testing or staging environment where good practice to see if they can do restores without pressure and to see if they understand how they work.
As examples:
- Why did XX Job fail last night and how can we stop it from happening again.
- Restore Developer XXX test box for them. They need it restored to YY:ZZ time.
- Setup a new opperator that will send error alert/emails when a job fails. Change the following jobs.
- Review this query and tell me what you believe needs to be done to optimize it. The guy who trained me had already done it so he had an answer ready. I was also given a time limit to do it in. He would also have me walk through what I did to get the results.
- A new developer just got hired. Write a script to create his login and user accounts and access permissions. We would then go over it.
These items started me on my path to being a DBA. They were non pressure or small pressure situations that I got hands on learning from. If I screwed up, I didn't take down servers. Yet, it got me familar with the processes so that when there was a crisis, I wasn't learning on the fly.
Hope this helps.
Fraggle
April 19, 2011 at 8:39 am
You say you want to train her "on certain areas", but not what those are.
Are you looking into performance tuning, or admin, or security, or something else?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply