Tag Archive: juniordba

How to Get a Junior DBA Job – Part 3

In the final part of my three-part series on how to get a junior DBA job (Part 1), it’s time to talk about mentoring and training, and how they affect your salary.

Ask About Mentoring and Training

During the interview, ask how many other database administrators are on the team and what their seniority levels are. These are the people you’ll be learning from – your future mentors. If you’re joining a team of three people who’ve been DBAs since SQL Server 7.0, you’re in good hands. If there’s one other person who was a developer until about a year ago, things are going to be tougher because he’ll have less time to mentor you and less skills to pass on. If there’s no other DBAs at all, you’re screwed – you’re going to learn things the hard way.

Training - You're Doing It Wrong

Training - You're Doing It Wrong

You should be willing to take a lower salary if you find a company with a strong, friendly group of DBAs and a management team that’s committed to ongoing training.  Consider it an investment in your career.  Finding out how committed they are is simple: have you seen their DBAs at the local user group meeting?  If so, then they’re interested in furthering their career and helping out with the careers of others.  If you’ve never seen their DBAs at a local PASS Chapter meeting, then their lack of interest in the community might predict a lack of interest in training you, too.

What’s that, you say?  You haven’t been to a local PASS meeting yet?  Then maybe YOU aren’t too interested in your own training, either.  This is why the PASS chapter question is one of my Top 10 Interview Questions to Ask Senior DBAs.  Plus, the more often you go to PASS meetings, the more the other database administrators will see you there, and if they recognize you during your interview meeting, that’s bonus points.  Imagine the post-interview conversation after you leave: “I remember seeing that guy at the SQL Server user group chapter.  I don’t remember the other candidates, come to think of it.”  Cha-ching!

Asking about the company’s training budget during the interview is a tougher one: it’s hard to ask this question without making it sound greedy. This one is a judgement call. There’s only one case where the training costs are considered a built-in part of your hiring, and that’s if you go to work for a consulting company.

Going to Work as a DBA-in-Training

Some consulting companies will take you on at a lower pay rate in exchange for teaching you DBA skills while you’re on the job. They have a large talent pool to draw from (compared to individual companies) and they can put you onsite with a senior person. The consulting company makes money off you, because they’re paying you a far lower rate than they’re billing the client. You get to learn from the senior person, and you take over as many tasks from them as possible.

The consulting company may require you to sign a contract stating you’ll work for them for a certain amount of time, and if you leave any earlier, you’ll be responsible for paying training costs. I have really, really bad vibes about this setup, because you’re basically becoming an indentured servant. The consulting company can treat you like dirt, and here’s the funniest part to me: they don’t really care whether you get trained or not. They’re making money off you every single day that you show up for work.

If you take this approach, here’s a few things to keep in mind:

  • Don’t sign an agreement – frankly, every job involves learning on the job, and the company is making money off you every day anyway. I would love to get the chance to ask one of these interviewers, “So, did you learn anything on the job this month? Did you have to pay anybody for that privilege?”
  • Get the training costs prorated – if you have to sign a two-year agreement and you quit after one year, then you should only be responsible for 50% of the training costs. If they tell you that the bulk of the training occurs in the first year, then get the agreement to only span one year.
  • Be very wary of non-compete agreements – some consulting companies have non-compete agreements saying you can’t work for any of their customers for X years after you quit. Even worse, some say you can’t work for any PROSPECTIVE customer – which basically means any company in their market. As part of the interview process, ask for a copy of any agreements that you’ll need to sign. Otherwise, if you only get a copy of this agreement after you’ve already quit your current job, you’re screwed.
  • Work hourly, not salary – the consulting company is making money off you by the hour, and they will work you as long and as hard as possible. Your salary needs to be a win/win for both you and the consulting company.

Don’t Regret Your Asking Price

No matter who you work for, salary negotiations suck, and I don’t have any good tips for how to pick your rate. However, I do have advice about what to do after you’ve picked your rate: write it down somewhere and tell yourself, “I am going to be happy if I get a junior DBA job for $X/year.” Put that piece of paper somewhere safe. Later, when you find out how much your coworkers or your friends are making, don’t get mad: get that piece of paper out and think back to what you were feeling like when you wrote those words down. You wanted a DBA position so bad, and you couldn’t figure out how to get in. In order to get your foot in the door, you took a salary that made sense at the time.

Some Days You're the Tire

Some Days You're the Tire

The last thing you want is to get six months into your new junior DBA position, find out that all your coworkers are making twice as much as you are, and feel like you got screwed.

Hmm – Lots of Screwing Going On Here

More than once in these posts, I’ve said you can get screwed. This emphasizes a point I made in the first article: it’s easier to get promoted than to get hired. The money’s usually not as good, but if you’re just doing this for money, you’re in the wrong profession.

The first year or two of database administration is very challenging: you’re suddenly in charge of one of the company’s most expensive and risk-prone assets. There’s a lot of after-hours maintenance work, and when your cell phone rings, you gotta answer it anytime, anywhere. It can be scary taking over this position. The less risks you take, the easier your transition is, and that’s why getting promoted eases your transition path.

