For an insight in my doings, I'm involved in installation & support of SQL Server, performance optimization, virtualization & consolidation. At times into designing databases, more often with trouble shooting. Have automated some of the key tasks using DMO/SMO with VB script & powershell; leading to savings for a few professional tools.
As with most DBA's I do all back-up / recovery for my bread & butter, while for high availablity I've implimented mirroring, replication & Log shipping as applicable with or without clusters. Doing SSIS for ETL as dataprovider.