The Value of the MCDBA and MCITP DBA Certification

By:   |   Updated: 2007-05-07   |   Comments (17)   |   Related: More > Professional Development Certifications


Problem

At a recent Northern Virginia SQL Server user group meeting, a debate was held about the Microsoft Certified Database Administrator\Microsoft Certified Information Technology Professional : Database Administrator being a 'must-have' for all SQL Server DBAs.  As such, let's explore some key questions.  Is it worth studying for the MCDBA\MCITP:DBA exams or not?  Is this time well spent?  How time consuming will the studying be to pass the tests?  Is the MCDBA\MCITP:DBA just about studying for and passing tests?  Will the MCDBA\MCITP:DBA help DBAs get a job or a raise?

Solution

In an earlier tip (SQL Server 2000 and 2005 Certification Resources), we outlined the steps needed to earn the premier SQL Server certification.  During the debate at the recent user group meeting, what really surfaced is that the Microsoft Certified Database Administrator\Microsoft Certified Information Technology Professional : Database Administrator has a different meaning for each person, at a high level, but the bottom line is that the certification is not a single indicator of a DBAs performance on the job.  In reality the premier SQL Server certifications are just one of many factors to land a SQL Server DBA position, but the feedback from the user group could be categorized in the following manner:

Advantages

  • With the MCDBA\MCITP:DBA this is one indicator that can open the window of opportunity at particular organizations.
  • At some organizations, particularly government organizations, the MCDBA\MCITP:DBA certification is a requirement for particular types or levels of positions.
  • From an employers perspective, the certification is an indicator that the individual has the aptitude to study and pass a test.
  • For some organizations the MCDBA\MCITP:DBA certification is considered a viable assessment for a DBAs skills.  Since the tests are written and administered via a third party, they can be assured that the testing body has the base set of knowledge that the organization does not have internally to make a technical assessment. 
  • If the certification is used as an opportunity to learn, it can serve as time well spent learning about SQL Server.

Disadvantages

  • No single certification can measure technical, problem solving, etc. skills to serve as a definitive assessment for successfully building and managing SQL Server applications.  This is especially the case if the questions and answers are just memorized, and the true opportunity to learn SQL Server is not leveraged.
  • Just because someone passes the certification tests does not necessarily mean they will fit into the team and make positive contributions to the organization.
  • The tests only take into consideration native Microsoft options, not third party solutions that may be a better solution.
  • The MCDBA\MCITP:DBA certification is only one of many indicators that should be taken into consideration when hiring or promoting a DBA.
  • Many highly skilled and qualified DBAs do not have certifications, but are more than knowledgeable and capable of building and supporting SQL Server applications in the enterprise.

Summary

The bottom line is that the MCDBA\MCITP:DBA certification means many different things to many different people.  However, in our opinions, if it is used as a mechanism to learn about SQL Server to genuinely expand your knowledge then it should be considered a positive experience.  When it is balanced with experience and many intangible skills, then the certification is one of many litmus tests.  If you are new to SQL Server, either switching database platforms or trying to get your start in the industry, then the certification is a means to open that window of opportunity.  So go for it!

From an organizational perspective, keep in mind that the MCDBA\MCITP:DBA certification does not necessarily equal success from either a team perspective or organizational contribution.  This means that the certification is only one of many factors that should be included during the interview process, not a single definitive indicator to a DBAs success.

Next Steps
  • As a DBA, figure out where you stand on this debate and think about how the MCDBA\MCITP:DBA certification can help you in your current position and in your overall career.
  • As a Database, Operational or Development Manager, pull together your thoughts on the value of the MCDBA\MCITP:DBA certification then determine how it should impact your current team members when it comes time for training and raises as well as a factor for hiring your future team members.
  • As an organization, the bigger picture question here is the investment in your employees from an educational, certification and continuing education perspective independent of the department.  See where this priority fits into the overall organizational list.
  • Check out the Professional Development tips on MSSQLTips.com.


sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip



About the author
MSSQLTips author Jeremy Kadlec Jeremy Kadlec is a Co-Founder, Editor and Author at MSSQLTips.com with more than 300 contributions. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP. Jeremy brings 20+ years of SQL Server DBA and Developer experience to the community after earning a bachelor's degree from SSU and master's from UMBC.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips


Article Last Updated: 2007-05-07

Comments For This Article




Tuesday, May 28, 2013 - 8:57:06 PM - Jeremy Kadlec Back To Top (25173)

Paul,

Thank you for sharing your aspirations!  I agree with you.

Thank you,
Jeremy Kadlec
Community Co-Leader

Tuesday, May 28, 2013 - 2:01:27 PM - Paul Thompson Back To Top (25170)

In the past 2 years, I have passed MCTS and MCITP: DBA.  My aspiration is to transition from Database Architect to a DBA.  I wanted to take positve steps in achieving this goal.  I felt like getting these certifications is the best way I can prove to a would be employer that Im worthy of the opportunity.  I certainly cant see how it could hurt. 

Sunday, December 16, 2012 - 2:36:45 PM - Jeremy Kadlec Back To Top (20970)

Diana,

That is a pretty hard question to answer.  I would encourage you to complete both items.

Thank you,
Jeremy Kadlec

