The power of Oracle certification

Author: Michael J. Hillenbrand
Step aside … I am certified!

Just two days after I proudly framed and hung my first Oracle OCP certification on my cubicle wall, one of my colleagues hung a Dilbert cartoon right next to it. The Dilbert went something like this.

In the first frame Dilbert is having trouble with his computer. A superhero in tights with a Capital C on his chest tells Dilbert "Step away from the server, I am certified!" In the next frame, our superhero sits down in front of the computer, Dilbert now watching over his shoulder, and says "I SUMMON THE VAST POWER OF CERTIFICATION!" In the last frame, the superhero realizes he doesn't know what to do and admits, "This is embarrassing -- that's all I remember from the classes."

The certification debate

Whether or not to get certified has been a widely debated topic for as long as I can remember. On one side of the fence are those that see great value in certification, that claim that there is no better way to measure a candidate's technical ability. On the other side of the fence are those that see absolutely no value in certifications, that argue that a piece of paper earned by memorizing and taking a multiple-choice test does not prove or replace the value of true experience and real-world knowledge.

As for me, you could say that I am sitting directly on the fence, as I believe both arguments are somewhat valid. In this article, I will discuss the certification process and examine some of the arguments for and against certifications.

The certification process

First and foremost, you need to fully understand the process of getting certification before you can truly measure its value.

Let's first take a look at the certification process for Oracle DBAs. The Oracle certification process has certainly come a long way since I earned my first Oracle certification. Years ago (I hate to admit just how many years) all anyone had to do to get 7.3 certified was take and pass a single multiple-choice test. I took mine for free at an IOUG conference in Philadelphia. For my efforts I received a certificate, a pin and a cool logo that claimed me as an "Oracle Certified Professional," or OCP for short. I later upgraded that certification to 8i OCP by taking yet another single upgrade test. This is the last DBA certification I will likely possess for a couple of reasons. For one, my role as DBA has changed as I entered into management, and for another, Oracle has made the process a lot more difficult.

For all intents and purposes, the days of the single-test OCP certification are over. The process to become OCP has become a lot more involved and a lot more difficult to attain. Starting with Oracle 8i, to fully qualify for an OCP certification you had to pass a series of five tests. Soon after this, Oracle decided to require you to also take one of its instructor-led DBA courses for certification. While there is arguably some benefit to ensuring that students take a class, let's keep this in business perspective. The requirement was nothing but a marketing ploy to get people into the classrooms, and it did not bode well for those that wanted to earn certification and were not financially sponsored to do so through their companies.

Starting with Oracle 9i, the options for certification have changed yet again, and Oracle has placed even more emphasis on its own classes (good for Oracle):

  • OCA -- Oracle Certified Associate. Requires passing two tests and no training courses.
  • OCP -- Oracle Certified Professional. Requires OCA, one instructor-led course, one exam and one hands-on course.
  • OCM -- Oracle Certified Master. Requires OCP, two advanced courses, a two-day hands-on exam and one additional hands-on course. While this is probably the best measure of ability, it is a very cost-prohibitive option.

While the OCA seems to be a viable option for the average DBA, those who wish to pursue certification on their own, without company sponsorship, will find it financially next to impossible to earn an OCP (two courses) or OCM (five total courses).

Justifying Oracle certification

Perception surrounding the true value of certifications really depends on who you ask. Those with certifications will usually argue that they are important; those without them will most likely turn up their noses at them. What most IT folks do agree upon is this: certifications do hold some amount of value, but they can never replace the relevance of good experience. No matter what position you take, you should realize that certifications must be important to somebody, since the certification industry continues to thrive and grow.

The justification that people will use to get certified is normally related to their own expectations for return on investment. In turn, expectations will ultimately determine the value of certification for each individual. If you are getting certified for the wrong reasons, you are destined to be disappointed with the end results. With that said, let's examine some of the reasons people get certified.

"Certification will help me get a job."

Having certification may help you get an interview, but it will not necessarily help you get a job. Recruiters look for two things in DBAs: core DBMS knowledge and hands-on experience. To measure knowledge, some companies and/or agencies will use certifications to pre-qualify candidate resumes, accepting those that have it and rejecting those that don't. Others will drill candidates on technical questions in a face-to-face interview, whether or not they have a certification.