Once you’re in, though, it’s the most fulfilling and rewarding career I know. I heartily recommend database administration to anybody in IT.

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

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

How to Get a Junior DBA Job – Part 1

So you’re hearing all the fun that DBAs are having on Twitter and around the intertubez, and you’re wondering how to get in on the fun.  Maybe you’re a developer or a network admin, and you’ve been learning about SQL Server from books and from peers, and you’re starting to look around for your first Junior DBA job.

Where Are the Junior DBA Job Ads?

Search for the terms “junior dba” or “senior dba” on national job sites, and the results are dramatically different:

To make matters worse, drill into the requirements for some of the so-called junior positions and they ask for:

  • “2+ years of hands-on experience administering customer-facing databases”
  • “Minimum 2 years of information technology experience is required”
  • “2 years of database administrations experience including installation and configuration”

These ads make me chuckle because a DBA with two years of hands-on experience isn’t looking for his next junior DBA job – he’s aiming for his first senior DBA job.  People don’t aspire to make lateral moves – they aspire to move up the ladder.

So we’ve started to establish that it’s not just you: there aren’t junior DBA ads sitting around waiting for takers.

Why Aren’t More Companies Hiring Junior DBAs?

Databases are among a company’s most valuable assets.  They hold sales data, payroll data, information about customers and competitors, and all kinds of proprietary data.  Companies guard this data closely, and they don’t want just anybody stepping up to the server to handle backups, restores, and security configuration.

Companies may be willing to hire junior developers instead – for some reason, they don’t have a problem giving a fresh-out-of-college person access to all the data.  But when it comes time to actually managing the data, they want someone experienced.

As a result, even when a small company with a handful of SQL Server instances goes shopping for a DBA, they want someone experienced.  They want to hear from the candidate, “Yes, I can do what you need – I’ve already done this for a much larger shop, and I’ve got experience handling this sort of thing.”  They sleep better at night knowing their DBA is not stressed out trying to figure out how to automate backups for the first time.

Every now and then, big companies will actually hire junior DBAs.  This mostly happens when they’ve already got a crew of senior DBAs, but here’s the odd part: they don’t have anyone internally that wants to get promoted into the DBA team.  That’s very peculiar, because in companies large enough to have DBAs already, they often have people in other teams who want to become DBAs.

Know Your Competition: Other Junior DBA Candidates

The few available junior DBA positions attract a few kinds of candidates:

  • Developers with a year or more of SQL Server programming experience who’ve decided they want to focus on SQL Server instead of development.  They’ve written code that stores data in SQL Server, so they know the basics of T-SQL or LINQ, understand the basics of data models, and maybe they’ve even done a little SQL Server administration on their dev boxes.
  • Windows administrators with a year or more of Windows experience who also want to switch their focus.  These people know hardware, know the basics of performance tuning, have backup/restore experience, and maybe they’ve even built a cluster or two.  They might have even built SQL Servers, but they haven’t been working on SQL Server full time.
  • SQL Server DBAs who’ve been let go, and they’re desperate.  They might have worked for a company in financial trouble, they might have been drinking on the job, who knows.  These are your most dangerous competitors, because at first glance, their resumes kick sand on your resume.
  • College grads or training grads with no experience.

If you’re in that last category, I gotta be honest: you’re screwed.  Go get a job as a junior developer or a junior Windows admin first, and then work your way into database administration.  There is no classroom training that’s going to convince a company to hand over the keys to their data on your first day in the office.  You may see ads for certification programs that promise to make you DBA-ready within a week for a few thousand dollars.  It won’t get you the job – at least, not when you compare yourself to the competition.  After you’ve gotten started in a development or sysadmin position working around SQL Server, come back here and continue reading about how to take it to the next level.

Getting Promoted is Easier than Getting Hired

If you’re a developer or Windows admin, try to get promoted internally rather than switching companies.  You’ve already built up a level of trust with your coworkers.  Make yourself the natural candidate by actively going after the position before the position even exists: volunteer to spend time with the DBAs, help them during scheduled outages, or just ask if you can sit around and watch during the weekend maintenance windows.  Bring coffee, donuts and bacon, and be the most pleasant (but not over-the-top) person in the room.

If you’ve already got a job in close proximity to SQL Server, this is one of the times where getting certified in SQL Server without getting the job first does make sense.  I’ve blogged about how certification is the icing on the cake: don’t get certified without at least some vague experience in SQL.  Developers and Windows admins will gain knowledge from the certification training process, and it’ll buy them a little bit of credibility in the eyes of the DBA team.  Not a lot – but some.

If you dislike the DBA team at your company, I’ve got bad news: you’re probably going to dislike most DBA teams, and switching companies isn’t going to make things better.  However, if you’re absolutely determined to jump ship, there’s a few things you can do to make the hiring process easier, and I’ll explain those in my next post.

Part 2: You CAN Get DBA Experience Without a DBA 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