How to Get a Junior DBA Job – Part 2

Yesterday I talked about why companies aren’t hiring junior DBAs, and today I’ll talk about how you can get in the door anyway.

Companies are Cheap, and DBAs are Expensive

Even in a healthy economy, companies want to get a bargain.  They want to hire an experienced senior database administrator for junior DBA wages.  They think they’ve got something special – a great work environment, flexible working hours, nice plants in the lobby – and that it offsets the lower wages.  It doesn’t: good senior DBAs get good money, and have their pick of companies.

Some companies take the approach of hiring remote DBAs who telecommute.  I have a blog series coming up about getting & keeping a job as a telecommuting DBA, but that doesn’t work for junior DBAs.  Juniors need mentoring and training that’s difficult to get in a home office environment.  For your first DBA job, don’t be tempted to apply for a remote job, because you’re setting yourself up for failure.

Instead, throw your hat in the ring for local senior DBA jobs.  It’s not career suicide: it’s a case of the company asking for something unrealistic.  They may not get the candidates they want for the price they want to pay, and that’s your chance to get your foot in the door.  Don’t exaggerate your reputation, of course – be honest about your skill level and your experience, but at the same time, don’t sell yourself short.

You’re Working with SQL Server, Right?

I got my start as a developer and as a network admin (here’s the story).  When I went to look for my first pure SQL Server job, I didn’t have much on my resume and I didn’t really think I was all that qualified.  If anything, I underestimated the bejeezus out of what I put on the resume.

When I started hiring other DBAs, though, I remembered my own experience.  As a result, when I interviewed DBA candidates, I had a checklist of skills that I’d ask them, like:

  • Have you ever had to restore a single table’s contents?
  • Have you set up log shipping, or done troubleshooting on it?
  • Have you ever built a server connected to a SAN?

Go pick up a SQL Server administration book, look at the table of contents, and check off everything that you’ve actually done.  Even if you’ve only done it a few times, put it on your resume and explain that you’ve dabbled in it, because it’ll give you a big edge over the other candidates.  Don’t say that you’re an expert on the topic, by any means, but the fact that you’ve done it is a plus.

More often than not, I’d hear candidates answer, “Well, yeah, but hasn’t everybody done that?”  Actually, no – some candidates haven’t.  Every single skill that you performed in production – not in theory – is another reason why you might get the job.  Even if you’ve only done it once a quarter for a year, that means something.

Senior DBA

Senior DBA

How Long Have You Been Doing It?

Did your boss ask you to start backing up a SQL Server a year ago?  Last year, did you start restoring the production database onto your desktop for development testing?  Did you start working on making stored procedures a year ago?

Presto, you have a year of experience.

I can almost hear the angry emails coming in now from really senior DBAs who do this stuff full time, nonstop, for a living, but they’ve forgotten how junior-level experience works.  People don’t get handed the keys to the enterprise on Day 1 and start some kind of master clock.  Experience happens gradually, almost imperceptibly.  There’s no knighting ceremony where the CIO taps you on both shoulders with a laser pointer.

This is why so many junior-level DBA positions ask for a year or two of experience: they’re expecting to hear from developers and sysadmins who’ve been dabbling with database tasks over time, getting their feet wet.  I don’t want to hire somebody who’s never seen SQL Server Management Studio: I want to hire a developer who installed SSMS a year ago and has been dabbling with it ever since.  He may not like going in there – it may scare the pants off him – but as long as he’s been going in there grudgingly and tapping his terrified fingers on the keyboard to get his job done, then that’s a plus in my book, because I’ll train him the rest of the way.  DBA training never ends.

Training and mentoring is the way junior DBAs become senior DBAs.  In the last post of the series tomorrow, I’ll talk about what you should – and shouldn’t – expect in the way of training from a new employer, and how that affects your asking price.

Part 3: Getting DBA Training On the Job

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

60 Responses to How to Get a Junior DBA Job – Part 2
  1. gin
    June 15, 2011 | 5:28 AM

    Hi Brent,

    Again, I want to applaud you and to thank you for being ‘here’ all the time. For making this site. I forgot how i found your blog. But I’m glad I did. You’re like the ‘constant’ professional people like me looking for advice can come to get REAL and SOUND advice. Unlike advice from a university course advisor for example. Coz, you are INDUSTRY based. :D

    Ok, cut to the chase – here’s the question. Like your answer to Pat’s question, we need to contact people we’ve worked with before, rely on network to get a start on some form of DBA career.

    What if a person has NONE of those? Some job questions usually ask, how many PROJECTS you have done/implemented using….. SQL., or Oracle, or etc…

    Is there a way you can get SOME FORM of experience without WAITING for the right connections/ right job?

    Hope it makes sense what I’m asking.

    • Brent Ozar
      June 15, 2011 | 5:40 AM

      If you have no experience and no network, you can’t get a DBA job. I can’t be any more clear than that. Companies won’t give you the job of safeguarding their data.

      • gin
        June 16, 2011 | 11:18 PM

        i know what you’re saying. I understand. :(

  2. Larry Smith
    June 15, 2011 | 9:08 AM

    Gin,

    Go for C# .Net developer or SQL developer. Those technologies are hotter than SQL DBA and are less arrogant.

    If you want to become a DBA then: Buy books with Labs, install SQL 2008 R2 developer edition (free), go for certifications because hiring managers look for it, work hard, read SQL DBA interview questions, go to SQL forums and read/answer/post questions, do as many interviews as you can.

    All DBA will tell you that its hard to become a DBA but all depend in the company that you apply (If you want to start your DBA administrator career applying for a 500 fortune company then you will not get the job).

    I knew a Oracle DBA who was hired by company without experience (The company knew that he did not have experience but technical background). Now, he has +5 years of ORALCE DBA experience and he is still working for the same company.

    Good Luck,

    Larry Smith

    • gin
      June 16, 2011 | 11:22 PM

      Hiya Larry,

      Thank you for your kind directions and leading. You’re awesome.
      THANK you for sharing your knowledge.

      Thank you so much for your awesome constructive advice.

      Please keep coming back on here.

  3. WayneS
    June 15, 2011 | 7:26 PM

    VOLUNTEER!
    There are bound to be non-profit organizations in your area that would be happy to let you work for free. You get experience that way.

    Or, see if your current position will let you start doing DBA work in conjunction with your other tasks. They might need a little bit of help, but not enough to justify hiring someone.

    • gin
      June 16, 2011 | 11:23 PM

      Thank you WayneS,

      I am looking into that…..

Leave a Reply

Wanting to leave an <em>phasis on your comment?

Notify me of followup comments via e-mail. You can also subscribe without commenting.