Technologies such as Hibernate, nHibernate, Linq, etc, etc have actually made good RDBMS DBAs and Developers much more in demand to fix all the performance problems those technologies leave in their wake.

The cloud isn't really changing the need... it's just changing the topography a bit. You still need people who actually know what they're doing with a database if you intend to do any batch processing or heavy duty lookups.

Shifting gears... the idea of handling data hasn't changed since the stone age. Even the methods have stayed pretty much the same. The only thing that has changed is some of the tools. The stuff I learned about data handling back in the 60s still applies today. It all boils down to 3 simple things... Input, process, output. Make any one of those 3 slow or inaccurate and your customers will see that you have hell to pay. It's not rocket science and the cloud really doesn't change any of that.