The total number of databases in the world has not gone down though, rather the opposite I suspect. It's not that there aren't any competent DBAs anymore, rather it's just that the cloud companies have better offers for the DBAs out there than most small/medium enterprises are willing to pay.
Similarly, managing servers through Chef/Puppet used to be a thing just a decade ago. Now with the onset of serverless, Lambda etc., it's slowly fading away.