What are the best database administrator qualifications and training to get ahead?

Get new comments by email
You can cancel email alerts at anytime.
Comments (16)

Host

What is the best training for becoming a database administrator? What types of ongoing training or certifications are necessary to be an effective database administrator?

What do non-traditional career paths look like?

Reply - Report abuse

Funke in Norcross, Georgia

66 months ago

I recently completed the Oracle 10g DBA training and am preparing for the certification exams. I am very interested in a voluntary / internship role where I can get some real hands on experience as a DBA. I am an IT professional with a background in development but have not done any DBA work. I believe this experience would give me a good path back into the workplace and into the role of a DBA. Can anyone advise?

- Was this comment helpful? Yes (25) / No (7) Reply - Report abuse

Ginger

66 months ago

Funke said: I recently completed the Oracle 10g DBA training and am preparing for the certification exams. I am very interested in a voluntary / internship role where I can get some real hands on experience as a DBA. I am an IT professional with a background in development but have not done any DBA work. I believe this experience would give me a good path back into the workplace and into the role of a DBA. Can anyone advise?
Are you currently unemployed and you're referring to the job you're searching for? What exactly did you learn in that Oracle class you just completed?

- Was this comment helpful? Yes (4) / No (6) Reply - Report abuse

Bud in Glen Burnie, Maryland

55 months ago

Oracle is much more lucrative than SQL Server

- Was this comment helpful? Yes (3) / No (6) Reply - Report abuse

ofostu in Accra, Ghana

41 months ago

I want to become a Database Administrator what do need to know?

- Was this comment helpful? Yes (26) / No (4) Reply - Report abuse

Rose Ssemuyaba in London, United Kingdom

40 months ago

Taiwo in Fort Worth, Texas said: Is it a good idea to have a combine training on both Oracle DBA and MS SQL Server DBA to increase the chance of getting a DBA job? OR which one of the DBAs skills mentioned is more lucrative?.

I think both are equally marketable

- Was this comment helpful? Yes (1) / No (2) Reply - Report abuse

ujv in La Conner, Washington

35 months ago

Neither is more lucrative. Oracle is viewed as more lucrative because of its global use and its more expensive training.

SQL is, has been, and remains the core language to industry DBAs. Know it thoroughly. Get certs with both Server 2008 and Oracle 11 before expecting to bring in 100k/yr with overtime, and make sure you're an expert in Reporting and T-SQL before putting them on your resume. Development doesn't hurt either, even though, as a DBA, I much prefer administration to development.

The hard part is always hooking an employer to start you in an entry-level position as a DBA. In the depression, even harder still. Those with contacts, or those able to develop such contacts, ON THE INSIDE, will be the ones to get relevant experience first. Headhunters are worthless during these bad economies.

- Was this comment helpful? Yes (8) / No Reply - Report abuse

albert002 in san fransisco, California

34 months ago

YOu can do certification..like i just completed my oca certification from
dvds from cpisolution.com. I completed my oca certification jsut installed oracle database from oracle site and studied everything through video..even i have completed my oca certification..Currently giving my ocp certification..but for that hands on experience is a must..
.

- Was this comment helpful? Yes / No (1) Reply - Report abuse

Rich in Northfield, Vermont

16 months ago

Certifications will only get you so far. The real-world experience is far more important. I got my first break at DBA work when a manager noticed that I had a very strong aptitude for working with a Filemaker Pro program - and I was asked if I was interested in doing database work. The rest is history - been doing database work now for over 15 years and still love it.
So two things:
- Get your first break by showing aptitude, even if you're not in a traditional DBA job.
- Certs will help show that you know can administer the system, etc.
- BUT, you MUST know the concepts of relational databases INSIDE and OUT in order to be really effective as a DBA.

Good luck -
Rich H.
Northfield Falls, VT

- Was this comment helpful? Yes (5) / No (2) Reply - Report abuse

Uduakobong in Mountain View, California

