What are the key qualities for a SQL Server DBA?

By:   |   Comments (20)   |   Related: More > Professional Development Skills Development


A number of hiring managers have asked me the following question over the years: what key qualities should I look for in a SQL Server DBA?  Often times the key qualities needed are very specific to the customer.  Perhaps they have a large replication installation and really need someone sharp on that part of the SQL Server stack.  Other times the client needs a SQL Server DBA that can wear numerous hats and support a large environment.  This circumstance requires a special person to keep everything running smoothly.  In other situations, having the right fit for the team is most critical.  Check out this tip to learn more about SQL Server DBA key qualities.


As the problem statement alluded, technical skills are sometimes the focus for a candidate search, and other times fitting into the team or being able to meet the unique business goals is most critical.  I know in one circumstance before I started Edgewood Solutions, I was hired specifically because I had experience with SQL Server Upgrades.  At that time, the company had over 100 upgrades that needed to be completed, so that experience helped to set me apart as a candidate for that opportunity. 

On the other side of the coin, there are soft skills or intangible attributes to me that are needed by SQL Server DBAs to help any organization.  To me these are qualities that are not necessarily found on a resume, but can really make or break a DBA based on his/her unique position in the organization.  Let's dive into these items.

Productive Under Pressure

SQL Servers go down.  IO issues are occurring on one SQL Server and another has intense memory pressure.  Emergency code needs to be promoted to a production SQL Server database to fix a client issue.  Five different development managers are breathing down your neck for project needs.  How do you handle pressure?  These events could be occurring simultaneously, in the same day or in the same week.  How you handle these types of situations as a DBA is key.  Do you think being productive under pressure is a key quality for SQL Server DBAs?

Problem Solver

Identifying issues is generally no problem for you or the user community when something is broken.  Correcting them immediately, applying a stop gap measure then designing, testing and implementing a solution, is another story.  This is where your technical skills really come into play and your knowledge of options to address an issue can really shine.  Just because we are SQL Server DBAs does not mean the best solution to every problem is in the form of a stored procedure, SSIS Package or configuration option.  Truly understanding the issue and implementing the correct solution in a rapid manner is easier said than done.  The right solution may be technology on the fringe of your expertise where you have to dive in, figure it out quickly and move on to the next issue. 

Understand Both the Business Needs and Technology Landscape

SQL Server is generally the core software application for many applications and just knowing how SQL Server works generally does not cut it.  Understanding the data and processes are just as critical with more of a focus on business intelligence to identify opportunities for the organization.  Further you need to apply the correct solution for the problem at hand.  As an example, the business may be relying on a manual process that is time consuming and error prone; by understanding the business needs and technology options you can remedy the situation with an automated process.

Willingness to Learn and Open Minded

As technology professionals, there is a need to continuously learn to keep your technical skills sharp and be sure to offer the proper recommendations and implementations for all of your projects.  By continuously learning, hopefully this will give you an open mind to consider alternative ideas and experiment with other technologies that will help round off your knowledge.

Experience to Know When to be Firm and When to be Flexible

You can't get experience out of a book.  Hands-on experience comes with time, successes, failures and seeing through the mess to identify the root cause issues.  This is where you need to figure out if the issue is people, process or technology.  Further, you need to think about the impacts of the decisions being made.  Do not have blinders on when decisions are going to have significant impacts to other departments, applications or processes.  Experience matters, therefore leverage it.

Trust, Honesty and Integrity

As should be the case in all professional positions, trust, honesty and integrity should be at the core of all business relationships.  As DBAs, I think we need to raise the bar well beyond professional standards based on the criticality of our position, data access and accountability to the organization.  In many respects, the DBAs have to keep in mind they need to protect their organization's data just as much as they need to protect their customer's data.


In numerous organizations, I see the DBA Group in the middle of a number of groups such as Users, Developers, Admins (Windows, Network, Storage, etc.), etc.  I find that at times communication is not at the correct level based on the audience, which causes frustration among team members.  Being able to effectively communicate both in writing and verbally (one on one, in a small group and in a large group) is a critical quality that not every professional has mastered.

Next Steps
  • Now here is your opportunity to share what qualities you believe are key for a SQL Server DBA.  Do you agree with this list?  Are critical qualities missing from this list?  Share your thoughts with the community in the comments section below.

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

Comments For This Article

Friday, August 11, 2017 - 9:53:05 AM - Patel Bhavesh Back To Top (64591)

 Thank you very much for adding your valuable throughput. Really nice job.


Wednesday, January 14, 2015 - 7:34:01 PM - Jerry Cohen Back To Top (35946)

Regarding being firm...whenever it seems like there's a choice to be made, I try to outline all the pros and cons of each alternative, in order to make sure that management understands the repercussions of not doing it my way - and of doing it my way - in terms of performance, ease of maintenance, delays in transferring data, etc.  Also, they've been warned of any possible problems that could crop up and what it will take to resolve them.

The more specific you can be, the better, and make sure to tell them via email or some other documentable way, in case someone says, "you never told me that."

The more times you do this and the more times you turn out to be right, the more likely they'll be to listen to you next time.

Tuesday, December 17, 2013 - 11:28:31 AM - Jason Carter Back To Top (27818)

