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:
- CareerBuilder – 296 senior, 27 junior
- Dice – 65 senior, 2 junior
- HotJobs – 170 senior, 19 junior
- Monster – 122 senior, 15 junior
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.
Need to practice for your next interview?
We can help! We’ve got an online course that teaches you how to ace DBA job interview questions.
224 Comments. Leave new
I swear you are reading my mind and answering questions that I’ve been thinking about for weeks now!
Can’t wait ’til part 2. Thanks!
Ditto. As someone who is trying to advance his SQL knowledge to become a DBA, I am eagerly awaiting your next installment.
Also if you come from a development background, keep an eye open for database developer or development DBA jobs, in addition to Junior DBA. Even though you do a lot of t-sql development, these jobs many times work closely with production DBAs (keeping the server up running well) and may allow you to pick up some more advanced SQL administration skills to use further down the line to obtain a job in a full-time DBA role if that is what you desire.
If you have experience with writing SQL through a development job, shoot for those jobs that say 2+ years required. You might just have enough experience to fill the requirements of the position, even if you haven’t spent 2+ years fully devoted to supporting/writing sql.
i have 2 yrs exp in IT and from that 1 yr in sql devlpmnt but now i have opportunity to do job for dba bt they are refusing to give because they are saying how we can give db activity job to you when you dont have dba knledge , hw we can give you data base ccess wen you dnt hav dba bckgrund
Sunil – you can start by fully typing out words. Companies want their database professionals to care about data integrity, and leaving out letters puts you in a bad light.
I agree with you Sir , fully typing means that you have some respect for the reader … 🙂 . DBA is very complicated than just a simple sentence.
True 😉
I’ll wait with David Stein for the next installment of this yet another great Ozar series!
I have been wondering this for 20+ years when I first started looking a job in the computer field and seeing ads for Oracle positions that all required 2+ years. How can anyone get an Oracle job when they all required min 2 years??
I was surprised by this, because I only hire entry-level and junior DBAs and it comes down to money. I can’t afford to hire an experienced DBA, but I can train someone who is smart and eager to become a DBA.
Hi Sarah,
I am Ibrahim Kadtal have completed my dba core and RAC. As your comment in this blog. I am eagerly searching job in dba. I made my passion to be dba but i am strugling due to fresher as said Brentozar. Help me.
I eager to become a dba………….
hiii sarah…..
i m agree with u…but no one company hiring fresher oracle dba..
i mm also looking oracle dba in india,
i have done post graduate in computer MCA,
i have done oracle certified…
well known about RAC..
Data guard
Sir, I am looking for entry-level.
Temin – cool, let us know what you find.
Are you looking to hire an entry level DBA? I am OCA and i am looking for a job. hope to hear from you.
Hi, sarah i am a fresher and searching for a DBA job,and i am OCA certified in oracle 11g…
Can you please give me the opportunity to be hired as an entry level DBA
I wish,please how can u be of help to me
Abraham – read the post.
Hi Sarah
hope all is great , I really want to build a career as a DBA. I passed the 1z0-051 and now, i am studying hard to go in for 1z0-052. Your opinion about training someone is a great idea . Would love to have a session with you. rogert45@gmail.com.
regards
Rogers
Sarah – you’re totally right, and I talk about that in part 3 on Friday! First-timers should look for companies with a strong senior team that’s willing to mentor them. You’re a great example.
hi, sarah i am fresher and searching job as dba, and i done with my SQL Expert and OCA certification in oracle 10g…
plz give me right direction to become a junior DBA
Hi, Ankita. Our advice is right up above this comment in the post itself. Enjoy!
hello there!
i have solid training for “sql developer” and try to get stepped in the field, but i don’t have ‘any related experience” at all , & just “associate degree ” in “political science” ,
also, i don’t want to ‘exaggerate” about my experience in my ‘resume” ,
what’s ur recommendation please?
Regards
kash
Kash – realistically, you’re not going to get a DBA job. You need to get a developer or sysadmin job as I explained in the other posts in the series.
HI Brent
i Trained PL/SQl, n m looking to step forword in database field.but i don’t have any releted experiance ,as i am working Desktop support l1 in MNC company..and i did my degree in Computer Application .i need your suggest that how to get job in data base field…
thanks & Regards
Krishna Kumar Reddy
Please tell me about jobs on actual work environment done by Jr. DBA.
I’m not sure I understand the question – can you rephrase it?
I’m looking into starting a bachlors in computer science or information systems but am afraid that I will not be able to find a job straight out of school, I have 10 years of work expierence but not in it. any advice. would a concentration in networking be any better?
It depends on your work experience. If you’ve been working with computers for the last several years, then yes. Otherwise, you’re probably going to have a rough time, and you might end up in an internship at very low pay. Generally speaking, a Bachelor’s degree isn’t going to be enough by itself.
I’d ask why you’re getting into computers. If it’s just to make money fast, those days are over, and you’d do better with a different degree focus that will make you more valuable to more people.
If it’s just to make money fast, those days are over, and you’d do better with a different degree focus that will make you more valuable to more people.
This begs the question. What specifically would you recommend as a degree focus that will make you more valuable to more people?
Thanks
Dennis – actually, I wouldn’t recommend a college degree as a Plan A for a secure living for the rest of your life. College degrees are expensive, and the choice of major comes at a horrible time in one’s life. You’re not really equipped to make a $100k gamble on what degree will work for you personally. I do recommend college just for a year or two of building a network, but if you’re into programming, you might be able to build a startup or go to work for one without slogging through college.
Brent, I see what your saying regarding skipping college and its popular advice these days in the blogosphere (James Altucher and Penelope Trunk for example have the same advice). Thank god I came across your blog because my local community college advertises that database administration is a “hot career” where you only have to take their classes and you can be employed as a database administrator straight out of college.
Would you not agree, however, that accounting is one of the worthwhile exceptions to this advice? My present employer (a megacorp) won’t consider anyone for their accounting department without at least an associates in accounting. I’m actually a 44 year old who is investigating a career switch and accounting is on my list of possibilities. My feeling is that you would recommend that I start a business as a hedge or an alternative to any more college but I have simply no good business ideas let alone one that would be successful. To be honest if just feels “safer” to me to acquire a new skill than engage in business speculation.
Dennis – got some tough love here. If you’re 44, and you haven’t built up a network of friends who would love to work with you, and would hire you if you told them you were looking, then you’re not going to solve the problem with a degree.
Read this: https://www.brentozar.com/archive/2009/10/how-to-get-a-better-job/
I am doing desktop support job for last more than on year. I got Master Degree in computer science then completed my Oracle 8 DBA certification in 2002, but unluckily I couldn’t get any Oracle DBA job. I worked in Telecom field for more than 5 years in technical side. Now as I am back in IT field I want to get back dba side again. it’s Long time now I am untouch with oracle DBA course, but i cannot afford to do Oracle DBA training again. so I need your suggestions in this regard that shall I do SQL DBA, if so which version do you recommend and how should I prepare it, either my self or from some college. Thanks.
Hi, David. No, I’d recommend against spending money on more training. I’ve blogged here about why certifications and training alone don’t get you the job in today’s market. Instead, your best bet is to get a job in a company using Oracle and/or SQL Server, and start working with the company DBAs. Ask them for mentoring, volunteer to work late hours with them, and try to get on-the-job experience. No one will hire a DBA without experience, and you’ll need to get that experience rather than more degrees and certifications. I’d hate to see you shell out more money when it won’t help.
hello brent..
I just want to clear my doubts regarding switching jobs.
As of now i am currently working as a database Developer in MySQl (open-source) .. & its almost from last 14 months that means i have more than a year experience in MySQL Development which we do using SQL, stored routines etc …
.But before getting a job in MySQL i completed my Oracle 9i Certification an OCA.
Now i want to change my JOB …so is it possible to switch from MySQL development to Oracle Developer .. What type of questions can be asked … & what other points .i should know for switching my job from MySQL to Oracle development.
Hi, Aijaz. I work with SQL Server, not Oracle, so I don’t have good answers for you. You may want to check with Oracle DBAs and developers instead, like some of the bloggers and experts at http://www.ToadWorld.com. Hope that helps!
well .. its absolutely fine brent…
thanks for your time & reply ..
take care & cheers.
Hi, Brent.
Thanks for your blog.
I’ve enjoyed reading your articles. I don’t know where to post my technical question. So I am posting here.
My company, the State of Maryland is moving from DB2 V8 on z/OS to SQL Server 2008 on Windows. Yesterday I attended a meeting to discuss how to load data from DB2 tables to SQL Server. I’ve had experiences in unloading DB2 data through IBM’s Unload utility and tranfer it to and from mainframe through FTP.
The project I am in has SQL Server DBAs. But before hearing from them I want to hear any advice or suggestions you can give. Or, could you direct me to any website or articles I can read regarding this? Of course, I have made my own searches on the web.
Thank you,
James
Hi Brent, just drifting by checking out your web-blog-site and love it. Soooo do you miss SWS? Keep in touch, now let me continue to peruse your site.
Howdy, Chris! Yeah, I do miss SWS – there’s a bunch of really good people there. The Windows team was awesome, and I definitely miss working with Don. You guys carrying on okay without me? 😉
Brent,
I am Windows/VMWARE Administrator and later this year, I will be in a short project installing and administrating SQL 2008 server.
Do you know good books about learning to administer MS SQL Server 2008.
Thanks
Mike – sure, click on Becoming a DBA at the top of this page, and then click Recommended Books. I’ve got them organized there.
Brent,
Thanks for you quick response. I will take a look
Hi,
Does a MS SQL DBA need to know T-SQL (Regular, Inter, or Expert?
Thanks
Yes, it’s a pretty crucial part of getting your job done day to day. The good news, though, is that it’s one of the easiest languages to learn because it has elements of English, and it’s been out for decades so it’s easy to pick up educational material for it. For example, the book SQL for Dummies is a good resource – it teaches cross-platform ANSI SQL that will work on multiple database platforms.
I’ve been a database “power user” for 10 years. I’ve wanted to take the next step and become a true DBA. I’m good enough at what I do that I’ve worked as the DBA in a few small shops, but I’ve never considered myself a “true” DBA. When I found your online series, I cheered! Thanks, Brent for taking the time to help educate those of us who want to take that next step.
Regards,
Mike
Cool, glad I could help!
Brent, for a new candidate which MS SQL would you recommend to study SQL 2005 or SQL 2008?
Thanks
Hi, Ruddy. I’d study SQL 2008 because most of the knowledge will still pertain to SQL Server 2005.
i m working in a bank.sql server 2005 is the platform.i have started preparing for MCTS 70-431 but now sql server 2008 came.so i m confused should i complete my 2005 certification levels or jump to 2008.my thinking was as i m working on 2005 ,that will be the best option.
I would go for 2008 just because they’re so similar, and the 2008 certifications will last longer.
i mean i have almost finished the book MCTS selfpaced training kit for 70-431(sql 2005).so should i get a new book
and start allover.or should i contine with sql 2005 and give one exam to uprade to 2008.because there are no good books available till now .i have searched the websites and saw customer reviews also about these books.
Azad – if your only resource is books (not any servers), then yes, go ahead and finish with a 2005 exam.
hi after 3 month i m learn in oracle dba.hoe to get fresher job. i m completed bsc[cs]degree in vlbjcas.
tell the best institution & 100%placement
iam a non it experienced candidate of 3 yrs. i want to further start my career as a SQL DBA . I am BE civil.i hv started self study on SQL and need your advice to start and grow in this field.
Hi. I wish I could help everyone one-on-one with coaching, but since that’d turn into a full time job ;-), I instead wrote these blog posts with the help. If you’ve got specific questions, feel free to let me know. Thanks!
Brent, how are you doing, I always wonder how intelligent and smart you are and I always wanted to be a smart person like you whom every one admires of; i am great fan of your blog, postings and i even follow you on twitter even though i do not understand much sql server as i know a very little.
Coming to my question i am in IT from 3yrs, worked for a year and half as ETL QA/tester for organizations like Microsoft(1yr in Redmond, WA) and now working as a Software tester from a year; I wanted a career in sql server/database but do not know what is good like development or dba and do not know where to start; in all of your blogs and postings you mentioned about sys admins or networking or else but you never wrote something for a QA/tester who wanted to pursue database career like me who knows very little abot database, if you dont mind will you plz preach me your golden words of magic for my career, where and how should i start or advice something for qa person who wanted to pusue a career in database.
Chan – realistically, most of the QA skills don’t translate into a DBA career. You’ll be more likely to have success transitioning into a programmer role.
Hello..!!!
I am fresher candidate who is doing b-tech. I am in 3rd year doing computer engineering. I am very much interested in database. Regards to this, i hv completed OCP-DBA(4 modules). Gave all d tests of these modules and scored well. Dont hv interest in programming field. So would like to know how should i be successful getting hired in company with no work experience as i have come to know dt companies are always interested in candidates having work experience.
Thank you..!!
Yatin – sorry, but you won’t be successful with that approach. You can’t get hired as a DBA without work experience. If programming doesn’t interest you, you could also consider other career fields like business intelligence developer (writing reports and building cubes) or systems administrator, and those fields can eventually move into database administration after they’ve built up experience.
Thnku so much sir for guidance. Sir can u pls tel me certain fiels which can help me to enter into database field..?? For e.g. if we take systems administrator as a field, then what all courses should i do to get into it..??
Yatin – unfortunately, I wouldn’t be a good person to give you a list of courses for each profession. Instead, I’d recommend that you work with your college counselors to explore what courses interest you the most, and then talk to them about what jobs will use that course. I wouldn’t be able to give you the same focused counseling that a local counselor would be able to give. Good luck, and take care!
Hi Brent Ozar.
Wel I working at a bank mainframe ops for 5 years.
I want to change from this environment to SQL 2008 DBA.
Is this possible, to change to this job?
Please I need your advice?
Mathys – anything’s possible. Do you have any training in SQL Server, or if not, how do you plan to get it?
Hi Brent Ozar.
Yes, I am busy with swatting SQL 2008 DBA. I will attend a 30 days course at CTU training. It cost me allot but I like this tipe of work. I am currently chat with other SQL DBA and they are great in assist me with it.
You see I am a familie man and working long shifts. So I don’t see my kids and wife that match. So I have to change work before I lost my familie.
Please help.?
Mathys – what specifically do you want me to help you with? What’s your question for me?
Hi Brent Ozar
Is it possible to go from a IBM mainframe IT ops to a SQL DBA.? After I complited my SQL DBA 2008 course.?
What complications are there.?
What can I still do to be able to even get a junior DBA job.?
Iam currently walking in the dark.
Thank you for you time.
Mathys – like I said, anything is possible. I’ve written extensively here about how to get a junior DBA job. Read the articles here on my site, and when you have specific questions, let me know.
I gotta be honest, though – it feels like you’re not really doing your homework. If you’re asking this comment on a blog post that TELLS you how to get a junior DBA job, you’re not giving me warm and fuzzy feelings about your abilities to get the job. 😉
Hey Brent,
I have been writing loads of SQL in my last 2 years with experience in Cognos BI. I have a Masters degree in Computer Science. I have been mostly working with Oracle and how do you think a transition from Oracle and MS-SQL will be. I have a feeling that it is just the syntax that changes for the most part between Oracle and MS-SQL but not pretty sure. Do you think complete understanding of SQL and T-SQL (PL/SQL) suffice to start of with a steps to a junior DBA?
Taylor – interesting question. Why would you want to switch from Oracle to MSSQL? Why not move into an Oracle DBA position? Leverage your peer network, especially since you’ve been working with Oracle and BI folks.
hi brent,its almost been 1.5 yrs working as a DBA.what additional skills should i have which will help me develop in this field.
right now i have a fair knowledge of reporting and integration services.
Hi, Azad. It depends on what you’d like to do – the job title “DBA” has a ton of different jobs underneath it. Your best bet is to work with other DBAs in your area, find a local mentor, and talk to them about the kind of work they do. You can attend your local PASS chapter to get a head start on that:
http://sqlpass.org
Hope that helps!
Hi Brent!
I’ve just recently come across your blog and love it! I was wondering if I can get your advice. I recently completed my BS in Computer Information and am going for my Masters in Information Systems… Now I know I need DBA experience so how do you get in with a consulting company in order to get that Junior DBA job? I have tons of experience with writing SQL and using SQL Server 2005 & 2008. As far as the administrative tasks I have only performed simple backups, created a few simple procedures, etc. I want to get those skills but am having trouble finding the position that will allow me to do that.
The life of an aspiring DBA!
Oh… and I love the podcasts as well 🙂
Esli – the answer to that one is pretty simple; call them. Just pick up the phone and call your local consulting companies to find out if they’ve got openings for junior DBAs. There’s no secret magic to that one. Most of the time, however, they’re not going to be hiring outright when you don’t have experience. That’s why I recommend in this blog post series that you get a job as something else (like developer or sysadmin) and work your way into a DBA role. Hope that helps!
Hi Brent!
Thank you for your advices.I have 2 years software development experience.then, I left my job I move to new city two years ago. I start to learn Oracle a years ago. I want to be a Oracel DBA. I have prepared a lot,I attended the training course, got the certificate, But I don’t have any really work experience, How can start my first DBA job? where I can find the mentoring, volunteer choice?
Lily – this entire article series is devoted to just that topic. Please read the entire article by clicking through each post and it has the answers you need.
hi brent
good news.i got a job in software company as a associate SQL DBA.finally all that hard work paid off.your post helped me a lot.i did all those things that u told me.wish me luck for my new job.
thanks a ton
Great, glad I could help! Good luck in the new job.
Hello
I have done my ocp certification and i am Pursuing mca and i am fresher also and I am searching job before 3 year but I could not find any kind of job please tell me what should I do for getting jo b
Hi,
I graduated in 2008 with a BS in CS and I am currently working on a MS in information systems. My title is basically sr. developer/programmer but I’ve managed to earn the trust of my manager and systems admin to take over sql server 2000 and 2008, as the dba (took me 2 years). I’ve setup sql server 2008, reporting server and integration server. I have made maint. plans, manage security, setup emails and such and I am currently working on a migration plan. We are a small shop and we have about 40-50 databases. I am not sure if this is good enough experience to try to move up. I am still called a programmer (get paid like one too). So basically I want my title, job description, and check to be changed and that might not be easy. I expect a lot of resistance from my peers and upper management. So perhaps is best to just find a jr. dba job elsewhere. Anyways my questions are: Will it be difficult to make a transition to another company if not almost impossible? Should I try for senior? I guess I am just concern because we are not a big shop and I was given that responsability recently. Any advice?
Thank you for the great article!
hi brent
iam a bsc electronics holder. I have done oracle dba too. but now iam not getting any job as a dba. plz help me
Ismail – sorry, but what specifically do you want me to do?
Hi Brent,
Im going through your blog for the first time and you have been answering and advising all audience,
Well im a SQL SERVER BI developer worked in FL on SSIS/SSRS/TSQL for nearly an year(Contract ended).
I really want go up the ladder and become a DBA, i have checked some training videos but nothing impressed me. I would like to take up my next assignment as a Jr DBA , can you give me some advise/directions
thanks
JS
Hi! If you click Becoming a DBA at the top of this page, I’ve got tons of articles about it. Read through those and then feel free to ask more specific questions.
I am working as sofware professional in an MNC.
Now i am looking forward to develope my career in ORCALE , currently i dosent had any work experiance in oracle .So i am planning to take OCP in DBA .But when i consult with some of friends i came to know that oracle application developement will more advantage for you to get a openning (Because i dosent had a experiance in oracle).
I already joined a class for DBA , so for getting an openning for me do i need to take both certification on oracle application developer and on oracle dba ?
Will it help me to built career? Please give me some reply if possible.
Renjith – if you search for Certifications on my site, I’ve written an article called Certifications are Icing, Not Cake that will help you decide.
Hi, Brent I have read your blog and it is really help full.I am a student right now going for Database Specialist Certification want to become a SQL Developer but have no job experience so you said in your blog that get a job as junior SQL developer. In order to get a job as junior Developer can you tell me what certification or what class should I take.
Thank YOU.
Generally speaking, junior developers don’t need certifications – they just need to network to get to know prospective employees. Most certs are easy to get in the US, so they don’t carry much weight.
Thanks for repling so quick.To become a SQL developer what degree do I need. does it have to be 2years,bacholer,masters or just work experinces.
ThanK YOU.
Roshan – it’s a combination of work experience, a CS degree, and network connections.
Hi Brent,
I have 7 month work experience as a SQL DBA(Under the Senior DBA, who is working remotely). I am Little bit confident about SQL Administration Work but now days every requirement wants SSIS, SSAS, SSRS and i don’t have any experience on this field.
Now i want work in professional environment and i upload my resume on some website but i didn’t get any single client call.
Can you please guide me what should i have to do?
Jinesh – read my articles like the ones above, and I’ve written extensively about this.
I’m screwed i’ll get a junior developer then i’ll come back for read the part 2, i promise.
hi Brent i came to your blog from googling stuff about DBA work and i have to thank you because your articles have answered lots of questions i had on my mind about this career path, i am 36 years old and come from a web designer animator past, as you say in your article its hard for a first timer of getting their first DBA job which is understandable, but you say newly graduates have a better chance of getting hires, my plan is getting my AA in ‘business application & data administration’which has some good classes to train me to get my hands dirty with database work, than focus myself on ms-sql and becoming ms-sql certified. That would make my chances better in landing that first DBA job right? also with most of the develoment IT job being outsourced overseas do you think that the DBA jobs (specifically ms-sql ones) are in danger to be outsourced?
Devon – glad I could help! Unfortunately, no, I don’t think an Associate’s degree is going to help you land a DBA job without hands-on experience. Training courses and college are not experience. The best route into database administration as a career is to get database experience at work while you’ve got another job (programming or systems administration) and then transition in from there.
About the outsourcing – I don’t agree that most development IT jobs are being outsourced overseas, but even if they were, the “most” thing is really misleading. Do you want to do what you love? Are you really good at doing it? If so, there’s always going to be jobs for the people at the top. However, if you’re just looking for a check, and you don’t have a burning passion to do the job, you’re going to find someone else taking your job because they’re passionate about it and they won’t stop working/training/learning on it. That’s the same for any line of work.
If you want to do database work, use your contacts from your web design past to intern with coders who use databases. It’ll cost you less than getting the AA degree, and it’ll continue to build your network – and that’s where the jobs are. If you’re not willing to work for next-to-nothing on this, then don’t get into it – it’s not your real calling.
Hope that helps!
Hi Brent,
About 2 yrs ago i was new in the DATABASE field.In these 2 yrs i have worked like hell and coz of that i got selected in Microsoft GTSC bangalore. During this period your advise has help me a lot.
I would like to thank you for that.You are my inspiration.
Thanks & Regards,
Azad R Sale
Azad – congratulations! Glad I could help, and good luck with the new job!
Do the best, mess the rest.
Keep peace in mind and calm like the wind.
Hot like a fire, power like an ocean.
A thousand miles road will begin with a single step.
Thanks for such precious advices. I feel a passion of doing it.
P.S. Do you know after retired then what a DBAn doing?)
Allen – after retirement, I plan to do a lot of nothing. 😀
hey i am jst out of colg,nd did attend an interview in a MNC for pl/sql programming job role,so im bit in confusion if i shud tak the job or not,since i wanna be a DBA in the future,dats the reason i completed the OCA exam too..pls do guide me.
Ash – if you’ve got an offer for a job, and you don’t currently have a job, you should probably take the job. This is a rough time to come out of college as a computer science person.
but vud nt it be a prob later ven i wanna apply for dba job?? since i wont be havin any experience in dat field??
Ash – do you have any DBA experience today? If you don’t, then you’re not going to be any worse off later than you are now, right?
Also, just a side note – your bigger problem is spelling and grammar. 😉 Keep in mind that people will Google for your name and email address, and if they run across comments like this, some managers will have a hard time taking your work seriously. They’re going to think your T-SQL is as bad as your spelling and capitalization. I know, it sucks, but that’s the reality of looking for jobs.
Sorry Sir, will keep that in mind. Thank-you.
hey i am jst out of colg,nd did attend an interview in a MNC for pl/sql programming job role,so im bit in confusion if i shud tak the job or not,since i wanna be a DBA in the future,dats the reason i completed the OCA exam too..pls do guide me regarding dis.
Programmers work with data and DBAs. Some DBAs I worked with came from programming background. In this economy it seems wise to get a programmer position and learn from it.
okay,but will I be able to move to the DBA field later ??
Ash – you can move to any field you want, but you have to make a plan. Build a plan to get from point A to point B, and then work the plan. You can definitely move from programming to DBA positions. I’ve been there myself.
It depends on the job openings in the company you are going to work or other companies and how much you learn . Not long ago I asked my manager (DBA team of 6) who she was going to hire to replace a DBA who is going to retire. She told me she prefers to hire a programmer in our organization.
Programmers closely work with DBAs and some of their skill sets are same as DBA’s such as languages but not all.
I am not an Oracle DBA. But Oracle DBAs use PL/SQL and so do the developers.
Hi
i am looking for a job as a junior Oracle DBA can any one please advice me on how to get an Oracle DBA job. i have beeen looking for where to startup my career but everywhere i go to they are asking for 3 or more years real-time experience how can i get a experience without a job. i have a 2.6 experience BPO. its been preety tough but i wont give up. any advice will be appreciated
Jana – that’s what this post is about. Please read the series and then ask questions. Thanks.
Hi,
I got 2+ years experience in .Net Programming. I am intersted in SQL. Now i am thinking to switch over my career to SQL Developer. But I don’t know whether this is a good move or not. Pleae advice.
Bala – well, it depends. What specifically interests you about being a SQL developer more than a .NET programmer?
SQL Server database administration really attracted me because i am person who loves to take responsibilities and challenges, Also i am very organized in my work.
you know it isn’t easy to get a job straight as a Jr.DBA. So i found that the transition from SQL developer to DBA is quiet easy when comparing from .Net developer. Also i am quite confident in my T-SQL programming and performance tuning.
OK, sounds like you want to make the move, and it sounds like a good fit. Good luck!
Hi, Brent.
I just wanted to thank you for such an awesome article. I’m sure it’ll help a lot of people who want to become a DBA someday.
I’m a software dev and I really think there are not much places to go when one needs references and some guidance towards the starting point. This articles helps us to achieve that.
Someday when I get there where I want to be, I’ll look back and thank people like you, Grant Fritchey, Steve Jones, Jeff Moden and many others who spare no effort to help everyone from the novice to the professional.
I appreciate it. 🙂
Best regards,
Andre Guerreiro Neto (codebyo)
http://twitter.com/#!/andre_byo
gud aftn sir, i’m final year IT student. I finished oracle 10G in NIIT. i like to become a DBA. wt i have 2 do. how can i apply for job. pls give me an idea about this field. wt other exam i have 2 write for this and wt other course i have 2 go.
RamKarthik – the first thing you have to do is start reading posts before you comment on them. The answer is above.
Hi,
I am changing my career, I studied Oracle 8i and upgraded to 11gr2 and now I finished my OCA and heading looking for a job. I wanted to get a entry level DBA jobs or similar to that. How can I do that. Please and thankyou!
Chandra
Chandry – the information you’re looking for is in the article above.
Sounds like Brent has studied my Biography, I could not agree more with this post
Hi, once again great article you’ve got, I’ll be getting BSc Degree in Computer Science next year and since I have no working experience even though I wanted to be a DBA, does having Web development experience later on in life can help me to transit back to a DBA in future? Or in your or anyone’s experience have you seen or heard someone from web development experience moved to DBA career…
Edwin – yep, that’s exactly what I did.
That’s Awesome, Thanks Brent…
It is nice one, thank you for sharing
Tanks sir.my issue is im very confident of myself.so pls i need a junior dba job thou im stil hopin to write d certificatn.im a nigerian.
Im realy very grateful 4 ur write up.put i have tried to find a junoir dba job wit no sucess.im very confident of my ability as a dba, i just need an opprtunity.im a nigerian.
Thank you for sharing Sir..I’m now working as junior developer and have OCA..I’m very passion to get a position as DBA..this article very helpful and guide me to the what I want. I hope I can achieved it someday. Thanks again.
Hi sir
i’ve just completed I.T course lst yr in college. I hv 6 months experiance as an Admin assistant in Dept of Edu…i hv done Databases as 1 of my modules(Intro). I wnt 2 bcm a DBA. Do i hv 2 study more abt Databases or wat?
Kenneth – that’s a great question to ask. Have you contacted people who are hiring DBAs in your area to see what kind of experience they’re looking for?
Thanks for your response Prof. I haven’t contacted them as yet But i’m willing 2 learn more about Databases (sql). I’m only having the basic part of it which is Intro(intro to MySQL db,data modeling,nomalization,dbms, and etc….)
Hello,
I am about to start a 3 year Informatics degree that will cover programming and databases amongst other modules. My 5 year plan is to become a DBA. I have ZERO IT experience. What can I do (courses, online or otherwise) in order to spead up the process, i.e. not wait till I finish my 3 year Bsc??
Any advise would be helpful.
Thanks
Charles – read the above post carefully. I explain how to get the experience.
I really appreciate this post. I am a senior DBA person (Data Architect) and my 18 yr old daughter is considering being a DBA. As far as fresh out of college, I think I can help her land being a DBA right out of school. The reason? I have contacts and I will mentor her. I will introduce people to her and she will say she is taught by me. I would suggest others to network with a DBA in their organization and learn from them. They will have a lot of say if someone can be brought in. At my previous company we hired someone who was a programmer with a lot of good SQL skills and taught him. DONT give up hope, Network!
Michael F. Berry
MCDBA,MCP,MCTS,MCITP(2005/2008 DBA), MCT
Contributor to SQL Server Magazine
Brent,
Thank you for this article I wish I had found it when I graduated college in 2005 as I was looking to get into being a Jr DBA but as you know that isn’t really possible for most people.
Instead I got a job working as a SQL Developer for a Website company for 2 years building databases and DTS packages to import data. The last 4+ years I have been working as now a DB Support/software support for a company doing data cleanup, database restoring, writing SProcs to pull data from varies other applications DBs and flat file systems, creating maintenance plans, backing up, restoring DBAs, saving corrupted DBs ect. I have experience with SQL Server 2000/2005/2008/2012.
I am ready to move on from the company I am currently at and they don’t have a DBA to learn from and I have really gleaned most of the knowledge from my older DB co-workers.
I am hoping with 6 yrs experience I have enough beginning knowledge to move into a Jr DBA position where I can learn from DBAs. I have been going through a SQL 2012 DB Administration to try to get an idea of what’s new and hopefully get a jump. Is this a good idea or should I focus on 2008 R2 still? Working with a large customer base they are spread out between versions of SQL most are still on 2005 though, is the slow upgrade path of SQL typical for smaller companies? Also I know you mentioned certifications if I am looking into that is it better to go for SQL 2008 or study and go for 2012?
I do have friends at Expedia, MS and RIM hopefully those contacts can help as well.
I appreciate you taking the time and effort to write this and respond to comments. Sorry for the long post and probably to much info!
Thanks for the time that anyone might have taken to read this.
Jeremy – wow, you’ve got a ton of questions in here.
First, what version should you focus on, SQL 2008 or SQL 2012? Actually, I would recommend devoting more time to networking. Talk to your friends at other businesses who are doing SQL Server work and ask what they need help with. The specific version doesn’t matter as much as your ability to solve business problems.
Is a slow upgrade path typical? Yes, once a database solution is in place, companies aren’t usually quick to jump to the next version. You don’t wanna fix what’s not broken – if it works, leave it be.
Should you get certified on 2008 or 2012? I don’t think the version matters all that much right now to most companies. I’ve written about why certifications are the icing on the cake. Do a minimum of studying, and instead just jump in. Schedule the exam and go for it – otherwise you’ll delay forever thinking you’re not ready. Trying the exam will give you a feel for the question depth and coverage areas.
Hope that helps!
Hello Prof. Thanks for the great post. Currently im working as a search engine optimizer(SEO). I got 5 yrs of exp in seo field. I want to shift to Database field. Kindly advise
Robert – Sure, read the post above. It explains this in detail. Have you got a more specific question?
i heard that for fresher dba is not well job, and salry for the dba is also not as much as devloper
Rohit – it depends on the market. As I wrote above, I’d actually recommend that you start as a developer instead of a DBA, and then grow your skills from there if you’d like to become a better DBA.
from what I know… DBAs make more money than programmers typically. and its a better job in my opinion. again you can work your way up and also start as a report developer (how I did) which is more focused on SQL anyway:)
Hi, I started my career in mainframe production support. And I have one year of experience in it.
What should I do now to become a DBA? Will my previous experience count?
Rajeev – the answers you seek are in the post above. 😀
Hi,i have completed my oracle 10g training and looking for a core dba job…i am btec 2012 batch pass out and after completing my college i did this training.kindly guide me what should i learn step by step.I have made search and found that in India ,there is mostly requirement for DBA who knows about RAC,DATAGUARD,MIGRATION.and i dont have any experience in handling production database.tell me something where to start.I have got offers for sql, but i refused to take it.because i want to do something valuable as dba.
Rohan – sure, read the post above. We literally talk about what you’re looking for.
Dear Brent
Currently I work as application support administrator . And I always wanted to become DBA . but unfortunately its really hard to find DBA job without any experience. I have read your blog and I have got some ideas. and also I’m trying get SQL server certification done. but my question is whats sort of job i should start with? as in like SQL developer or sys admin assistant . Also what sort of programming languages will be an advantage or should learn towards this career path. I would really appreciate if you share your experience as how did you get into SQL DBA (which is in your blog ) or how did you motivate yourself or how did you study.
Thank you so much for the postings and for your blog.this helps us alot
Best regards,
Milinda
Millinda – please check out the blog post above where I answer these types of questions, and make sure to click on the Part 2 link to keep reading.
Thoroughly interesting read.
Thanks for posting this mini-series (even if it was 4 years ago!), It has definitely influenced my thinking.
Regards
James
Dear Brent
I want to switch my job now I am IT technical support Person
which field i choose means DBA /Developer or system administrator ?
Hi, Jameel. I’m not sure I understand the question. Can you rephrase it? Thanks!
I have done B.tech(CSE) then M.Tech(CSE) .After clearing OCJP (Oracle certified java professional Exam) Is there is guarantee that i would get job.
No.
You would actually need some real world experience either as a SQL coder of some type (reporting, applications, database dev) and not just java?
Michael – correct.
sir i have completed b.tech (IT) in 2012. at present i am working as a back office executive. but i don’t think that this job can help me to shape up my career. i am getting frustrated day by day. i have nothing to learn here.
Also now days no any one is in a mood to recruit freshers in any profile except bpo (voice/ non voice process).Opportunities are very limited and competition is extremely tough.
I enjoy writing sql queries and to be very honest i would like to confess that i am not so good in programming. i am also pursuing m.tech (cse) side by side..sir kindly suggest me, what should i do to boost up my career ???
Amit – correct, freshers don’t get DBA jobs. I explain why in the post above. Start by reading the post, and you’ll find a ton of relevant stuff. Thanks!
Basically I’m screwed.. Lovely. So in actuality doing a degree makes no sense considering it really doesn’t matter without experience.. I totally feel like I’m wasting my time in college now and it’s only my first year..
Well, not exactly – just focus on getting a job that will lead toward the one you really want. If you’re determined to become a DBA, start with a CS degree, for example. And along the way, don’t focus on just getting the degree – make a network of people who are also going into computers. Those people networks are how you get the real jobs – and hey, lots of folks just start awesome sites right now while they’re in college. Go for it!
I’m doing Information Technology, which I guess isn’t much of a difference. I can tell you though, this is a bit discouraging knowing now I won’t be able to land an entry level DBA job straight out of college. I mean what’s even the point of the degree if it doesn’t teach you what’s really needed to be known to work in the actual workplace? Recruiters at the same time not making things easier by throwing up advertisements for entry level jobs requiring one to two years experience. Exactly, what makes it an entry level job then?! You need experience to get a job, yet you need a job to get experience? Job market you’re killing me here.
Xavier,
There are not enough DBA jobs for colleges to justify a program to crank them out. This makes it hard to become one, yes, but also makes it not be a dime a dozen job like programmer or web designer which keeps it hard to fill for recruiters and good paying! it makes it a desired job to have and worth the extra effort and time to work your way up!
and you will not be wasting your time in college. a degree will be almost needed for a DBA job. shows you are hard working. Best job in my opinion to start out in is as a report writer. that gets you a great knowledge into SQL coding and knowledge of the data which is the most valuable asset in a company. Just my 2 cents. I am a certified DBA and have been a Microsoft certified trainer and published in SQL server magazine too:) its worth the ride. a good DBA will make in excess of 100K US and consultants can make more money than that.
Just be patient and keep your goals in mind and connect with other DBAs!
Hi Brent. I have recently completed my degree in Information technology with specialisation in oracle database . i havent started applying for the jobs yet because i am doing application server certification. However i am a bit hardhearted by reading the post because i was exactly looking for a junior dba postions and you are right employer do ask for 2* years of experience.
My question is i only have interest in databases what you you suggest me if i have tough time in finidng a database job where can i start my career as to which field in IT.
Hi Saad. Read that article carefully, and I suggest that you can start with either a developer position or a systems administration position. Thanks, and enjoy!
Hi Brent,
When you say “developer” what do you mean exactly? Do you mean a SQL developer or what?
C#, Visual Basic, Java, etc.
Thank you for the clarification.
Hi Brent,
I am a B.E graduate with no experience, I am planing on getting a DBA certification. But according to the second part of this article, you said its of no use.
So what do i do ?
hi,
I am currently working as a Implementation consultant on sql server 2008. My job is doung upgradation of NEXTGEN KBM. I m on contract of 9 mnths. I just want to ask whether this will help me to become DBA in future. I m BE (IT) graduate.
Christopher – any job can help you become a DBA as long as you’re building your knowledge of SQL Server and building your network. Good luck on the journey!
Hi Brent,
First off thank you for being so brutally honest about your career advice. I feel like most people/ organizations just want to tell you what you want to hear.
I desire to be a DBA…. one day, however my background is Program Management and HR. I was thinking of starting in a HRIS Analyst role because of my HR experience and using that as a catalyst into the DBA world. Is this a good idea?? I’m also in school for a grad certification in MIS and plan to build a home lab and teach myself SQL as well as using various other training methods.
Thank you!
Kara – that’s what this blog post is all about, talking you through getting another job first rather than trying to get a DBA job directly. Pick a job you really want and enjoy – if that’s HRIS Analyst, go for it – and then follow your dreams. Just make sure each step along the way is a good one – don’t spend a decade in miserable jobs hoping to get a fun one later.
hi brent
I’am a 2011 graduate IT engineer(4 – year course) from india. I have no experince. I have applied for two posts in uk one for entry level dba and other for it administrator. They have told experience is not necessary. What are the chances of getting selected. Would they hire from india.
Rajiv – the answers you seek are in the post above. 😀 Thanks!
I have done B-Tech in IT(2013). N i have done IBM-Db2 and Ibm RAD certifications. I have also done a course on Java Technology as well. Still i am unable to get a job. Could u please suggest me which field would be more beneficial for me right now. As i can see there is point in going for a DBA right now as it requires experience.
Hi Prateek. The post above talks about our experience with the DBA field, and what other job fields to consider pursuing instead. Good luck!
I did master in CS in 2002 since then i am doing business and now i want to start my carrier in IT cuz business is not doing good what u suggest me which field i should go ? my favorite subject was database in study days . i am in USA
Akhtar – check out the post above and it explains. Thanks!
Hi Ozar , I am application support engineer and I have done OCA and have good knowledge on Oracle Database Architecture and backup , restore and recovery of RMAN .
How do I change my profile from application support engineer to Oracle DBA and what other requirements are which I’ll have to fullfill ………..
Thanks for your great advice !!!!
Sachin – unfortunately, I’m not a good person to ask about Oracle since I do SQL Server work. Just generally speaking, when it comes to becoming a DBA, I’ve got a lot of great advice up in that post above though. Good luck on your journey!
Brent – I am currently a Systems Analyst and have been working on a project the past 6 months doing database conversion on a mass scale from Sybase 9 to MS SQL Server 2012. I have become very interested in pursuing becoming a DBA, it seems to be my niche. I have even spent some time with the current DBA as well as outside developers on this project and have learned a ton regarding administration of MS SQL Server. I do not possess a Bachelors degree, but have some certifications in the tech field as well as 3 years works experience. My question is other than learning as much as possible, what do you recommend for my next course of action as far as pursuing a DBA or Junior DBA position either internally with my current company or outside of my current company? I am considering going the MCSA route and taking the 461,462,and 463 Microsoft exams, than eventually maybe the MCSE. Do you feel this is worth it?
Ryan – I actually talk about that in the article above. It’s not easy, but the contents above talk about how to pull it off. Certifications aren’t going to cut it.
Hi Brent, very interesting responds there, you like a barn of answers to a wide stream of questions and I’m really learning a lot over here.thx 4 that. quick one pls. i hold a degree in computer science and about 2 yrs of working experience, not seriously in the IT field,its basically data entry and archiving and small based IT support. beginning last year i took a break from active work and attended training in CCNA i took the exam latter part of last year and I’m fully certified now, i still cant seem to get a Networking related job with that, most ads demand Database and or programming in addition and the sole networking jobs are demanding tons of years of experience. i have decided to get into database now not only for the money and a job but i like organized data, troubleshooting and ensuring data security and integrity as well. what wud appreciate your advice, leap or not to leap and why, any other advice pertaining to my situation is very much welcomed.
humbly grateful……..Raymond
Hi Raymond. The answers you seek are in the post above, actually. Gotta read through that and do the homework. Thanks!
I am working as a windows administrator in an MNC company and i have 2 years of experiance, I am very much interested to become a DBA .
if i get OCA/OCP certificate then can i get the Junior DBA job ?
And which degree is need to become a DBA, Actually i did BSc(10+2+3) is this enough or should i do MSc or MCA…
Thank you in advance.
Hari – certifications aren’t really the answer to getting your first DBA job: https://www.brentozar.com/archive/2009/04/certifications-are-the-icing-on-the-cake/
Hey Brent,Thanks for the great article.Just last week I send my lecturer an email asking him if he knows of any internships relating to database administration because in my long time as a job seeker I have never come across even one,if anything it is a junior position that requires experience.Now I just want to understand your advise…you say first I must get a job as a Windows administrator or developer but how does this help because as I understand this would mean I have experience as an administrator or a developer,I am aware that IT disciplines are interrelated but still I want to know how can one get into this industry without volunteering to spend time with the DBAs bringing coffee, donuts and bacon, and be the most pleasant (but not over-the-top) person in the room.
Mpho – right, as I explain in the post, you have to start at the bottom, not at the top.
Bro, thank you for your insight and knowledge. I was not sure what path to take when i get out in the field. Last night considered database admin, but for a student getting associates and very minimal experience. I have realized from here, start somewhere else and learn SQL hands on. I do work for the school as work study. I am going to ask questions as much as i can, try to learn as much I can to get hands on experience in multiple areas. I see these other jobs out here like “__” Admin or Analyst require knowledge in other areas as well. Thank you for your post. I am going to do more research for what type of entry level job i can get into while gaining experience at my IT workstudy. I suppose I have a question for advice. I am new to this site today and not sure if this blog is database only, but if i am familiar and haveknowledge with MS sharepoint, excel and slight scripting with 3 years of product advisor. Do you know what i should consider looking into when i get out in the real world?
Hello sir
My self vaibhav .. from India…im pursuing my bachelor degree BCA… n I want to be a DBA please guide me….. I need a guidence from qualified persons …. help me please….
Here my mail id….
(redacted)
im Waiting please do contact…….
Vaibhav – unfortunately we can’t do personal career mentoring.
Sir is it gud job for girls?
Sir is it gud job for girls?
Is there any type of stress??
Jani – I think it’s a great job for all kinds of people. (There’s two women here at Brent Ozar Unlimited, for example.) Yes, there’s all kinds of stress.
Sir,now am studying oracle DBA… Still i have one month classes and then how to get a job in dba. And then am a fresher for IT sector.. Basically ….. i’m a electrical and electronic engineering student so how to get a job in dba. Please give me a good idea.
Gowtham – you can start by reading the articles that you comment on.
Good evening Brent,
I have completed 10th and Diploma in electronics. Having 10 years experience in non IT field. I have taken training sql dba. I am eager to go change my profession as DBA. is this education and experience helpful to change to DBA?
Kamesh – well, let’s see, let me answer that with a question. How much of your electronics diploma and non-IT field experience involved database work?
thks for your quick response. The 10 years experience is not related to any databases work. complete back end non voice process.
Kamesh – then no, that won’t help you get a DBA job.
Good morning Brent,
because of qualification or not related of database experience.
Kamesh – you asked if your experience would help you get the job. The answer is no, unrelated experience will not help you get a different job.
If I’m really good at ironing clothes, and I decide that I want to make waffles, the clothes iron experience does not help me with the waffle iron.
I’ve got an alternate question here. I’ve been tasked with writing a job description/position advertisement for a Junior DBA. Somebody to work alongside of me and for me to mentor.
Having skipped past the Jr. DBA type of position and going straight from Windows Admin to SQL DBA due to corporate necessity close to 20 years ago, I’m at a loss as to what a good requirement for a Jr. DBA would look like. When I google for them, I run into the same Jr. DBA jobs you describe above (2+ years as a DBA for a client facing database).
what I’m looking for is what I should expect when looking for a Jr. DBA, I’d love for them to have some skill, or have at least taken a class or two in SQL and/or Database Theory, but trying to put that to words gets hard.
In truth, what we’re looking for is a person who can think on his or her feet, and is willing to become a SQL Jack of all trades. My title is DBA, in a given day I serve as a SQL Developer, Data Architect, BI Developer, SSIS Developer and/or an actual DBA. I want to find somebody else who’s capable of becoming that too.
In most cases, junior DBAs haven’t already taken a class.
Some tough love here: there’s more money in being a specialist than a jack of all trades. What you’re essentially looking for is someone who doesn’t want to specialize or become a senior in something. That’s a rather tricky request.
Yet when I see positions out there advertising for Sr DBAs, they typically want you to have SSIS, SSRS, SSAS, the ability to tune indexes, queries, design databases, diagnose replication issues, setup log shipping, setup automated maintenance, etc.
I can do any and all of that… it’s taken me 20 years to get there, but if you want a data warehouse I can do it, you want me to figure out what’s wrong with a SQL query, I can do that too. Write a report, develop ETL, etc. All of that I do too. And generally I make what I consider a pretty fine salary to do it too.
I want to find another smart person that’s willing to learn it all.. if he or she later decides to specialize in something, it puts me in the spot of either no longer having to worry about that facet of what I do today, or lets them move on to the next level of their own career.
Mark – the trick is understanding that the positions are being advertised for a reason. The company’s existing staff can’t find anybody in their personal networks to fill that job.
Think about that for a second.
In related news, most advertised “senior DBA” positions are in the $60k-$70k range. The company can’t find anyone to take that job, so they have to advertise.
Think about that for a second too.
I’m fully aware of that… my Senior DBA position makes a lot more than that.
That said, in order to create a position, I have to write up a job description, which around here is the equivalent of an advertisement for a position. Trying to look at what’s out there is turning into looking at crap. Because of what you say above.
So… what would a job req and/or advertisement look like if you wrote it looking for a Jr DBA?
I don’t want to write a req that’s obviously as silly as the ones I read, but I having read some of the Jr. DBA position advertisements that I’m convinced nobody qualifies for, I was looking for advice as to what I should be looking for, and what I should expect to find.
I am interested in becoming a Jr DBA Mark. I start an internship in a week solely to learn behind a DBA. Please let me know if you have anything available.
Jacob – this isn’t really a job board, so I’ve removed your email address. Thanks.
What is that companies actually look into when they hire a DBA as a part of interview.
Harsha – if you search for Interview on our site, we’ve got lots of answers about that.
I seem to be interested in this training. how can I participate into this training?
Ruvable – which training? (There’s been a lot of discussion about training in the comments here.)
Hi Brent,
I currently work for in App. Support position. The job utilizes tools such as Toad, SQL Plus, etc. Although I am not writing any queries, part of the job is frequently accessing the database and loading/pulling information. There is definitely exposure and experienced gained with Oracle, SQL, and UNIX.
I am now self-studying Oracle Database Foundations and eventually try to finish all the exams to be a Oracle DBA.
Do you think I may be able to find a junior DBA job with this background and taking this type of path?
LJ – go ahead and read the post carefully. The answers you’re looking for are in there.
Hi sir ,
I have done my Btech from computer and ,and certification course of oracle DBA for 3 months . as u described in above article fresher don’t get job as an DBA easily , I am fresher so what should I do about job …? At what position I have to start ?
P.s. – Ur above article is awesome it helped me a lot , thanx for sharing Ur opinion with us .
Swati – read the post.
Hi Brent,
I’m an MS Dynamics GP consultant. In case you’re not familiar, Dynamics GP is Microsoft’s ERP offering that runs on a SQL Server database, so I spend a fair amount of time in SQL Server, I have SQL Server on my workstation with ~12 databases and automatic backup maintenance plans, I work with some (often outsourced) IT people, usually sysadmins, and tell them what to fix, etc. How does that (if at all) relate to experience and assist with becoming a SQL Server DBA?
Thanks in advance,
Jake
Jake – the best people to ask are the people you work with. Shops large enough to have Dynamics GP often have several SQL Servers. Check in with them to see if they’ve thought about hiring a DBA, and if so, what kinds of qualities they’re looking for. That’s how you get your next job:
https://www.brentozar.com/archive/2009/10/how-to-get-a-better-job/
Hope that helps!
Hi Brent… I love your avatar by the way. My name is Ola. Just wondering you can direct me to right part if possible. I have a diploma in Web Development because i couldn’t afford the degree tuition.
Have self taught PHP and MYSQL, which include writing DDL to create a website and application. I currently work in health care as don’t have enough knowledge required by IT company for website developer.
Am now 33 and i want to get back into IT and actually for a company. Have started learning MTA DB Fundamental course even tho i know query from web developement… but have being told to get in to MS DBAs i need MTA certified first.
Now have being looking for possible junior DBA job to see what is out there for me when am certified. But having read your post… am unsure what job i should be looking for.
Jr DB Dev?
Jr DBA?
Jr SysDev? or ??????… please you advised would be valuable to me.
Best Regards
Hi! Sorry, I really can’t do personal career advice in blog comments. Your best bet there will be to work with your local peers.
I’m a college student pursuing BCA from India. I have an interest in databases, tell me how to put it on more???
I also want to work on Databases but the main problem is I’m not getting any help regarding it. Please help me.
Ujjwal – read the post. Thanks.
as I website possessor I conceive the content here is really excellent, appreciate it for your efforts.