By "consume" do you mean "make obsolete"? No matter, in my opinion Cloud computing companies must have DBAs as well. Any loss in DBA demand from maintenance on outsourced OLTP databases will likely be offset by new positions with Cloud computing companies or additional positions re-hosting data for local operational and analytical data services. I personally dislike cloud services, because of limitations imposed integrating with your enterprise's data.

Big database architectures like Hadoop are not cloud-related per se, but learning about big data architectural approaches can only help make a DBA more employable.

My understanding of Azure is that it is simply remote hosted SQL Server virtual server instances that are already set up and maintained offsite. Use of cloud services limited by bandwidth and constrained by security concerns, so those interested may want to learn about compression, SaaS integration, encoding and encryption.