SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Skill Set of the Exceptional DBA

By Tony Davis,

In my previous editorial on this topic, I stated that the An Exceptional DBA is defined more by what they do than what they know. Judging by the responses, there is little disputing this fact among DBW readers. However, before we accept technical knowledge as a "given", and move on, I'd like to consider the question of what exactly an exceptional DBA does need to know.

When many people hear "DBA", they think "Production DBA", with skills covering all the "core" aspects of managing and safeguarding a company's databases and data, including such as backups and restores, securing data, performance tuning and troubleshooting, monitoring, auditing and so on. Alongside the Production DBA, is the Development DBA, who tends to look after the development and test databases, and is expert in all aspects of T-SQL.

However, there are many other areas in which the Exceptional DBA can and should specialize. Some of these niches, such as "database design specialist", are well-established, but others, such as "reporting / business intelligence specialist", or "high availability specialist" are newer and in increasing demand.

I would suggest that any Exceptional DBA needs:

  1. Sound knowledge of all "core" aspects of a DBA's job
  2. Inside-out knowledge of one chosen specialist area
  3. Adaptability

Adaptability is vital. Don't get too comfortable in your chosen niche, because technology, and the demands placed on the DBA, are changing more rapidly than ever. The exceptional DBA never stops learning new skills.

What do you think? Given the apparently bleak economic conditions, I'd love to hear what "hard skills" are the ones that will make a DBA stand out. How broad does that skill set have to be? I'm sure many DBAs have read job requirements for a DBA role and thought "is it really possible for a human to have these skills AND a family life?"

I'd like to thank everyone for their responses to my last editorial. I've posted a response here, and difficult choice as it was, picked Ian Massi as the winner of the $50 Amazon voucher.

The same prize applies this time – and I'll also have a few e-copies of Brad McGehee's forthcoming "How to become an Exceptional DBA" to hand out!

Total article views: 1123 | Views in the last 30 days: 2
Related Articles

The Exceptional DBA: Soft Skills

If impeccable technical skills are a "given", what are the soft shills that will make you an Excepti...


Specialist or Generalist

The idea of being a generalist of specialist may not need to be a choice.


The Skill Set of the Exceptional DBA

Comments posted to this topic are about the item [B]The Skill Set of the Exceptional DBA[/B] Tony, ...


Specialists or Generalists: Who are best as Developers?

Should we have specialists or generalists working as developers in our companies? A guest editorial ...


Systems Specialist-Database Specialist-South Bend, IN

This is an on-site contract to hire role in South Bend, IN SUMMARY The Systems Specialist IV – D...

database weekly