I don't know if database admins have disappeared. But we have never needed one to take care of our DynamoDB tables and our "serverless" Aurora databases.
Even though I'm pretty sure AWS needs a lot of them; although not one (or more) for each and every single one of their customers.
Haha ^^
My SQL skills are indeed quite limited. But most of my stuff relies on DynamoDB, mostly in a strictly key-value fashion.
Still; queries are a lot less to learn and much easier to fix when I do them wrong then also queries + taking care of (maintaining, scaling, fixing, backing up,...) the database itself.
Have database admins disappeared? How about front end devs?