I'd still rather have a specialist DB guy than a C# developer who knows SQL and has even written databases. There's a lot of complexity to a DB that I don't know much about for instance, how to make it perform well etc.

A decent DB guy should be able to design a DB based on the application requirements... I guess the problem is making sure he knows what those are. But that's no different than an application coder moving to game coding really.