Ten Essential Traits for DBA Success


Hard-Work_thumb.jpgThere is greatness within you whether you believe it or not. Over the years there are certain skills that have helped me along the way that, in turn, may help you along your journey. These traits are by no means written in stone and some will not agree that these are important and that’s okay; what I can say is that these traits are at the backbone of some exceptional DBAs I’ve met along the way.

 

 

Technical Traits

Backups – Think about this a moment if you will. A backup is pretty much the most fundamental aspect of database administration one could do. Let’s put this into more general terms; I view database administration as a service ( I thank Grant Fritchey (B|T) for that – Database Administration as a Service). Now, with that said whether you are new to database administration or not it is imperative to find out what the backup strategy requirements are for your business units and get your backups aligned accordingly. Let’s take this a step further and ask this question;  if you are taking good backups then are you restoring/testing these backups?

Automation Yes folks; I am a key advocate for automating as much as you can. This relates back to making database administration tasks run as efficient as possible. By doing this it will free you up to do even more types of database administration tasks. Some things to consider automating are:

  • Code Deployments
  • SSIS Deployments
  • Job tasks
  • Alerts
  • Health Checks
  • Patches
  • Server Level Changes
  • SQL Installations
  • Unit Tests

Sysadmin Rights – I think this one speaks for itself. If you don’t know who has sysadmin rights on your servers than you are doing it wrong. Find out who has this type control on your SQL Server if you haven’t already done so.

Disaster Recovery – Organizations and businesses that do not have a plan in place could fall into a few categories. The categories that I’ve seen which seem to be more prevalent, outside budget concerns, are realizing the importance but not knowing how to get there, and not knowing that a disaster recovery plan can even exist. Whatever the case may be laying out a good plan in case of disaster should be a must for any data professional.

Monitoring – This is an integral part to any DBA related job. You have to be monitoring your daily processes, policies, and procedures. Whether you are utilizing home grown coding or monitoring utilities by third party affiliates it is an absolute must that the data professional is aware of processes that may go awry before they happen; or for that matter knowing that things are going smoothly as well.

Non Technical Traits (a.k.a. Soft Skills)

Communication – One of the keys to becoming a great communicator is not becoming a great talker – big difference. These are some of the ways that can help become a better communicator where you are:

  • Earning Trust – you earn it with right acting, thinking, and ability to make decisions.
  • Become personal – I was taught early on that most of the time people really don’t care about how much you know until they discover how much you truly care.
  • Be Specific – one of the lessons learned over time is the need to be specific when communicating with a team, business unit, and executives.
  • Keep an Open Mind – want to limit a group trying to become innovative? if so then keep a closed mind. Use this as a utility to learn and grow; it’s okay if someone’s opinion is different than yours.
  • Shut-up and listen – sounds harsh I know but not really sure how else to get that point across. Becoming a great communicator you have to know when to dial it up, dial it down, and yes even dial it off. Knowledge is not always obtained by flapping your gums but rather listening and understanding situations.
  • Check Ego at the Door – over the years I’ve seen it time and time again. When you can put arrogance aside and check it at the door some great things begin to happen in shops, teams, corporations.
  • Read Between the Lines – I’m continually amazed at some of the mentors I’ve looked up to in the DBA realm and their conscious ability to read between the lines. Keep your eyes and ears open.

Listening – Just like communicating and talking I think there is as vast difference between listening and hearing. Next time you are in a conversation don’t just hear the other party but listen to them, and by listening don’t just judge but rather show you understand what is being discussed.

Work Ethic – two words have never been so important in my own life and journey. If you know me at all you know that having a strong work ethic is near and dear to me. A strong work ethic will result in respectfulness, dependability, dedication, accountability, determination, and humility. No one can do it for you; it has to be from within.

Character – can be defined as what determines how we respond to the situations and circumstances of life. One of the first jobs I had after my ball playing days was a position at a local sports store. A regional manager had made his way in and as he walked back into the back room (which I admit was not always the cleanest place due to inventory etc.) there were several pieces of paper laying in various places on the floor. Now, he didn’t know anyone was behind him but he stopped at each piece, picked it up, and threw it away. You may ask what does that have to do with character? It left an impression on me that how you work when someone is not watching you does in fact make a difference.

Do Not Compare Yourself – It is easy to get caught up in trying emulate oneself as others. Just ask Michael Jordan how many people tried to emulate him or some other renowned celebrity. I’m here today to tell you that while you can take traits from some of the best in the business; you will not be them and that’s okay. Your journey is just that; your journey – no one else’s. Own it and make it yours and along the way keep learning.

