Personally I think Yukon will require more DBA work. Adding all that into the RDBMS will create more and new issues, require more control of changes, and require the DBA to be more of a guardian of the system.

I think the DBA job will change because you will focus on different areas and yes, you will need to understand development to understand what the developres are trying to do to your database.