DBA Responsabilities - SQL Server Forums

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)

DBA Responsabilities

Author

Topic

kanj
Starting Member

5 Posts

Posted - 2008-12-14 : 04:05:29

Dir Sirs,

I'm certified in SQL Server 2005(MCTS) and don't have a real experience in my MCTS... I will be interviewed for a SQL DBA job and will be asked about my future resposabilites...

So anyone can help me on this(Best Practices,Which objects to monitor?,Which Alerts to use?,Security plan strategy,....)

I know it will be an open question but need help in this...

So, am waiting your valuable reply,

Many thanx in advance.

Kanj

mikebird
Aged Yak Warrior

529 Posts

Posted - 2008-12-14 : 07:22:44

I have been winging my way in a DBA / Developer job for years and learning as I go. I know most of it by learning from mistakes, being fired and starting again. I'm very confident that I've learnt stuff I wouldn't have learnt from books.

I am about to take the MCTS SQL Server 2005 Implementation & Maintenance exam 70-431 on Tuesday so my CV will look better with a load of experience. Do you have any tips for me? Did you pass first time? I'm a guru with interviews... 300+

In your interview, before you do or say anything, listen to the interviewer(s) and work out if they are database experts or know nothing. If they don't seem to know much and are looking to you for expertise then confidently speak of your knowledge. Say you'll have to get to know their databases first.

They won't be ASKING you about your future responsibilites... they'll be telling you them...

mikebird
Aged Yak Warrior

529 Posts

Posted - 2008-12-14 : 07:24:44

Ask this forum once you're IN the job and you know exactly what you're facing

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-12-14 : 11:01:43

quote:
Originally posted by kanj

Dir Sirs,

I'm certified in SQL Server 2005(MCTS) and don't have a real experience in my MCTS... I will be interviewed for a SQL DBA job and will be asked about my future resposabilites...

One piece of advice - don't exaggerate your experience. If you have very little, admit it.
If you claim to have lots of experience but don't demonstrate that in your answers, it will be apparent that you're lying.

--
Gail Shaw
SQL Server MVP

kanj
Starting Member

5 Posts

Posted - 2008-12-15 : 05:48:08

Hello mikebird,

yes I passed on the first time but it was difficult, especially the simulation part... so give me your mail address to send you the microsoft kingtest file....... it will be helpfull..

my email address is: kanj1100@hotmail.com

Kanj

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-12-15 : 06:21:12

Be aware that testking (and many like it) are braindumps and it's a violation of the exam NDA to pass these around (not to mention that they are copyrighted materials). If caught, you are risking having all of your certifications revoked, permanently.

--
Gail Shaw
SQL Server MVP

kanj
Starting Member

5 Posts

Posted - 2008-12-17 : 05:27:18

GilaMonster,

Thanx for your advice.

Kanj

kumar_kunda
Starting Member

5 Posts

Posted - 2008-12-17 : 10:03:15

May Be

kumar

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-17 : 10:04:18