Mahmood Ali -  Productive Under Pressure comes with practice and experience.  Practicing your skills will always make your more trusting of those skills, being comfortable with your tools will make you more comfortable with the task at hand using those tools no matter the situation. 

Friday, September 13, 2013 - 3:35:18 AM - Mahmood Ali Back To Top (26778)

I am agreed with 'Productive Under Pressure' But the question is remain how to handle this situation please put some focus

Friday, July 19, 2013 - 7:27:12 PM - Jeremy Kadlec Back To Top (25920)


Thanks for the feedback.  It sounds like you are speaking from experience.

Thank you,
Jeremy Kadlec
Community Co-Leader

Friday, July 19, 2013 - 1:12:15 PM - Randy Martin Back To Top (25918)

A lot of great points, the one thing I would add is that 99.9% of the people in the world don't understand database engines. The DBA needs the skill of knowing how much to explain to management to get a favorable decision. And what to leave out....

Monday, January 28, 2013 - 9:19:15 AM - Jeremy Kadlec Back To Top (21750)

shafiq and Pratheesh,

Thank you both for your comments.

Thank you,
Jeremy Kadlec
Community Co-Leader

Monday, January 28, 2013 - 6:31:39 AM - Pratheesh Babu Back To Top (21746)

Very true, all these qualities are very much required not only as a DBA, but to be a successfull IT professional. One important quality you need as a DBA is never to panic. Always check wheter the basics are handled properly. Like you said, Just because we are SQL Server DBAs does not mean the best solution to every problem is in the form of a stored procedure, SSIS Package or configuration option

Sunday, January 27, 2013 - 12:44:48 AM - shafiq Back To Top (21730)



yes we solved the problem but we don't have properly documentation of the problem solution

this is the good point to documented the problem.

is there any tools to analysis and design the issue of SQL Server DB,

I have one issue is that my client using application(Visual Basic base develop apllication & SQL Server 2008) he searching in application for some information give error.

Error is Index search on table, table_name (specified in From clause) does not exist.

Please help me for this issue.

Thanks & Regards,


Saturday, January 26, 2013 - 9:31:20 AM - Jeremy Kadlec Back To Top (21726)


Great point!  I love documentation!

Thank you,
Jeremy Kadlec
Community Co-Leader

Saturday, January 26, 2013 - 2:55:12 AM - Som Pichai Back To Top (21722)

Many times after we (DBA's) resolve the issue, the resolution is not properly documented due to various reasons. The DBAs need to have a passion to write small wiki docs on resolution with the code snippets properly kept in the SQL Toolkit on a shared location.

This comes handy to resolve when a simialr / same issue comes after a few months. This also helps the other DBAs in that group.

Friday, January 25, 2013 - 7:58:06 PM - Edwin Back To Top (21720)


I'm very appreciated your prompt and advise.

In my two cents comment.  I believed that Communication is very important and it should be part of DBA skills.

Thank you.



Friday, January 25, 2013 - 5:31:29 PM - Jeremy Kadlec Back To Top (21716)


To me communication is a skill that can be taught and learned.  I think this is the case with many aspects of life.  I think if you have the desire to communicate effectively and work towards your goals, they are achievable.

Thank you,
Jeremy Kadlec
Community Co-Leader


Friday, January 25, 2013 - 2:56:39 PM - Edwin Back To Top (21714)


What about a person the mother language is not English.

Will he/she have the same equal opportunities in COMMUNICATION prepectives?


Thank you.

Friday, January 25, 2013 - 2:30:56 PM - Jeremy Kadlec Back To Top (21712)


Thank you for that!

Thank you,
Jeremy Kadlec
Community Co-Leader

Friday, January 25, 2013 - 1:40:30 PM - Grignar Grenac Back To Top (21709)

You forgot the "Big 3 qualities" paricular to DBA's: patience, patience and patience.

Friday, January 25, 2013 - 1:37:16 PM - Jeremy Kadlec Back To Top (21708)


Thank you for the two items.  Being able to find an answer quickly is important.

I also agree on getting the code right the first time and building a library of scripts.

Thank you,
Jeremy Kadlec
Community Co-Leader

Friday, January 25, 2013 - 1:35:06 PM - Jeremy Kadlec Back To Top (21707)


I am sorry to hear about your challenges.  Hopefully the situation will improve in the future.

Thank you,
Jeremy Kadlec
Community Co-Leader

Friday, January 25, 2013 - 12:10:57 PM - csears Back To Top (21706)

One of the additional qualities that I would expect to see is not that the DBA knows every little thing about SQL Server, but that the DBA knows where to go to look things up and that they understand what it is that they found on their search.

I'd also want to see someone who is a little anal about their work.  A DBA who takes a few seconds extra and looks up the syntax on what we might consider simple tasks, such as CREATE TABLE, is prefereable to one who shoots from the hip and probably gets it wrong on the first attempt.  In addition, someone who has built up a personal library of Very Useful SQL Code over the years is to be treasured.

Friday, January 25, 2013 - 10:29:39 AM - zzx375 Back To Top (21704)

Being "firm"?  And the manager says "Thanks for that firm input, I don't care, we're doing it my way".  This is followed by the left turn into the goat pasture and then you hear "You should have been firmer".  This is the same manager who says they don't make mistakes.  It's a challenge.



get free sql tips
agree to terms