11 months ago

I want to become a database administrator.I need advice on what to know.

- Was this comment helpful? Yes / No (1) Reply - Report abuse

Rich in Northfield, Vermont

11 months ago

Uduakobong in Mountain View, California said: I want to become a database administrator.I need advice on what to know.

Here are a few ideas to be well-rounded as a DBA:

- Learn the design aspects, such as entity diagramming, normalization, and how to design and build an efficient relational database.
- Learn as much as you can about querying with SQL. Every DBA knows SQL. You shouldn't be any different.
- Reporting. If the data goes in, but never comes out, what's the point? Cognos Reports, Crystal Reports, etc are common tools used for reporting. This should be the easy part to learn.
- Your problem solving skills and the ability to think algorithmically are very important. Often times you may need to refactor an existing database. There are many more situations where you will need to "tweak" existing databases as opposed to building new ones.
- You can focus on specific vendor certifications if you want (Oracle, SQL Server, mySQL, whatever), but I firmly believe that the more you know of your fundamental database concepts and practices, you should be able to use any vendor's implementation with some minor adjustments.
- Industry wants certifications. A bachelor's degree in a computing discipline, and a certification will get some attention.

Hope that helps. I've been working with databases for over 15 years and am still learning new tricks. It does get easier with time and experience.

-Rich

- Was this comment helpful? Yes (9) / No Reply - Report abuse

dba.struggler@gmail.com in Ahmadabad, India

3 months ago

Hi,
Let me tell you my story. I have been in web development since 2 years with strong database knowledge of SQL Server, but newbie for Oracle though I have an OCP certification. I got less opportunity in Oracle. And the opportunities which I got were very less than what i was expecting.
So what i can conclude from my experience is, certify your self if you are a dba!

- Was this comment helpful? Yes / No (2) Reply - Report abuse

barrettnjeri in Spanish Town, Jamaica

18 days ago

i want to know the qualifications for this job

- Was this comment helpful? Yes / No (2) Reply - Report abuse

prashanth kaladi in Bangalore, India

15 days ago

i am doing my masters in systems,, and completed my graduation in computer application.. nw i want to become ad at base administerator.. could u pls sugest me sir

- Was this comment helpful? Yes / No (1) Reply - Report abuse

Rich Huebner in Northfield, Vermont

11 days ago

barrettnjeri in Spanish Town, Jamaica said: i want to know the qualifications for this job

Typically, a Bachelor's degree in some area of computing is needed, in which you would have taken at least one database course.

Most companies will ask that you are proficient in a specific vendor implementation, such as Sql Server, Oracle, etc. PLUS, you should also have a good grasp of at least one programming language, preferably two. If you study Oracle or want an Oracle DBA job, you will need to know Java. You can get away with VB.NET, C#, or C++ with a SQL Server DBA.

It's helpful to know how to use a programming languages API for accessing different types of databases as well.

Get certified as either MCITP-DBA (Microsoft), OCP or OCM (Oracle), or IBM's DB2 database. These are three of the largest in use. I've decided to focus on mySQL and MS SQL Server.

The key is to do LOADS of hands on practice on your own machine in your own spare time. That is how I've learned a lot, plus taken several graduate level courses in databases as well.

Hope this helps!
Rich

- Was this comment helpful? Yes / No Reply - Report abuse

rssemuyaba in London, United Kingdom

10 days ago

Many thanks. Your advice is very helpful

- Was this comment helpful? Yes / No Reply - Report abuse

Your Reply

change location - create a profile
User Name
 in Beverly Hills, California
Your Comment
Your Email Address
Enter the numbers you see in the box
CAPTCHA Image

Be Reasonable! Be Polite! Please read our Terms of Service and Forum Rules, where it notes that you are responsible for your own comments. You may post anonymously - but we reserve the right to remove inappropriate comments at any time.

RSS Feed Icon Subscribe to this discussion as an RSS feed.