How to Level Up Your DBA Career (Dear SQL DBA)

on July 7, 2016

You’re a Junior or mid-level Database Administrator with no obvious career path. How do you grow the right skills to level up your DBA career?

Prefer a podcast instead? Find it at littlekendra.com/dear-sql-dba-podcast.

This week’s questions…

Today I’m answering two questions from listeners on one hot topic: advancing your DBA career when you don’t have a mentor at work, or a clear career progression.

Dear SQL DBA,

There’s so much to know within SQL and as a beginner DBA (1-2 years) that I’m not sure what’s a good starting point to becoming a great DBA. What would you say I should really take time to understand? What would take me to the next level.

and…

Dear SQL DBA,

I’m a junior DBA working in a very large company with very few DBA peers, and no one I can really look up to as a Senior. Luckily Production is pretty well-tuned so my workload isn’t overwhelming, and we have consultants who take care of a lot of monitoring and backup tasks.

Without a Senior DBA to mentor me and bounce ideas off of, I don’t have a good path to master my environment and move up (or on to another company). I regularly read community blogs and all the online video training I can get my hands on, but I’m still worried my skills fall short.

Do you have any suggestions for “leveling up” without a Senior DBA’s guidance?

This is a Choose Your Own Adventure moment: you’re at a fork in the road

There are two paths you can take at this point:

Path 1: Level up your career by building projects as work

  • Pros: This can be done entirely during working hours, and is a great resume builder
  • Cons:
    • Doesn’t build your leadership or communication skills
    • Doesn’t connect you in the community outside of your work. (And that’s the community where you’re probably going to get future jobs.)

This first path can get you a decent distance, but I’m not going to talk about it much today, because for many of you I think there is a more exciting and rewarding path to consider.

Path 2: Level up your career by building yourself as a speaker

  • Pros:
    • This builds your leadership skills, communication skills, and your technical abilities all at once
    • It also connects you with tons of other people in your field who may want to work with you in the future, at your company, or at a different company
  • Cons:
    • This requires a significant personal time commitment
    • Public speaking is scary for lots of people, and it takes a lot of courage to get over that

OK, What if I just absolutely can’t, I meant can’t, I mean noooo way will not EVER get up and speak in front of people?

It’s a choose your own adventure moment, right?

You can follow Path 1, where you build your career through doing projects at work! This can work well, particularly if you make a concerted effort to build your leadership and communication skills along with it.

I have a list of specific steps you can follow to identify the right projects to propose and work on in my post, “What’s the Difference Between a Junior and Senior DBA?

OK, for the rest of you guys, who are considering it…

Public speaking is the best path to leveling up your DBA career

I built my career slowly and steadily doing projects at work for years

It can be rewarding, as long as you don’t fall into the trap of overworking yourself to burnout

One problem I realized was that a lot of the knowledge I gained was domain specific

  • I did cool stuff, but you could only understand how cool I was if you understood the exact technical problems I was solving
  • Often those problems were confidential and couldn’t be explained in detail to people who didn’t work for the company

I realized that I needed to start working a healthy number of hours. The hours my employer wanted me to work.

And I needed to start doing public speaking

Public speaking gave me:

  1. New contacts in the speaker community. These are people who I could ask for feedback and bounce ideas off of. In the short term they helped me solve problems at my own job. In the long term they changed the whole trajectory of my career.
  2. A better ability to listen. This is a little counter-intuitive, because it’s speaking, but as a speaker you learn to listen to questions from your audience keenly, and think about those questions for long periods.
  3. Greater confidence
  4. Improved ability to “think on my feet”
  5. Better technical knowledge

The most important note about beginning to teach: pick the right topics

I totally screwed this one up! I made a super common mistake: I thought I needed to blog about a “special” or “advanced” topic. Something that wasn’t “covered already”.

Huge mistake. This leads to spending a lot of time getting to know a piece of nice technology that isn’t very relevant to you, or to many other people.

Pick a common topic that is very useful for Junior DBAs.

Something that you know at least a bit about already, and that’s relevant to your job.

You’re going to learn a TON about this topic. Deep details. Pick something that’s worth the investment of your time, and also worth the investment of time of lots of other Junior DBAs out there.

Topics in this area are things like:

  • Backups
  • Backups
  • Backups
  • (Did I say backups?)
  • Restoring backups!
  • SQL Server settings and configuration
  • Database settings and configuration
  • Any kind of maintenance
  • Any kind of common automation
  • And backups. Consider backups!

When you catch yourself thinking, “I can’t talk about that because ExpertSpeakerX already talks about it, and I won’t be as good,” then stop.

There’s room for you alongside ExpertSpeakerX!

In fact, the community is better with multiple speakers on core topics.

When you’re researching and testing, include materials from a wide variety of sources, and pull from your own experience. What confused you about the topic the most at first, or what were/are you surprised by? What’s your favorite way to solve a problem with that topic, and why?

You will naturally have your own voice and your own perspective.

Look at this from another perspective - your next job interview

Imagine you’re interviewing for a Senior DBA position, either at your company or another company

The interviewer asks you some technical questions about backups

You’re qualified to answer those questions, right?

Picture yourself being confronted with the questions now. (It’s normal to get a little sweaty.)

Now picture yourself being confronted with the questions after you’ve  presented on backups a few times, and fielded questions from the audience.

So. Much. Easier.

The same thing goes for pitching a new project to your boss' boss, having to fix failed backups at 3 am, and explaining what happened in an incident to a senior executive. Teaching others in the SQL Server community makes you better in all these sweaty situations.

Begin by speaking at a SQL Server User Group or SQL Saturday event

Some people say that you should always start at a local user group

They tend to be small, and low pressure. A terrific choice for beginning! Find a list here: http://www.sqlpass.org/PASSChapters/LocalChapters.aspx

But maybe you’re not near one. Or maybe you’re like me: the closest user group when I started speaking was held at Microsoft in the building where developers coded SQL Server. Regular speakers at the group are Microsoft Program Managers, developers, and the people who literally “write the book” on SQL Server.

There was NO WAY I was going to test out public speaking at my local user group

So I submitted to a small SQL Saturday in Iowa. SQL Saturdays are awesome, and I got lucky– one accepted me!

I’d never been to Iowa. I didn’t know anyone in Iowa. But I got a cheap plane ticket to Iowa.

I figured if it was awful, well, all those kind strangers would just forget my name.

It wasn’t awful. I wasn’t a natural, and I was presenting on the wrong topics, but it didn’t kill me. It was a little exhilarating.

And I kinda wanted to do it again.

See a list of SQL Saturdays here: http://sqlsaturday.com/

If you’d rather start in front of a webcam, PASS has virtual chapters, too: http://www.sqlpass.org/PASSChapters/VirtualChapters.aspx  (Seriously, really, DO USE A WEBCAM!)

Bring what you learn from speaking back to your workplace

Although speaking isn’t part of your job, it will benefit your job

Part of why I’m pushing backups so much as a topic is that speaking always teaches you a lot about your topic

You learn writing the demo scripts, doublechecking things on your slides, and answering audience questions (either live or later on – it’s always OK to say you don’t know and would like to check)

You’ll learn things that allow you to see improvements you can make at work

And once you start speaking, you’ll also learn things from your peers at the events you speak at, too

Regularly talk with your boss about what you learn from speaking, and from others at events

It’s good for your company for you to be a public speaker, and the more they know about it, the more they’ll support you and understand why you want to go to conferences

Becoming a speaker helps you, and it helps the SQL Server community

You’re at a fork in the road. You’re ready to level up your career. Starting to teach others is the best thing you can do – join the team of presenters and teachers! We’d love to have you.