I’ve put together my best questions to ask during an interview when I’m hiring a senior database administrator for Microsoft SQL Server or Oracle. I don’t expect any DBA to ace all of these – I’m not looking for easy questions, but rather for the top ten questions, tough challenges to let the really good DBAs shine during the job interview.
10. Solve the FizzBuzz problem with SQL code.
Here’s a quote of the FizzBuzz problem:
Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which are multiples of both three and five print “FizzBuzz”.
Challenge the DBA to do this on a whiteboard with pseudocode. The code doesn’t have to be perfect syntax, but we’re looking for the ability to solve this problem clearly and quickly. I’d ask this of any type of DBA, production or development.
There’s countless ways to do this, but I’m almost not as concerned with their technical accuracy as I am with the way they approach the problem itself. Do they get excited? Do they scribble out a few different ideas? Are they stunned at the thought of having to actually write T-SQL? Do they make excuses?
9. I’m a manager, and you’re my Senior DBA. Explain to me why we shouldn’t switch to MySQL or Oracle.
A senior DBA should have a basic grasp of the advantages and disadvantages of the major database platforms. They’ve probably answered this question before, too – if not from a manager, then from a developer who’s whining because they think Platform X is better than Platform Y.
I also want to see senior DBAs that can clearly explain a very political concept without taking it personally. My ideal DBA knows when his platform isn’t the right fit, and has no problem suggesting other ideas.
8. I’m a developer. Explain why I need a unique key on my table.
And really pretend that you’re a developer. If you’re a DBA manager, bring in one of your toughest developers to play bad cop. Challenge them – does it really improve performance or manageability? How do you know? Is it just your opinion, or where’s the proof?
If they can explain it in clear, easy-to-comprehend terms, that bodes well for their ability to communicate with other teams. Speaking of inter-team communication…
7. A project manager needs a new SQL Server. What do you ask her?
Use a brochure from any third party application (like Microsoft Project Server or Blackberry Enterprise Server) and say the project manager wants to set this up. I want the DBA to ask questions like:
- How big will the database be? (Leading to questions about whether we can add the database to an existing server)
- How critical is the database? (Leading to questions about clustering, disaster recovery, high availability)
- What’s the company standard on virtualization? (Can we save money by using a virtual server)
If the senior DBA candidate comes back with a shocked look and doesn’t know where to begin, then they haven’t done a lot of deployments. That might be fine if your shop rarely does new deployments, or if you’re hiring a development DBA, but they still should have some basic knowledge about sizing.
6. When and where does the local user group meet?
I’m not asking if they regularly attend, I’m not asking if they speak, I’m not asking if they run for office. At the senior DBA level, I’d just be thankful if they were at least vaguely aware that user groups existed. Huge massive bonus points if they’ve been involved with the community, and I’d skip the next question.
5. Can you give me references from other DBAs and developers who aren’t at your company?
I want to know that they’ve got at least a couple of people they can call when the going gets rough and the servers catch fire. These other references could be mentors, or could be people they’ve mentored or just worked with along the way.
I expect to get terrified looks, and I’d answer those by saying, “I don’t want to raise any red flags by calling people at your current employer, and I’m sure you know people who’ve left your company and moved on. I just want to talk to people who’ve worked with you on projects or on problems. I won’t ask for your level of technical competency, because these other guys can’t judge that. I just want to know you’ve interacted with them.”
I know, it’s creepy, but here’s the problem: there’s a lot of fakers out there with all the right answers, but no actual experience. At the senior level, for somebody with five or more years of experience, they have to have met other people who can at least verify they’re database administrators.
4. How do you learn new things?
When new versions of database servers come out, how do you prefer to learn how to use ‘em?
Ideally, I want to hear a DBA say they build their own server under the desk when the beta comes out, and start hammering it and getting their arms around it long before it gets released. Not everybody has that much time, though – they might be stretched to the breaking point at their current job, with barely enough time to get their work done, let alone train on new versions. In that case, I like to level-set them by saying, “You’re coming to work here because we’re not that kind of shop. I want you to keep your knowledge current. How much time per month do you need to keep current, and how would you do it?”
Some DBAs learn best by going to offsite training classes, and can’t budget their time well enough or maintain a train of thought to learn inside the office. As a manager, you want to know that before you hire the person, so you can build that training budget into their salary. (You don’t want unqualified employees, do you? Yeah, you probably do – I’ve worked for you, ha ha ho ho.)
3. What third party database tools are your favorites?
If somebody’s been doing database administration long enough to claim the title Senior DBA, they’ve built up a little wish list of database management tools they’ve seen along the way. Tool types might include:
- Data modeling
- Change management
- Backup compression
- Performance monitoring
- Alerting
If they had a $X tool budget for their workstation, how would they spend it? Forget corporate standards – I want to know what tools they’d use if they could pick on their own. I’m not asking what software they’ve had experience using, because they might work somewhere so cheap that they’re restricted to native tools only. They have to have at least seen some ads for products that looked cool, though.
I might follow up with questions about tools we were using in-house already by saying things like, “We’re currently using Product X for monitoring. Have you seen it? What’d you think of it?”
This does two things: it gives me an outside opinion about other tools out there that my DBAs could be using to do a better job, and it tells me how much the job candidate has seen.
2. Ask stressful questions.
In one of the earlier questions, you probably found an area of weakness for the DBA’s knowledge – heck, nobody’s perfect. Go after that weakness. Challenge it, make them uncomfortable, and really push their buttons.
This is your one chance to see how they handle stress before the brown stuff actually hits the fan. Ideally, a senior DBA is someone who’s had their cage rattled more than once, and they’re comfortable under the gun.
No, don’t use an actual gun during the interview – but that reminds me of a plastic slot machine I used to keep on my desk at the office. When you pulled the lever, it shot water straight at you like a squirt gun. Always fun to see how somebody handled that one, but I wouldn’t let job candidates pull the lever. That’s a little overboard!
1. Why are you here?
Zoom out to the big picture. Tell me why you’re in this chair right now.
Is this some sort of career plan? Have they heard good things about the environment from another employee? Are they looking for an employee discount on products? (It doesn’t work at wine & spirits companies, just for the record.) Or are they just desperate? Nothing wrong with desperation, but remember that desperate employees are desperate for something, and you’d better find out what it is. If they’re desperate for money, it’s going to color the judgements they make. I’m not worried about someone stealing data and selling it as much as I’m worried about someone taking the job and then bailing out shortly thereafter for just a little more money from somebody else.
Top DBA Interview Questions That You Don’t See Here
I’ve seen DBA managers asking questions about tough challenges that had come up recently in the shop, such as, “Pretend you have horrible TempDB contention, really seriously bad load, and you have to fix it. What do you do?” The candidate would then name off all kinds of answers while the DBA manager sat back and said, “Nope. Didn’t work. Tried that too. Nope.” The DBA manager feels more and more smug while the candidate feels more and more frustrated, and the end result is a DBA manager that thinks the candidate isn’t good enough for the job.
The problem with that scenario is that the DBA manager expects the candidate to be able to answer a question that had already stumped their own staff. I always want to grab that manager and say, “Look, if I was interviewing YOU with this question, you’d have failed, because you couldn’t figure it out in sixty seconds either!”
If you’re going to ask a candidate a technical question, my rule of thumb is that it should take your existing staff the same length of time to answer the question. If a technical challenge took your staff three days to figure out, then you should expect the job candidate to take that same length of time to answer the question!
Want help interviewing your DBA candidates? Check out our services.
declare @n int, @oprint varchar(20)
set @n=1
while @n<=100
begin
set @oprint=null
if @n%3=0
set @oprint='Fizz'
if @n%5=0
set @oprint=isnull(@oprint,'')+'Buzz'
if @oprint is null
print @n
else
print @oprint
set @n=@n+1
end
First i will thanx for giving this kind of information …. but i dint did dba course yet…so i too also not have much knowledge about that ….but i want ot do dba course……how can i start the dba coursee from the begning ….i need ur help …..pls would u help me…..
regard
sahassan
Sahassan – thanks, glad you liked the post. I’ve got a lot of info about how to become a DBA here:
http://www.brentozar.com/sql/becoming-a-dba/
well i will thanx for givin tis kind of informatin….. but jst i completed my mca and also i completed sql server course…then i want to do dba course..now i can strt directly are i must learn any other course…. i need ur help
Rajitha – you can take training anytime you like, but do you have a job doing database work? If not, I’d start looking for the job first. I’d hate to have you end up with a bunch of expensive training and no job.
declare @Loop int; set @Loop = 1
declare @MaxLoop int; set @MaxLoop = 100
while @Loop @MaxLoop
begin
if @loop % 5 = 0 and @loop % 3 = 0
Print ‘FizzBuzz’
else
begin
if @loop % 3 = 0
Print ‘Fizz’
else
begin
if @loop % 5 = 0
Print ‘Buzz’
else
Print @Loop
end
end
set @Loop = @Loop + 1
end
Declare @num as Int
set @num = 1
While (@num <=100)
begin
If @num%3 = 0
Print 'Fizz'
if @num%5 = 0
Print 'Buzz'
if @num%5 = 0 and @num%3 = 0
Print 'FizzBuzz'
if @num%5 0 and @num%3 0
Print right(’0000′ + cast(@num as Varchar(3)),4)
set @num = @num + 1
Continue
End
DECLARE @n INT = 25
;WITH MyCTE (Num)
AS
(
SELECT 1 AS [Num]
UNION ALL
SELECT Num + 1 AS [Num]
FROM MyCTE
WHERE Num < @n
)
–SELECT * FROM MyCTE
SELECT Num
, CASE
WHEN (Num % 3 = 0) AND (Num % 5 = 0) THEN 'FizzBuzz'
WHEN Num % 3 = 0 THEN 'Fizz'
WHEN Num % 5 = 0 THEN 'Buzz'
ELSE CONVERT(VARCHAR, Num)
END AS [Mod3And5]
FROM MyCTE
set nocount on
declare @n int
set @n=1
while @n<=100
begin
if @n%5 = 0 and @n %3 = 0
begin
select convert (char (3),@n) + ' modulo of 3 and 5 = FizzBuzz'
if @@error != 0
begin
select 'failed to calculate modulo of 3 and 5'
end
end
else if @n %3 = 0
begin
select convert (char (3),@n) + ' modulo of 3 = Fizz'
if @@error != 0
begin
select 'failed to calculate modulo of 3'
end
end
else if @n%5 = 0
begin
select convert (char (3),@n) + ' is modulo of 5 = Bizz'
if @@error != 0
begin
select 'failed to calculate modulo of 5'
end
end
else
begin
print @n
end
set @n = @n+1
end
declare @i varchar(100) = 1
while @i < 101
begin
select
Case
when ((@i%3) =0) AND (@i%5 = 0) Then 'FizzBuzz'
when (@i%3) = 0 Then 'Fizz'
when (@i%5) = 0 Then 'Buzz'
Else @i
End
set @i = @i +1
End
declare @b as integer
set @b=1
while @b <= 100
begin
if(@b%3)=0 AND (@b%5) = 0)
print 'FizzBuzz'
else if(@b%3) = 0
print 'Fizz'
else if (@b%5) = 0
print 'Buzz'
else
print @b
set @b = @b +1
End
Thanks for providing good information…
I have complete my MCA, i dont want to do a job on programming so that i decided to do any non program course then my principal advise me to do DBA or Oracle so i join in DBA.. Now i have complete my DBA oracle course in this month. but where ever am applying for job there are specifying experiences. what should i do? Plz suggest me.
Hi. I’ve written about that here: http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/
DECLARE @a int
SET @a=1
WHILE @a <= 100
BEGIN
IF ((@a % 3 = 0) AND (@a % 5 =0))
PRINT ('FIZZBUZZ')
ELSE IF (@a % 3 = 0)
PRINT ('FIZZ')
ELSE IF (@a % 5 = 0 )
PRINT ('BUZZ')
ELSE
PRINT (@a)
SET @a=@a+1
END
If you want to get a feel for his or her’s query optimization skills I’ve found asking what a bookmark lookup seems to be a good one that trips a lot of people up.
declare i,a,b,y as integer
set i=1
while i <= 100
begin
if(i%3)=0 then a =1
else a=0
end if
if(i%5)=0 then b =2
else b=0
end
y=a+b
case y
y=0 print (i)
y=1 print ("Fizz")
y=2 print ("Buzz")
y=3 print ("FizzBuzz")
end case
end
i=i+1
loop
end
Great intuitive information. Keep them coming Brent. I’m a person that is getting my feet wet on SQL Server and looking to get certified and then move up to Oracle. I think this site will definitely help me. Thanks again
Just to be different. I’ve already got a tally table of sequential ints set up. So…
CREATE FUNCTION [dbo].[ufnGetFizzBuzz]
(
@Number int
)
returns nvarchar(50) as
begin
declare @retStr varchar(50) = NULL
if @Number % 3 = 0
set @retStr = N’Fizz’
if @Number % 5 = 0
set @retStr = N’Buzz’
if @Number % 3 = 0 and @Number % 5 = 0
set @retStr = N’FizzBuzz’
if @retStr = null
set @retStr = cast(@Number as nvarchar(50))
return @retStr
END
GO
select dbo.ufnGetFizzBuzz(number)
from WorkDB..TallyTable
where number <= 100