Not in the same way as Oracle, as in a pre-packaged set of configurations, permissions and audit rules, but it has all the constituent parts in order to configure this.

A good resource to start with would be this:

http://download.microsoft.com/download/D/2/D/D2D931E9-B6B5-4E3B-B0AF-22C749F9BB7E/SQL_Server_Separation_of_Duties_White_Paper_Jul2011.docx