A three year residency could be specialized in things like web development, graphics, databases, or networks. And the more challenging sub-specialties could have a fellowship after the residency.

So, to be a DBA you would probably be done after the residency (hey, it ain't brain surgery!) However, it might not be a bad idea to have some exposure to procedural languages, with respect to RDBMS, because you may end up maintaining CLR routines on SQL Server. And, what if you had landed in the Teradata world? (I just did.) I'm only getting started with it, but it looks like you can't even create a user-defined function without compiling a little C.