29 Nov The Future of the DBA
I’ve written before about how databases are like a car engine, and DBAs are like a car mechanic. That’s been the traditional view for production DBAs for, well, forever I think. And that analogy may have been true at one time, and may still be true for some DBAs.
But the industry is changing. First we had virtualization, forcing DBAs to learn more about the world that exists outside of the database engine. Then we had cloud services forcing us to learn even more about the universe of data that is available to everyone, everywhere, at any time. Breadth is the new depth.
And with those changes, I no longer see DBAs as a car mechanic.
DBAs don’t get to touch 3rd party apps, for example. A majority of the data managed today by DBAs are 3rd party apps, often offered as a service.
DBAs sit and watch as the data hoarders continue to amass data leading to ROT. This ROT then forces database vendors to find new and interesting ways to make data go faster when the simple answer might be to get rid of the data you don’t need anymore.
No, these days a DBA is no longer a car mechanic. Oh, we still have a cool collection of tools, and we know all about how the engines work, too. But we aren’t allowed to touch anything. We get brought in to discussions as a subject matter expert from time to time, but we aren’t doing the lifting. We used to do backups and preventative maintenance, remember those days? Well, with SQL Server Managed Backup and Azure Query Performance Insight we aren’t needed for those things anymore.
All of the tasks that a traditional production DBA has been doing for decades are being automated away, right in front of our eyes.
So, no, we aren’t car mechanics. Not anymore.
These days a DBA is similar to an auto emissions testing machine. We are asked to help locate a problem and then we notify someone else to take action to fix the problem.
And it won’t be long before that role is automated away as well.
It won’t be long before the price of a DBA will be a standard rolled into the cost for PaaS from the cloud providers. There won’t be a need for paying to have a DBA on staff anymore. After all, we don’t pay to have our mechanic live in our home, right? No, we take our car to the garage when needed. That’s the model for databases in the future, too.
It’s because access trumps ownership. Companies don’t care if they own databases as much as if they can access data. They don’t need to own a DBA, either. They just need to access to a DBA from time to time.
The future of the DBA is in knowing how to build solutions, not tables and indexes. The future is in understanding how data is being used, not in how it is stored. The future is in being able to help analyze data, not in how it is administered.
The future is in our hands, too. We get to decide what we want to learn today that will help us have a job tomorrow. Data science is one choice, but not the only choice. Another choice would be cloud architect, helping people build solutions by utilizing one or more cloud services.
Heck, maybe DBA will still be a choice in the future, but I can guarantee you that our days of rebuilding indexes are ending one page at a time.