SQL DBA Career

Hi All of you,

Currently i am working as senior Software Engineer and also do some parts of dba task like backup,job scheduling,ETL(ssis).and i want to move my full career in DBA. Please suggest me and guide me how can i prepare for the DBA job interviews and also interesting to take certification for DBA.

Please do needful. I am full of confusion from where i can start to grow career in DBA.


more ▼

asked Apr 06, 2015 at 07:12 PM in Default

avatar image

61 1 6

http://t.co/a7z3sUYgAp <- 6 hours of material on how to administer SQL 2012 server. Microsoft Virtual Academy is a great place to get to know what you actually need to prepare for..

Apr 07, 2015 at 10:06 AM raadee

ASK SQL Server Central runs by you voting. For all helpful answers below, please indicate this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next that answer.

Apr 10, 2015 at 10:18 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

Read Craig Mullins book, Database Administration. Read Tom Larocks book, Becoming a DBA Rockstar. Read Brad Mcgehee's book, How to Become an Exceptional DBA.

Once you're done with those, you should know what's necessary.

more ▼

answered Apr 07, 2015 at 10:12 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

Thanks Grant fritchey for your positive response.but please tell me some fundamental steps taken for real scenario Experience for DBA interview preparation.i am very keen to learn but so much confusion in mind how do start preparation.

Apr 08, 2015 at 05:34 PM rakeshsingh1983

You prepare for the interview by knowing your stuff. That's all. I don't have a list of questions for you study so you can skip the knowledge and understanding part of the job. That's fundamental.

Here's a question I ask regularly, as a phone screen, before you get in the room for the real interview. If you can ace this, without looking stuff up, you might be ready to go. If you don't understand this, you should read those books.

"What is the difference between a block and a deadlock?"

Get that, you're ready.

Apr 08, 2015 at 06:18 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

FWIW, most folks interviewing a DBA candidate could care less about certifications unless you also have 3-5 years of experience to back it up. Anyone can get an exam cram and pass the test and because of that the certs don't count for much. Reading the books @grantfritchey listed is a fantastic start, also for extended learning Pluralsight has a lot of courses available on SQL Server from real world professionals. SimpleTalk has lots of ebooks you should take advantage of too. When interviewing don't be afraid to say "I don't Know". None of us can know everything. Show them you are eager to learn, have the aptitude to learn and you will do fine.

more ▼

answered Apr 10, 2015 at 01:26 PM

avatar image

150 2 2

"I don't know, but here's what I'd do to find out..." is also a great answer. And I agree on the Certs. They might get you past HR, but no farther.

Apr 10, 2015 at 02:36 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

Best place to start is to google! Or at least search this forum, unsurprisingly you're not the first to as the question.

Read the responses in the link below.


more ▼

answered Apr 07, 2015 at 08:51 AM

avatar image

3.9k 6 11 14

(comments are locked)
10|1200 characters needed characters left

When you say some part of DBA, include Backup and JOb scheduling, that itself is one of the most important and responsible task of being DBA.

Its not only about just DATABASES, its far more than that. Its very important you plan you're path and start focusing to get the plan right.

To improve and to learn along with good experience will enhance you.

Attend seminars, conferences, read blogs/websites for same, self study.Simple the more you dive deep the more you learn.

Also, per my experience DBA not only revolves around SQL, it also requires understanding of hardware, os system requirements, operating tools etc.

For certifications, you can opt as beginner level on Microsoft learning page.

For more, read this

more ▼

answered Apr 06, 2015 at 07:40 PM

avatar image

641 2 8 9

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 06, 2015 at 07:12 PM

Seen: 162 times

Last Updated: Apr 10, 2015 at 02:36 PM

Copyright 2018 Redgate Software. Privacy Policy