Iâ€™ve done a ton of interviewing in my career, both as the interviewee, and as the interviewer. Â The biggest problem I see is the huge number of DBAs who have let themselves fall behind. How does this happen?
Middle of the pack
Once you’re a more or less established DBA, you have yourself a job, and you go in every day and you do your duty.Â You back up what you need, do the restores you need, fix replication, look at a couple bad queries, and set up a new server for the latest project.Â Youâ€™re busy as hell at work, and thereâ€™s no end in sight to all the tasks and projects and problems.
Thatâ€™s the problem with being a DBA these days: you’re always swamped with problems. (The real reason is that companies are absolutely dedicated to not taking data seriously, but that’s another article entirely.)
So you work, and you get further and further behind the learning curve because there’s no time to do anything for yourself: no time to learn anything new, pick up a book, watch a tutorial, or even practice what you already know. Â Youâ€™re always putting out fires!
Then, when it’s time to interview for a new job, you find yourself cramming in the last couple days to try to bone up on your knowledge. Â Speaking as someone whoâ€™s interviewed a lot of DBAs: this definitely shows! Anyone who conducts any amount of interviews at all can tell when youâ€™re just barely recounting something and when you know the topic cold.
Live in interview mode
Okay, I have a radical, two-step plan for your professional development. Here we go:
- Stop cramming for interviews like youâ€™re trying to pass a test.
- Live in interview mode.
Interview mode (n.) – The practice of conducting your daily work life as if an interview could happen unexpectedly, at any time.
Take time to study every day.Â It doesnâ€™t matter how much, but I think 30 minutes isnâ€™t too much to ask.Â Even if youâ€™re not studying to interview, your skills will get rusty when you donâ€™t put them into practice for a while. Chances are, your company wonâ€™t ever give you the time to do it, so you have to take that time yourself.
Pay yourself first
Every day when you come in to work, take 30 minutes to work on something for you.Â Learn how to do partial restores.Â Learn how to set up an Availability Group.Â Learn how to add a primary key to a table using T-SQL.Â Learn XML, or JSON, or HTML.Â It doesnâ€™t matter.Â Pick something up that you want, or something that you know you lack.
I call this paying yourself first, which is actually a financial term:
Pay yourself firstÂ is a phrase referring to the idea that investors should routinely and automatically put money into savings before spending on anything else. – InvestingAnswers.com
When it comes to your career, make sure you routinely and automatically put time into your development before spending it on anything else.
When someone comes to your desk and asks you to do something, tell them that youâ€™re doing your daily checklist, and youâ€™ll be with them in a few minutes. Â (People at work donâ€™t understand that daily checklists are
dumbÂ out of style, so theyâ€™ll leave you alone.) Â Your company wonâ€™t give you the time to do this, so you have to take the time.
Study first thing in the morning, before things get started. Once the day really gets going, itâ€™s hard to even remember studying, much less to find the time.
You may not be able to do it every day.Â There may be some days when you walk in and thereâ€™s some emergency that honestly takes priority.Â Thatâ€™s okay, take care of your emergency.Â But outside of that, thereâ€™s very little that canâ€™t wait 30 minutes, especially when youâ€™re “doing you’re checklist to make sure things are okay”.
So take some time to be good to yourself before things get crazy every day.Â Improve yourself, live in interview mode, and pay yourself first.