Recently I was posed this question here on my blog:
“To become a DBA administrator do I need to start first as SQL Developer?” (original question)
I find this question to be really interesting. It’s a very common question that I receive, not just written but in person as well. I have been asked this question often enough that I wrote a book on the subject of how to get your next DBA job (pending edit to be published, but the first chapter can be found here). I am not sure if I have ever answered the question directly, but I have also done a number of articles on the subject published on SWWUG.ORG.
Do you need to start your DBA career as a developer? I don’t believe so. I don’t think it hurts at all, but I don’t think it’s a requirement. I believe as a DBA that you should understand how to develop sql and to take it one step further I think you need to know how to design a database. But, I think understanding it and being able to claim that you were a developer or an architect on your resume is by no means a requirement. When I reflect back on my experience and I refer to this in very general terms, as developers and administrators often have very different mind sets. At the same time please keep in mind that I have never developed an application, and my development experience with code that exists in a production role is limited.
If we dive a little bit deeper into the question and explore it a bit more we can expand it into: Do I think that those skills will make you a better administrator? The answer to that is a definite “yes”. There are many skills that I think will improve an individual’s success as a Database Administrator. A good example is if you look at a recent session that I have given on utility databases, all the information that I collect was done using t-sql development skills. In addition to those skills the basic understanding of Windows server operations is a big benefit. These traits can be seen in many areas such as how active directory works, or how security works.
I believe administrators need to have many skills; each of these can be drawn from to improve the many tasks that you may be asked to do as a DBA. I think a successful person needs to draw from all their experiences. Not just the skills related to computers, either. I think skills such as the ability to prioritize your work, or the skills that one gets from industry specific knowledge, need to be utilized. The person that posted the question went on to mention the past development skills that they have. Each of those skills is going to help him or her on their career path. There are a number of positive things that I see in the asking of this question that leads me to believe this individual will have success on the career path of their choice.