Whether you’re applying for a DBA job or getting ready to hire a DBA, you probably don’t know what questions to ask to tell if somebody really knows what they’re doing or not – or what answers to look for.
There’s the classic tired question, “Tell me the difference between a clustered and nonclustered index,” but after that, what?
In our new DBA Job Interview Q&A course, you’ll hear:
- 1. Core DBA Questions (23m)
- 2. Infrastructure Questions (19m)
- 3. Development DBA Questions (20m)
- 4. Screenshot Questions (13m)
- 5. Open-Ended Questions (10m)
- 6. Bad DBA Job Detector Test (19m)
- 7. Questions For YOU to Ask
Heck – let’s just go ahead and get started with the Development DBA Questions module right now for free. (If you can’t see the video below, you’re reading this on an RSS reader or off-site – head over to the blog post.)
Wanna see the rest? It’s part of our DBA Subscription – normally $39/month, but use coupon code Relaunch2017 and get off at $19.50/month.
9 Comments. Leave new
answer 11 has a typo …manipuLate or return data…
It should also read “one or more statements”…
Great list of questions… thanks Brent,
I would only suggest that, if a candidate for developer DBA can’t explain the difference between an INNER JOIN and LEFT OUTER JOIN you should give them a smile, pat them in the shoulder, save yourself and that candidate time, and tell them to come back after they have finished reading their first Learn SQL in 20 days Book.
It would really take a lot of convincing to do that I should hire a guy that can’t even explain that basic concept… just my humble opinion…
Martin – what you’ll learn when you do interviews is that there’s a wide gap between knowing something and being able to explain it. 😉
Good point… although I hope you agree that If a DBA (especially a developer DBA… who is probably doing a lot of education to other devs) can’t explain things clearly they are at a disadvantage when compared to other candidates.
Communication is a soft skill that is very important, maybe not to all, but to most Dev DBAs.
Again. Thanks for all the great work. Thanks to your site and the people on your team my DBA job is way more fun these days!
Martin – right, that’s why it’s a question in the interview. Thanks!
I missed the coupon by 2 days! Don’t make me go to Plural Sight, You guys are way cooler….
Jamie – sorry, bud, I gotta be fair to folks who played by the rules. 😉
I would have been disappointed had you buckled. Hopefully I’ll be negotiating a salary soon and the number will be pretty much be the number. (Thanks to the valuable training I’m about to soak up.)
I’ve been on the other side of the table for about a decade now and loved to trip people up. Phone interviews so bad, I just drop off the call.
And in person interviews that made me squirm for the candidate. (But I didn’t put down that I was an expert in Exchange 2008 or walk past someone working on a SQL server which I guess entitles you to put it on a resume)
Looking forward to it and if I crash and burn…. I’ll send you my resume, I’m sure there is something I can do around your office. 😉