SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBA Interview Questions needed - Serious only please.


DBA Interview Questions needed - Serious only please.

Author
Message
CptCrusty1
CptCrusty1
Say Hey Kid
Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)

Group: General Forum Members
Points: 692 Visits: 387
Hi dudes and dudettes...

The boss and I are conviced that we need a dba since the 3rd party firm providing dba services isn't doing the best job. I know lots about SQL development; however, I know very very little about being a dba.

We received a resume from a person indicating many years exp with 2000/2005/2008 as a DBA; however, outside tricky SQL Questions, I'm not sure where to go from there.

I'm looking for:

--Generic DBA type things.
--Stuff that a mid-lvl dba should know.
--Advanced stuff that is rather obscure.

If you are kind enough to respond, please preface the answer with the level of difficulty you feel it has... . Oh... and the answer too.

When hiring the person, I'd like to make an informed decision. Thanks all... I really appreciate it.

Crusty.
GSquared
GSquared
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54325 Visits: 9730
I don't want to post interview questions and answers on a public forum, because they'll be mis-used by someone. Don't mean you, but these forums are public (effectively).

But, if you want to send me an e-mail, I can help that way.

Edit: In case you don't know, you can e-mail if you click my screen name to the left of this post. Has options for sending e-mail, reviewing posts, etc.

- 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
durai nagarajan
durai nagarajan
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3281 Visits: 2784
DBA level depends

is he/she going to take care of DB only.
will he/she take of storage/hardware for servers

kindly specify the details level for the DBA?

Regards
Durai Nagarajan
CptCrusty1
CptCrusty1
Say Hey Kid
Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)

Group: General Forum Members
Points: 692 Visits: 387
Durai,

Thanks for the reply. The previous poster (GSquared) made a valid point. Any tips you might have should probably be emailed.

The person will be a DBA only, but on occasion I can anticipate they might have some general SQL work to do. The current candidate indicates over 10 years exp... so they should probably have some advanced knowledge.

Thanks
Crusty
GilaMonster
GilaMonster
SSC Guru
SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)

Group: General Forum Members
Points: 210826 Visits: 46251
CptCrusty1 (8/24/2012)
--Advanced stuff that is rather obscure.


Just one point here... Unless your aim is to see if the person will make up garbage or admit they don't know, this probably should not be in an interview. Memorising obscure advanced stuff doesn't make someone a competent DBA and an interview should not be a trivial pursuit contest.

I mean, do you know the minimum and maximum sizes of a log block? If you do, when was that information last relevant?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


CptCrusty1
CptCrusty1
Say Hey Kid
Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)

Group: General Forum Members
Points: 692 Visits: 387
Well... I've never interviewed a DBA before. So... I at least want to get pointed in the right direction...
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)

Group: General Forum Members
Points: 93413 Visits: 33007
You might want to hire a consultant to do the interview for you. I know several people that are regularly doing interviews for employers that don't have the internal resources to get that interview done properly.

By the way, I do have a few, very basic, questions posted online. You'd have to know the answers to these to get in the door. They're so basic, I don't mind sharing. The fun stuff in an interview are after these.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Sachin Butala-182900
Sachin Butala-182900
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 439
you can follow Pinal @ SQLAuthority

he listed questions for basic to advanced.
GSquared
GSquared
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54325 Visits: 9730
Sachin Butala-182900 (8/27/2012)
you can follow Pinal @ SQLAuthority

he listed questions for basic to advanced.


I always find it interesting how many incorrect answers he has on that list. Even ones that are easy to disprove.

- 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
CptCrusty1
CptCrusty1
Say Hey Kid
Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)

Group: General Forum Members
Points: 692 Visits: 387
Sachin Butala-182900 (8/27/2012)
you can follow Pinal @ SQLAuthority

he listed questions for basic to advanced.


I read Pinal periodicly. He's a good source.

I also went to Grant's link in the previous post. Wow.. I'm certainly not a dba, but as a developer, I take pause... a lot of the high level discussion there makes me wonder, when does one get the time to read and study on this stuff? Between kids, wife, job, etc., I just can't seem to find the time to plug my brain with more spiffy stuff, unless it's work related....
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search