In 2022, I had the pleasure of hosting a series of webinars on the subject of how different IT technologist persona’s can best utilise tooling to monitor business critical database applications. I was joined by the inimitable Kevin Kline and der legendäre Sascha Giese, where we discussed the significant differences that exist between the following IT persona’s when working with database administration:
- Accidental/Enforced/Occasional DBA
- Junior DBA
- Full on ‘know their stuff’ DBA
Whilst languishing with a cold, I thought about this series again and decided to create this blog to give a written overview of the key topics, discussions and our thoughts on this subject.
Let’s kick off with the person who is going to have the least knowledge on databases, but through circumstance, eagerness or lack of ability to hide effectively have been given the task of managing a key business IT resource. You can see from the previous sentence, why they are often referred to as the accidental or enforced and occasional DBA and the unique challenges they face, along with insights into how the right tools can bridge the knowledge gap.
Who are the Accidental DBA’s?
Accidental DBAs are IT professionals who find themselves managing databases not by choice but by necessity. This can happen when an organisation lacks a dedicated database administrator, and the responsibility falls to an IT generalist or developer. Often tasked with keeping databases operational, troubleshooting issues, and ensuring performance without any formal training in database administration. These people are often literally thrown in at the deep end and have to learn to swim or in reality learn to keep the database servers afloat.
Key Challenges for Accidental DBAs
- Knowledge Gaps: Accidental DBAs often lack familiarity with database-specific concepts like transaction logs, backups, the SQL language and performance tuning. This can lead to confusion when troubleshooting issues.
- Time Constraints: With other responsibilities to manage, accidental DBAs often operate in a firefighting mode, addressing immediate issues rather than taking the more pro-active approach, which we all appreciate leads to greater platform stability, security and optimised performance.
- Complex Environments: Many organizations use multiple database platforms—SQL Server, PostgreSQL, Oracle, MySQL—adding complexity for someone without specialised expertise. We discussed how even seasoned DBA’s can struggle with managing multiple database technologies.
The Role of the Right Tools
We went through the differences in the SolarWinds portfolio of database management tools and how the appropriate tool can simplify the management process and offer much-needed guidance. For example:
- SolarWinds Server and Application Monitor (SAM): Provides high-level metrics and key performance indicators, helping users identify whether issues stem from the database, server, or application layer.
- Database Performance Analyzer (DPA): Offers deeper insights into query performance, wait times, and database behaviour. Leveraging AI it analyses the databases, providing actionable recommendations to resolve performance bottlenecks, enabling accidental DBAs to learn while resolving issues.
Recommendations for Accidental DBAs
- Simplify The Visibility For The Role: if the tool goes too deep, such a user is only confronted with more complexity and learning requirements. Keep the solution simple and provide a consistent and unified dashboard UI that consolidate metrics from multiple database platforms streamline troubleshooting and management.
- Leverage Guided Insights: Tools like DPA provide direct recommendations, bridging that knowledge gap and therefore acting like the database mentor, to take the capabilities of the person to greater heights, allowing them to properly ‘swim’, rather than merely stay afloat.
- Focus on Proactive Monitoring: Use features like anomaly detection and dynamic baselines to identify potential issues before they escalate.
The accidental DBA fills a critical role in organisations, often becoming the unsung hero who ensures databases function effectively. With the right tools, accidental DBAs can overcome their challenges, transitioning from reactive problem solvers to proactive managers. Tools like SAM and DPA not only simplify database management but also provide the educational value needed to build expertise over time.
[embed:21a47d5d-b4f2-4ba8-83b4-14d0c9184868:42b8e0be-eb1d-471e-a374-4ecd6ac3a35d:embedCode=%3Ciframe%20width%3D%22560%22%20height%3D%22315%22%20src%3D%22https%3A%2F%2Fwww.youtube.com%2Fembed%2FbUe_osnSkz0%3Fsi%3DvyevTptI29H_V3GB%22%20title%3D%22YouTube%20video%20player%22%20frameborder%3D%220%22%20allow%3D%22accelerometer%3B%20autoplay%3B%20clipboard-write%3B%20encrypted-media%3B%20gyroscope%3B%20picture-in-picture%3B%20web-share%22%20referrerpolicy%3D%22strict-origin-when-cross-origin%22%20allowfullscreen%3E%3C%2Fiframe%3E&sanitizedEmbedCode=%3Ciframe%20src%3D%22https%3A%2F%2Fwww.youtube.com%2Fembed%2FbUe_osnSkz0%3Fsi%3DvyevTptI29H_V3GB%22%20width%3D%22560%22%20height%3D%22315%22%20title%3D%22YouTube%20video%20player%22%20frameborder%3D%220%22%20allow%3D%22accelerometer%3B%20autoplay%3B%20clipboard-write%3B%20encrypted-media%3B%20gyroscope%3B%20picture-in-picture%22%20allowfullscreen%3E%3C%2Fiframe%3E&autoResize=True]
Check out the rest of this series: The Role of Junior DBAs and The Roll of Full DBAs.
