Databases. SQL isn’t going anywhere, and neither is Postgres. Plus the various NoSQL offerings. DBA has been reinvented as DBRE. It’s essentially still the same job, except you also have to know how to wrestle YAML, HA/DR, and create meaningful SLIs / SLOs. But if you like getting your hands dirty with the internals of DBs, hoo boy are there jobs. My last interview run, I had a 50% callback rate (n=10), plus some ext…
Most companies have managed dbs, and they don't hire a DBRE/DBOps person until it's too late. But I agree there are jobs and not many people with the skills.
My pet theory for the explosion of jobs in this space is that during ZIRP, tons of companies underwent huge growth (generally without a DB team, as you said), and managed by just upsizing instance classes. Eventually, you can’t solve your problem by throwing money at a vendor.