In my opinion the big difference between a Database Administrator (DBA) and a Senior Database Administrator (Sr. DBA), comes down to experience, sounds simple enough right? If we explore that a little deeper, wouldn’t it be easy enough to base the differences on knowledge? A Sr. DBA would have a wider knowledge base to draw from as they face every day challenges, otherwise said as someone who has an extensive amount of time spent studying and learning quite a bit about SQL Server combined with opportunities to work with the product. Knowledge comes from many sources, in my experience I gain the most knowledge from making mistakes. As an example, I learned quite a bit about relationships when I purchased race day tickets for my wife’s birthday I had even purchased tickets to sit and eat lunch with my favorite driver. This was lesson was reinforced when the year after I bought her the vacuum cleaner she had mentioned she wanted.
All men make mistakes, but only wise men learn from their mistakes. – Winston Churchill
When I reflect to my first full time IT position, I often think about the lesson I learned about troubleshooting issues. I had just completed a week long class on how to install the Windows OS (NT 4.0) and how to create a new domain where I could then add the entire collection of PC’s. The class was great and I was confidant in my skills, because I had eventually completed all the lab work in the class. My confidence quickly faded over the next week (including the weekend) with each reinstall of the Domain Controller simply because each attempt resulted with errors stating the workstations could not find the domain. The biggest blow to my self-confidence came when I realized all my issues were resolved when I determined I should start with the basics and power on the network switch.
At first I consider the mistake a lesson in how that network switch worked, but today I realize the true lesson learned was all about troubleshooting and more importantly the importance of learning from the mistakes I have made. Everyone has different learning experiences, I often wonder about the mistakes other database professionals have made and what they have learned from them. There are many people I respect in the SQL Server Community, and I can see a true value in learning from them. If they have the time available, I would love to hear about the lessons they have learned:
If you have had an experience that you are willing to share I would love to read about it, and share it with others. Please post on it and let me know so I can share it with my network.