Basic Duties of a DBA

A SQL Server DBA must wear many hats to provide a full level of service. The requirements for the DBA will vary from company to company depending upon the typical business needs or budget. The DBA might be required to perform all tasks from installation and configuration to performance tuning and guiding purchases. Conversely, the DBA might have responsibility for a single particular task such as managing backups and restores, performance optimization, or ETL tasks.

Whatever your DBA responsibilities, there are some core, basic duties that should become second nature to all DBAs.

Installation and Configuration

The SQL Server DBA is the primary source for completing installations of SQL Server in the environment. Depending on ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.