• subscribe
August 26, 2010 11:40 AM

Is There a Shortage of SQL Server Experts?

SQL Server Pro
InstantDoc ID #125860

I spoke with a few senior people from Microsoft’s SQL Server group recently and they shared a sentiment that surprised me. Apparently, some reasonably large customers, who might otherwise be very open to running large parts of their business on SQL Server, are opting to stay on Oracle because they perceive that there simply isn’t a large enough supply of very senior SQL Server DBAs and professionals in the work force compared to the Oracle space.

That thinking wouldn’t have surprised me a decade ago, but in 2010? I’m surprised. I learned the adage “perception is reality” early in my consulting career. So, in this case, does it really matter if there’s an actual lack of qualified staff if business decision makers are acting based on that perception being true?

In the short term, this perception might influence whether a company uses SQL Server regardless of whether the perceived lack of senior staff is real. However, if the perception isn’t based on reality addressing the matter with a company is an exercise in helping them understand that there are senior SQL Server technologists available to hire and where and how to find them.

I suspect that reality is a little bit of both.

There are certainly many world-class SQL Server experts, and there have been for quite some time. I suppose it’s more of a matter if there are enough available to satisfy demand. One observation I’ll make is that many of “famous” SQL Server experts I know are consultants who presumably aren’t interested in working full-time for a single company in a DBA capacity. Note that I didn’t say the best SQL Server people are consultants; I used the word “famous.” I’ve long suspected that for every PASS pre-con speaker there are dozens of people who are just as talented on a technical level and don’t desire to be famous or simply haven’t had the break that propels them to attention on the community stage. So, I wonder—am I right about that? If I’m right, then I suspect that the lack of expert and very senior SQL Server technologists is largely perception rather than reality.

I’m not going to share any more of my thoughts on this topic this week. Instead, I could really use your help. I’d love to know what you think. Is there a shortage of very senior SQL Server professionals? If yes, what skills do you think are most lacking? What do you see in your company or companies that your friends work at? I’m thinking that a bit of grass roots detective work can help uncover the truth behind this perception.  Please feel free to email me directly at bmoran@solidq.com or comment on this article. I’d really like to know what you think.

By the way, I plan to cover this topic more than once over the coming weeks and months. Yes, I said weeks. I’m not going back to writing more than one time per month in SQL Server Magazine UPDATE, but I’m excited to announce that I’ll soon be launching a new blog on www.sqlmag.com that will focus on SQL Server business decision maker’s and those who aspire to be business decision makers. I’ll be writing there at least weekly, and sometimes more often. We hope to launch the blog sometime in September.



ARTICLE TOOLS

Comments
  • John Langston
    2 years ago
    Aug 28, 2010

    What is a SQL Server "expert" and what constitutes "senior level"?

    I agree with Poolet's comments relative to how the product has been positioned.

    In my geographical area I see a recurring phenomenon: Organizations need applications for business users so developers are hired to either write or install the app and the app either runs against SQL Server or SQL Server is chosen as the database of choice during develiopment.

    In either case the developer, using Mgt Studio, becomes a "database expert" and says "What's so difficult about this?" Management sees the end result and asks "So why do I need a DBA?"

    If a DBA is hired, the developer is there to make claims about SQL Server that the DBA is expected to prove or disprove (rather than the one making the claim be asked to prove/disprove their claim).

    I see hardware being selected on the basis of the front-end rather than the disk subsystem and I see database designs with one monster table at the center of the universe and the developer wonders why there is blocking/locking when their systems is launched and accuses the DBA of not knowing their stuff.




  • Johnston
    2 years ago
    Aug 27, 2010

    I think the question should be "Is there a shortage of SQL DBA's who can handle multiple skill sets. How many SQL DBA's can write SQL queries, diagnose performance problems,create DR and HA solution, write SSIS packages, take care of SharePoint administration, know the pros and cons of virtualizatio, learn Powershell... the list goes on and on. The traditional roles are gone and they need to be redefined because of Business Intelligence. Now throw in a 24/7 on call commitment, no wonder everyone wants to be a consultant

  • Bragdon
    2 years ago
    Aug 27, 2010

    Now thats the problem "Maybe it's because Microsoft's tools (SSAS, SSIS, SSRS) have only been a focus in the past five years SQL Server DBAs are required to know not only the database engine but all aspects of the server i.e. (SSAS, SSIS, SSRS). Are these pure DBA skill sets or added bonuses? So when a hiring manager asks for a DBA to have SSAS, SSIS, SSRS is he/she really asking for a developer. With each one of these skill sets you need to now HTML, VB.NET, ADO.NET and possibly AJAX. When I read job descriptions requesting for a DBA and then list those requires the first two things that come to mind is either they dont know what they want or they are looking for a Developer with some SQL Server Administration. Lets not forget IIS, Windows Sever, RAID, SANS, Cluster, Replication as well as other technologies that are required Does the term DBA mean the same thing it did 10 years ago?

  • Bragdon
    2 years ago
    Aug 27, 2010

    Now thats the problem "Maybe it's because Microsoft's tools (SSAS, SSIS, SSRS) have only been a focus in the past five years SQL Server DBAs are required to know not only the database engine but all aspects of the server i.e. (SSAS, SSIS, SSRS). Are these pure DBA skill sets or added bonuses? So when a hiring manager asks for a DBA to have SSAS, SSIS, SSRS is he/she really asking for a developer. With each one of these skill sets you need to now HTML, VB.NET, ADO.NET and possibly AJAX. When I read job descriptions requesting for a DBA and then list those requires the first two things that come to mind is either they dont know what they want or they are looking for a Developer with some SQL Server Administration. Lets not forget IIS, Windows Sever, RAID, SANS, Cluster, Replication as well as other technologies that are required Does the term DBA mean the same thing it did 10 years ago?

  • Keisler
    2 years ago
    Aug 27, 2010

    This article is so true. I've interviewed dozens of SQL DBAs over the past few years for my company, and it's apparent that there is a shortage of senior DBAs. All I have to do is ask how to do a database task by just using T-SQL. 95% of the interviewees can't do the work when the GUI is out of play.

You must log on before posting a comment.

Are you a new visitor? Register Here