Mainstream database administrators fall into one of two categories: production and development.
Think of SQL Server as a refrigerator. It stores stuff. You put stuff in there, and you expect it to stay cold.
Production DBA Career Path
Production DBAs are like fridge technicians: they don’t necessarily know how to cook, but they know how to fix the fridge when it breaks. They know all the tricks to keep the fridge at exactly the right temperature and humidity levels.
Production DBAs take over after applications have been created, keeping the server running smoothly, backing it up, and planning for future capacity needs. Network administrators that want to become DBAs get their start by becoming the de facto DBA for backups, restores, and managing the server as an appliance.
Development DBA Career Path
Development DBAs are more like cooks: they don’t necessarily know anything about Freon, but they know how to whip up a mean dish, and they know what needs to go into the fridge. They decide what food to bring home and put in the chill chest, what should go into the fridge and what should go into the freezer.
Development DBAs focus on the creation process, working with programmers and architects to build solutions. Programmers that want to become DBAs usually get a head start on the development role because of their programming experience. They end up doing the development DBA position by default when their team needs database work done.
Other Thoughts about DBA Roles
Database admins can cross those borders and know pieces of both sides, but generally, they fall into one of the two camps. Interestingly, the camp they pick tends to be driven by their past.
Can programmers become production DBAs, and can network admins become development DBAs? Sure, but it’s just not nearly as easy. Network administrators don’t usually know a programming language, or even how programming works, so they have a lot of learning to do before they can contribute to specialized topics like table design, normalization, stored procedure design, and so on. Programmers don’t usually know the finer points between raid 5 and raid 10, so they have some hurdles before they can design a database server that can scale effectively at the right price point.
These challenges mean that it’s hard to design a generic DBA training course. I’ve watched network admins struggle with database theory books, complaining that it’s hard to learn database administration. Database theory is not necessarily a prerequisite for beginning database administration. A good DBA knows database theory, but that’s not always the first thing a good DBA learns while going down the career path.
My advice for prospective DBAs: don’t look for checklists that describe any hard and fast steps toward becoming a database administrator. Instead, learn about the parts of database administration that call to you, things that you genuinely enjoy. If you like performance tuning, then read up about the Profiler and how indexes work. If you like designing tables, then read up about the different data warehouse application theories. There are so many specializations in database administration, and the only way to truly succeed is to be passionate about what you’re doing. It’s easy to be passionate about extending the knowledge you already have, and that’s why it’s easier for network admins to become production DBAs, and for programmers to become development DBAs.
More DBA Career Articles
- Moving from Help Desk to DBA – a reader asked how to do it, and I gave a few ways to get started.
- Development DBA or Production DBA? – job duties are different for these two DBA roles. Developers become one kind of DBA, and network administrators or sysadmins become a different kind. I explain why.
- Recommended Books for DBAs – the books that should be on your shopping list.
- Ask for a List of Servers – DBA candidates need to ask as many questions as they answer during the interview.
- Are you a Junior or Senior DBA? – Sometimes it’s hard to tell, but I explain how to gauge DBA experience by the size of databases you’ve worked with.
- So You Wanna Be a Rock & Roll Star – Part 1 and Part 2 – wanna know what it takes to have “SQL Server Expert” on your business card? I explain.
- Becoming a DBA – my list of articles about database administration as a career.
Great article Brent. I found it through another blog. I think you’re exactly right about why people with different backgrounds become different kinds of DBA.
Thanks for all these good “hints”, Brent, you have scattered throughout your site. I’m interviewing tomorrow (2nd interview) with the Director of a major New York state regulatory agency for a DBA position (production type) — and your site is re-assuring since I have been a developer over the years and not a formal DBA-type person.
Although I have a minimal knowledge of many aspects of being a DBA, I’ve never trained or actually/rigorously implemented any DBA policies. Your wealth of advice on what to expect, best practices and related links is much appreciated.
I’ve got ya’ bookmarked!
Thanks/spirits,
seth
Thanks for the information, it’s great. Just wanted to know – what should be career path of DBA (like DB Architect……). Please let me know.
Partha – DBA usually refers to DataBase Administrator, not architect. Knowing that will help you find better information about how to become an architect, because like you’ve figured out, these two career paths are usually different.
Architects tend to have more college education – they’re expected to know much more about systems theories than DBAs. Architects usually have at least a bachelor’s in computer science, if not a masters. They have to know project management skills, team lead skills, and programming. In order to get those skills, there’s a lot of different routes they could take, but the ones I’ve seen have usually come up through the ranks of programmer teams.