The main task of SQL Server DBA is managing sql server, depending on type of DBA position they hold it can be programing i.e. writing sql scripts as development dba, review others scripts like QA. If they are production DBA then no much programing work is involve on daily basis but lot of responsibility, monitoring of performance, moving of objects from QA to Production, backups and optimization.