Conclusion

Focus on your greatest sphere of influence; it’s time to tear down the walls between teams, business units, and organizations. These 10 traits mentioned don’t even come close to representing any complete package of skill sets, but what it is intended for is to provoke some thought around even the basic essentials of what makes up a successful data professional.

Are SQL Saturday’s Worth It?

VenueThis past weekend I was fortunate enough to be a part of Louisville’s (for those local the ‘ville) SQL Saturday event held at Indiana Wesleyan. Most of you who end up on this site are probably familiar with it, but for those that aren’t familiar with SQL Saturday events you can check out their site here.

Now to put on an event like this is nothing short of an incredible effort from volunteers, sponsors, speakers, and attendees. Being able to help co-organize the one here in Louisville has been a humbling yet gratifying experience. Let me see if I can break it down a different way for you, the reader, who may not have had the opportunity yet to volunteer or attend such an event.

Volunteers

You can see these people usually with matching shirts on and a lanyard with their name and a ribbon that only says “volunteer.” In the past when I’ve attended such events I knew people helped out to put something like this on, but never in my wildest dreams did I envision all that it took until I volunteered.

Volunteering is not for glitz, glamor, or glory. Instead volunteering is what helps the cogs in the wheel move to get the steam engine running down the track. It is the staple of helping afford the opportunity for free learning to attendees and colleagues in our field.

Many, many, and many hours go into planning and organizing an event; if you attend one of these events make sure you seek a volunteer or organizer out and say thank you for their time; they are doing this for free and on their own time away from their families.

Mala Mahadevan (B|T) as a founding organizer of our event I thank you for allowing me to be a part of it these past few years.

Sponsors

Over the years, SQL Saturday Louisville has been blessed with some great sponsors. For the previous two years, John Morehouse (B|T) and I have taken great pride in working with some stellar companies. Without them, we would not be able to do what we do which is concentrate on the attendees and helping people learn.

Our Gold sponsors this year were:

Gold

  1. EMC
  2. Farm Credit Mid-America
  3. Imperva
  4. Microsoft
  5. Republic Bank
  6. Pyramid Analytics

 

Our Silver and Bronze sponsors this year were:

SilverBronze

  1. Idera
  2. PASS
  3. PureStorage
  4. Tek Systems
  5. Click-IT Staffing
  6. Homecare Homebase
  7. Datavail
  8. SQLSentry

A major thank you for all of their contributions and it is always a pleasure to work with all of you.

Speakers

It always amazes me at the number of speakers we have who send in sessions to our event. These speakers are people from all over the U.S. who are willing to travel and give their time so attendees can learn. Getting to spend time with each of them is not always an easy task, but always thankful to catch up with many friends at the speaker dinner.

It was awesome to see the attendees interacting with the speakers asking their questions and getting insight into the variously presented topics. And, because of so many good sessions to choose from, there was a buzz in the air.

As is the case with the volunteers mentioned above, speakers also travel on their own dime, away from their families – a simple thank you goes a long way. Also, for these sessions, I do want to point out that feedback cards are provided; please please please take a moment and make sure you provide good insightful feedback to the speakers. Each speaker uses this feedback to improve their sessions or have take-a-ways on what may or may not have worked. Yes, folks, these are important!

I won’t list every speaker we had; that is not the intent of this topic. But I will take a moment and say to each and every speaker who attended SQL Saturday Louisville 531 we thank you.

Attendees

Two words – – THE PEOPLE. As I have stated, these last two years has been nothing short of amazing. Seeing light bulbs go off with attendees who are learning from some of the best, and having discussions with attendees is why we do what we do.

When individuals come to us stating it was their first time at the event, and they had no idea that there is a local Louisville SQL User Group opens the doors to help reach people in our tech community.

Steve Jones (B|T), who is part of my Fab Five, talks about Dreaming of SQL Saturday. If you have not had a chance to read his post, check it out. Attendees travel from quite a distance. Which tells me the people are eager to learn.

Conclusion

So, the question I opened with “Is SQL Saturday Worth It?” Considering what I know now versus what I knew then the answer is yes. Personally, being a product of these types of events, I am living proof of what can grow from the SQL Community.

Whether you volunteer, speak, sponsor, or attend, all of these make the wheel turn. It’s a team effort with a lot of hard work. So, next time you attend one of these events, please don’t take them for granted.

Here is to continued learning, as we move forward to grow this community!