Want to become a Database Administrator, but don’t know how to get started? Were you recently selected to be the DBA at your company because you admitted to doing a restore of a database a while back? I put this page together in an effort to help others learn more about being a DBA. People ask me all the time about how to interview for a DBA job or how to become better at being a DBA, so I decided it was time to put all of my reference material into one place.
Blogs for DBAs
I maintain a list of prominent SQL bloggers. These are the people you should start following if you want to gain some additional insight into database administration. The blogs I track are a mixture; some are more technical than others that might be more professional development oriented. If nothing else, they serve as a good base.
In addition to those bloggers, I offer some links to other articles written by myself and others:
How Did I Get Started?, where I offer some details on my background as a DBA.
How To Get Hired, where I detail the different development levels.
How To Get Hired, Part Deux, where I follow-up by describing the different managing styles.
Junior DBA Interview Questions, where I discuss examples of the style and type of questions I would ask junior DBAs.
Junior DBA Interview Questions – Updated, where I add in some questions that help show the breadth of experience for a potential junior DBA.
Interviewing Tips, where I recount how an interview is a lot like dating.
The Break Up, where I explain what it is like to resign from your current employer.
SQL Server Training Resources, where I list some free training resources.
Ten Things I Hate About Interviewing You, where I list ten things you don’t want to do when interviewing for a job.
Ten Things I Hate About Interviewing With You, where I list the ten things I don’t like seeing from employers.
Job Websites for DBAs
There aren’t any. Seriously. If you are scouring websites looking for a job as a DBA, and you have never previously been a DBA, then you are doing it wrong. I have networked with thousands of database professionals, and whenever I ask them how they got their job as a DBA the answer is never “I applied for an ad I found online.” Most of the DBA jobs go to people that are already known to the potential employer, with the exception being they go to people that are found by trusted recruiters.
And there is the key word: trust. Companies need to know that their DBA is someone they can trust. The reason you can find so many ‘accidental’ DBAs is because they are already known and trusted in their company and their company decided to take a chance. It is rare that a company would ever just hire someone with little or no experience to be a DBA, and even more rare that they would hire someone completely unknown.
Still, if you want to do things the hard way, then check out this post I did on job search techniques
Do not underestimate the power of networking, it will help you find a job faster than CareerBuilder or any recruiter.
Books for DBAs
I have a library set up on this blog already, but can highlight a few books here as well. If you want to immerse yourself in reading materials, then the books listed below are a great way to start your own library. Starting with my own book, of course, where you can learn more about what life is like as a DBA.
SQL Server Technical Books for DBAs
Here are the books I recommend in terms of building a base technical knowledge on all things related to MS SQL Server.
Database Design and Modeling
Here are the books I would recommend with regards to database design and modeling, what I consider to be a lost art these days due to advances in hardware. Powerful CPU, lots of memory, and fast disks are able to overcome and hide bad database designs. Typically bad designs are only exposed after being deployed to production. I hope these books can help someone to avoid such a situation.