I typically recommend certification for anybody trying to enter the DBA field, as it will often help get you past HR (human resources) and the recruiters and get a foot in the door for an interview. If you are an aspiring DBA with little experience and searching for that first DBA job, OCA certification OCA is definitely a good first step. I have been recruiting DBAs for 15 years now, and while I do not look for certification as a prerequisite for any position, I have to admit that, all other things being equal, it will give you a slight edge over somebody without it.

While nothing can replace the hands-on experience, problem solving and soft skills needed to be a DBA, being certified is a good way to prove that you understand the basic concepts of Oracle, are willing to go the extra mile to learn, and that you take your career seriously.

"Certification will get me promoted."

If you are getting certified in hopes of instant financial gratification, forget it. Getting certified only proves that you know the textbook concepts or perhaps even that you are merely a good test-taker. Some of my very best DBAs were not certified, and some of them couldn't pass a test if their life depended on it! While I always supported certifications, I would never consider a certification a reason to hand out a promotion. Being in the DBA business for more than 20 years now, I know more than anybody that a certification can never replace the value of good experience, nor can it measure one's ability to apply knowledge in the real world.

The reality is that there are some companies that put more emphasis on certifications. Some may use incentives to promote certification, and some may even require it. If you are providing services to a customer (like consulting or remote DBA services), then that customer might be more comfortable knowing that you are certified in the technologies you are supporting.

"Certification makes me better than you!"

This is hands down the worst idea one could entertain and is probably the biggest reason for the argument against certification. I once knew a DBA who proudly flaunted her Oracle Masters certificate around to her peers. At the time, the Oracle Master was nothing but proof that you attended so many classes and did not even involve passing any tests. Since this particular individual had little experience and no clue how to manage databases in the real world, her flaunting did not earn her favor with her peers and eventually led to her demise in the organization.

Do not be pompous about being certified and never think that you are better than somebody else just because you hold a paper certificate. Certificates are nice to have, but they do not equate to a measure of your ability or level of importance in an organization.

"Certification gives me personal satisfaction!"

This is perhaps the best reason to get certified. If you get a sense of accomplishment and confidence from getting certified and are looking to refresh your knowledge or to stay on top of the latest technologies, then by all means do it. The important thing is to do it for the right reasons. I have to admit that I kept that first OCP certificate hanging in my cubicle for quite some time, not to rub it in any of my colleagues' faces, but rather to remind myself that I earned it and was proud of my accomplishment. I knew that I had the experience and capability to apply my knowledge, so I didn't really mind the aforementioned Dilbert cartoon that was displayed directly under it.


  1. Certification is penis-meter procedure. Only. No more. Surprise?

    Only personal specialist reputations is meant.

    You never ever ask OCM certification from Tjm Kyte. (C) Me.

    And, Anantha, please, show YOU personal knowlege (like Tom) and your reputation. No certificates, please!

  2. I like this: "Certification gives me personal satisfaction!" I completely agree that is getting the certification for the right reason. I was a 21 yr. old with ADHD untreated and was told that I would never be able to accomplish this certification.

    To get the OCPDBA for 8i, I had to pass five exams. I failed the first PL/SQL exam by one question and thought maybe those that said I could not do this were right, but I stuck with it and after 2.5 years I passed all five exams. I learned a lot of fundamental things that I was able to apply to more than only Oracle.

    The company I've been working at for the last 10 years is primarily a Windows shop so, I didn't get to really use my Oracle skills a lot as we worked mostly with MSSQL, but it didn't take long to get up to speed with MSSQL because of the fundamentals that I learned with Oracle. Today I enjoy working with all sorts of technology and for kicks I built a Solaris server running Oracle 11g at home. It's really neat to see the new things that have come about since 8i. Also, I'm a technical services manager now and I agree that some of the best talent on my team don't hold certifications.

  3. interestingly enough, those who diss certifications are ....the ones who usually don't have any.

    While there are a lot of test dumps out there for cheaters, if you study the material seriously, you will focus on 'best practices' which most of us are not necessarily terribly well-acquainted with due to time imperatives in production environments. In addition, both Oracle and SQL Server (800% growth of data footprint in 14 years for SQL Server) have grown so much in the last 10 years that it is becoming increasingly difficult to keep up with all new keywords, objects and utilities. Certifications are a good way to study ALL new developments, in a way forcing you to be somehow a little bit of a polymath , especially since most of us end up complacently preferring certain methods or functions over the years to the detriment of innovation.