Aug 24, 2010
10 Character Traits of Outstanding DBA’s
What are the character traits of outstanding SQL Server Database Administrators (DBA) ?
You know what I’m talking about. There are DBA’s out there that go way above and beyond merely getting the job done. Managing huge workloads with ease and delivering them with class. But how do they do it?
I’m certain you have seen and experienced first hand what I’m talking about and yet it can be difficult to quantify what exactly it is that makes these individuals such outstanding professionals. Personally I do not consider there to be a magic formula but rather an assortment of desirable qualities and traits that are commonly present in outstanding DBA’s.
“What character traits and qualities do you think make an outstanding DBA?”
In no particular order, here are some of the traits that I have been able to identify and consider as desirable qualities of outstanding DBA’s.
1. Excellent Attention to Detail
“Ninja-like focus”
A DBA is regularly expected to perform complex administrative tasks incorporating multiple steps. Even with the assistance of a Play-By-Play or other detailed documentation, the outstanding DBA needs to be on the ball at all times and leave nothing to chance.
Working with mission critical production systems means you need to expect the unexpected. Check, double check and triple check implementations. The outstanding DBA knows through experience what to watch out for when administering a SQL Server environment but on no occasion will anything be left to chance. They have mastered the DBA Survival Skill of Thinking Defensively.
2. A Natural Problem Solver
Problems or rather delivering solutions to problems is the outstanding DBA’s bread and butter. They have a passion for problem solving and relish the opportunity to take on any challenge that comes their way.
Within an organisation it is quite common for the DBA to be consulted on problems that may not initially be within their domain of responsibility because their problem solving talents can be leveraged in a variety of parallel business disciplines.
Problem solving is fun for these people. The more difficult and challenging the problem, the more determined they are to solve it.
Enjoy solving puzzles? Check out this SQL Server Crossword.
3. Assertive
Being a DBA means you need to be able to communicate your views confidently, clearly, calmly and concisely, oftentimes under high pressure circumstances.
Your opinions will almost certainly be challenged, which is a good thing because it means your peers are thinking about the issue at hand. A DBA who successfully asserts themself is both polite and firm, without being an ass. See The Politics of SQL Server Performance.
“Don’t be this guy!”
4. Tactful
The outstanding DBA is a master tactician, understanding that decisions will be required that at times result in a conflict of interest. The production DBA for example can often be viewed as a path of resistance to a development team and must walk the fine line of ensuring security & availability, whilst at the same time not hampering delivery.
Understanding the business and more specifically their role within it enables the DBA to maintain an objective outlook and operate more effectively within their organisation.
5. Manage Relationships
The outstanding DBA is a corporate chameleon with a talent for communicating effectively with all levels of the business. In order to operate successfully within larger organisations the DBA must forge and manage relationships across the business.
Corporate politics aside, good communication skills and character are the key.
6. A Good Decision Maker
Able to quickly weigh up the pros and cons of a situation, whilst keeping the big picture in mind, enables the outstanding DBA to make good decisions. It’s all to easy for a data professional to become bogged down in the detail but it’s important to always consider the bigger picture of all tasks undertaken.
Developing and demonstrating an understanding of the business not only assists in making good decisions but also highlight the value of the outstanding DBA to the business and it’s decision makers.
7. Humble
Far from being arrogant, the outstanding DBA has an in depth knowledge and understanding of SQL Server but is humble in it’s application. They teach rather than preach.
As a knowledge expert the outstanding DBA is keen to share their knowledge with all who wish to learn. Often very active in the SQL community, posting on forums, blogging and Tweeting, these data professionals make for excellent mentors.
Conversely the outstanding DBA is always looking to learn, understanding that no one data professional knows all there is to know about SQL Server. See Jump Start Your SQL Server Learning Today to find out more.
“Everybody Be Cool”
8. Calm Under Pressure
When it’s all kicking off and panic ensues, the outstanding DBA keeps a cool head and takes it all in their stride. You will often find this quality in Production DBA’s that work with highly available OLTP platforms daily. Pressure just goes with the territory.
9. Business Minded
Those that can demonstrate an understanding of the business, apply big picture thinking and prioritisation to their activities will deliver more value to their company. Business decision makers notice this skill, ensuring that the outstanding DBA is considered as a knowledge expert and is consulted on all business decisions that affect the environment they administer. This in turn empowers the DBA further to deliver even more value thereby continuing the cycle.
10. Approachable
Got a problem with SQL Server? The outstanding DBA is “the” SQL Server go-to-guy within their organisation. No matter what else they have going on they will make time for you and are always available to provide guidance, support and assistance.
Whether or not it is possible to master or to implement all of these traits is debatable but what is clear is that they are both common and present amongst outstanding DBA’s. What character traits and qualities do you think make an outstanding DBA? Share your thoughts and comments below.
Aug 25, 2010 @ 08:54:54
You forgot one!
11. Never makes mistakes.
Aug 25, 2010 @ 15:13:20
I think my point was, know how to cover your arse for mistakes you will inevitably make. An outstanding DBA obviously backs what he/she needs to first, verifies the backup etc etc and never forgets to do that before accidentally implementing a production change on the wrong database which he/she hasn’t just backed up, eh?
Aug 25, 2010 @ 15:29:24
P.S. I forgot to say the most important thing, Jon – nice article, well done & well written.
Nov 05, 2010 @ 20:40:52
Couldn’t agree more! But don’t forget “the ability to deal with idiots, especially when they’re your boss”…
Feb 14, 2012 @ 04:17:00
All these rules and suggestions are great and I thank you for posting them. I’d like to summarize using a quote written by David Poole about being an exceptional DB.
“If you are in the position where people will voluntarily use you as the first point of contact for database information rather than the last, then you are probably an exceptional DBA”
Feb 14, 2012 @ 08:27:00
My pleasure Jeff. That is indeed a great quote.
I like the inclusion of the word “probably” in particular…..if folks always come to you first in order to get results, let’s hope it’s not because you’re a pushover
Thanks for your comments sir!
Apr 09, 2012 @ 19:23:00
Sorry missing number 1, understand the data and how it impacts the company, no ands ifs or buts, always number one, always. I will take a medicore DBA any day over the technogeek who has your 10 down. All the other 10 need to be based upon that number one, I have no interest in your cool poweshell script when my 10,000 orders don’t go out tonight.
Apr 09, 2012 @ 20:22:00
An excellent trait suggestion for inclusion and one that I also agree is of paramount importance. So much so in fact, that I wrote an entire post on it, The Database Administrators Primary Repsonsibility
Thanks for your comments.
Jul 20, 2012 @ 12:50:55
Yep, couldn’t agree more
Mar 12, 2013 @ 14:06:40
Again, hitting me square in the nose. I now have these hanging on my wall. One that I will like to add for myself is Trustworthy. DBA’s have a huge responsibility and if you are on a team of people it is important to know that DBA’s all trust one another along with the business trusting you. I’ve got to know going into battle that the team members have my six and that I’ve got theirs; we pick each other up when we fall (yes we are human). The business units need to trust the DBA’s as well knowing that they can sleep safely at night because their data is in good hands.
Nice post once again John; nice to see 2010 posts are still ever present in 2013
Mar 12, 2013 @ 19:01:24
A most excellent character trait suggestion Chris. So much so in fact that I’m somewhat surprised it did not make the original list/cut. You’re absolutely right, you just can’t put a value on how important trust is for a Data Professional. Once it’s lost, well, it’s pretty much game over really. Such is the level of responsibility we shoulder.
Ha! A timeless post, trust me they’re rare. As an author I’m more accustomed to looking back at previous work and cringing. I think we all do. Eyes forward….