top of page
Learn T-SQL

Long Live The DBA

Updated: Jan 4

I think the DBA role will be more critical in the coming years. I have bet my business and career on this belief. While, databases are becoming more reliable and require less technical maintenance they are becoming more complex and offer more capabilities. When SQL Report Services was first released, few products used it, now, companies are dumping Crystal Reports and using SSRS. The Forester Wave, showed in 2015 MSFT owned about 50% of the BI/reporting market. Most of this was taken from SAP Crystal Reports and yep that, now somehow falls to the DBA. Most recently MSFT has integrated R into SQL Server, I think this will be a similar pattern IBM SPSS dominates now but MSFT will gain traction in this area and again this domain will fall to the modern DBA to know and understand.

You could reasonably but incorrectly argue that it was always the responsibility of the DBA to know these technologies, but from my long-lived career and my many opportunities to review job postings (see my job layoffs on my website), I started noticing DBA job listings with reporting / SSRS in about 2005. Most recently I have seen many employers forgo even listing the technologies are needed and instead, use the cryptic shorthand of SSAS / SSIS / SSRS and Tabular and data visualization. The role of the DBA has increased not decreased in terms of the technology required to perform the function successfully.

Attaining a competitive advantage with complex reporting, statistical and relational technology will never fall to your ordinary business analyst or mediocre bureaucrat. The DBA role has always had these types of responsibilities. In the early days, it was keeping the database and LOBA (line of business application) running. This involved antiquated system pages and someone who was dedicated to answering. Today the need for a pure technical person to keep the system running is less intense, but other business concentrations are needed. I talk about this in my post A Growing Share Of a Shrinking Market. I do assert that decreased need for pure tech, to keep the system running is offset by the organizational risk of advocating for the right set of technologies and the increased need for business skills.

In the early 90’s you could make a career out of knowing perfmon and knowing about system ram and CPU. Today you need to know all of that and how to move it to VMware or the cloud along with SSAS/ SSRS /SSIS. Today you need to know to query the data and then how and why you should surface the data. The simple ability to paint a report is not good enough DBA’s also need to know why the numbers are important to the business. If we also also stipulate there are other platforms vying a seat at the DBA/BI/Reporting/relational table. The number of ways an executive can make a mistake quickly multiples. In short, the DBA with business skills will be golden for quite some time.

Final Thoughts

Overall the DBA position has grown and changed.

DBA’s should acquire a balance between tech, business, and analysis.

I believe the DBA will continue to drive business savings and strategic advantage for many years.

Mike Bennyhoff

2 views0 comments

Recent Posts

See All

Are you looking for ways to improve the performance of your database tables? If so, then table optimization in SQL Server is an important skill to master. Table optimization refers to the process of a

Blog Introduction: SQL Server is a powerful database system that provides an array of features and capabilities. One of these features is the system databases, which are essential for managing and mai

SQL Server Mistakes to Avoid Blog Introduction: As a database administrator (DBA), there are certain mistakes that you should be aware of and avoid when it comes to managing your SQL Server. Over the

bottom of page