Great article and defining data warehouse DBA is excellent.  I want to add that Production DBA cares more about performance while Development DBA just wants result to be correct and match the books.  For Production DBA 30,000 reads is unacceptable and consumes resources while the Development DBA just want the correct answer regardless of the amount of reads.  Also Production DBA need to now why the System is Locked and which SPID to sacrifice to get the Server back to Business.  Also the Production DBA would need to now more Windows Enterprise techniques to help navigate SQL server through and able to pinpoint if the performance issue due to Windows/SP code/IIS issues.

Maher Shaheen