Saturday, December 15, 2012 - 11:37:32 PM - Diana Back To Top (20966)

Hi! I am a current college student and was looking into getting the MCDBA (Microsoft Certified Database Administrator) Certificate that is offered at my school. I was wondering, if i was to get this certificate and not yet have my degree, would I still be able to get a good job with only the certificate?

Tuesday, October 30, 2012 - 2:58:24 AM - Abid hussain tabassum Back To Top (20141)

Hi,

As per my understanding, One should must certified, hence you are professional and have experienced.

Thanks,

Abid Hussain Tabassum

Thursday, August 23, 2012 - 8:32:33 AM - Jeremy Kadlec Back To Top (19190)

Leon,

If your company is using SQL Server 2008 and continues to do so, that could still make sense.  If that is not the case, I think in general, it makes more sense to focus on SQL Server 2012. 

HTH,

Thank you,
Jeremy Kadlec

Monday, June 18, 2012 - 6:15:14 AM - Leon Cosens Back To Top (18083)

Does anyone have advice about whether to start working towards SQL 2012 versions versus the now aging 2008 certifications?

Wednesday, May 23, 2012 - 8:37:15 AM - Chris Nelson Back To Top (17604)

You need to update this article for the 2012 ceritifications.

Thanks!

Wednesday, April 25, 2012 - 10:35:34 AM - Jeremy Kadlec Back To Top (17104)

Vera VB and Ken,

Thank you so much for your insight and sharing your experiences.

Thank you,
Jeremy Kadlec

Wednesday, April 25, 2012 - 9:47:30 AM - Ken Back To Top (17100)

While I do not have any certifications under my belt, I do think that anyone who is serious about SQL Server should attempt to get the certifications or at least take the practice tests. As others have noted, the tests force you to learn parts of SQL Server that you may be less familiar with and that knowledge can make you a more valuable employee. I am currently reading a SQL BI training book and even though 75% of the book has been review for me, that 25% of information that I am picking up has already helped me optimize some of my current work and given me inspiration towards some future development. So, in my opinion, unless you already know everything that there is to know about a product, reading up and getting tested can only make you a more knowledgable and more valuable employee. Plus it doesn't hurt to have that piece of paper come interview time!

Wednesday, April 25, 2012 - 9:17:20 AM - Vera VB Back To Top (17099)

For me studying for 2005 DBA gave me an inside in topics that I didn't know existed. I'm having a DBA meeting with 2 other DBA persons twice a month and in every meeting we have a learning moment where I demonstrate some of the knowledge I gained by becoming certified. We then discuss if and where we can use it. So yes, certification was important for me. Not to get a job, but to become better at doing my job. I'm now studying to upgrade my MCITP 2005 to 2008. I like studying things that make me better in my job, that help me do things faster or in less steps then I used to do.

Tuesday, July 12, 2011 - 8:29:34 PM - Jeremy Kadlec Back To Top (14157)

Dave,

Thank you for your insight into your hiring process with respect to the SQL Server certifications.

Thank you,
Jeremy Kadlec

Tuesday, July 12, 2011 - 8:07:51 AM - Dave Ott Back To Top (14154)

When I studied for the 2005 DBA and BI exams I found there was some areas of SQL Server I did not know as well as I should have. It helped me professionally because I then applied what I learned to the job. It made such an impression that now our group is strongly encouraged to get the 2008 certs. The fact that the company pays for passed exams helps a great deal.

When bringing someone into our group it's not a requirement, but it does tell me that the person has the ambition and ability to learn, which I think is key to success.

Monday, April 18, 2011 - 7:50:56 PM - Jeremy Kadlec Back To Top (13629)

Adam,

Thank you for sharing your post.

Thank you,
Jeremy Kadlec

Monday, April 18, 2011 - 7:42:50 PM - Adam Back To Top (13628)

I studied for 432 and passed it a couple years ago. I did it for personal growth. Since then, it has given me an edge getting interviews, especially at places that get audited on who they hire. Some companies need to provide proof that they hired a qualified candidate. To do this, they use MS certs to show the individual is competent. Having said this, I completely understand how some people disregard certs. You could study for the tests for a couple weeks and pass it without ever having any real world experience. Just like in history, we all studied when the Magna Carta was issued but how many people actually remember what the Magna Carta is?

Tuesday, March 2, 2010 - 2:21:11 PM - admin Back To Top (4993)

Knowledge_Seeker,

Thank you so much for the post.

Thank you,
The MSSQLTips Team

Tuesday, March 2, 2010 - 1:55:07 PM - knowledge_seeker Back To Top (4992)

When seeking certifications, I've found a huge benefit to studying for and achieving that piece of paper. 

I was very comfortable in the environment and in the tools that I use every day to perform my DBA/Developer duties. However, after studying for the 70-431, 70-433, and 70-451 exams, I've "learned" that there are a lot of new features that would have made my job easier had I upgraded to MS SQL 2005 and/or 2008. I can now do natively in 2005/2008 what was impossible before, or difficult to implement, using native T-SQL or MS SQL 2000's features. These features can be of great benefit to the organizations you work for, and the certifications can only help (not hurt) your career.

We all knew MS SQL Server 2008 was the best database engine available today, but, with certifications, now you know why!














get free sql tips
agree to terms