SQL Server DBA Roles and Responsibilities

  The SQL Server Database System from Microsoft Corporation has gained popularity over the years and it is believed to be one of the few surviving relational database systems in this challenging marketplace. Commercial RDBMS systems such as Microsoft's SQL Server, Oracle, MySQL and IBM's DB2 are complex applications that call for specialized knowledge and training.

These are some of the roles carried out by a SQL Server DBA

1.) Installation, Administration and Maintenance of SQL Server Instances. Basically the installation process of SQL Server.

2.) Setup Test, Development, Staging and Production server Environments.

3.) Create Users and assign permissions based on the level of database access the user would need. (Security related concerns)

4.) Create Linked Servers to SQL Servers and other databases such as Access, Oracle, Informix etc. (Security and General Administration)

5.) Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)

6.) Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)

7.) From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)

8.) Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Fail-over Clustering, Database Mirroring, Log Shipping and Replication)

9.) Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))

10.) Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc) 

11.) Documenting major changes to the SQL Servers. (General)

12.) Apply Service Packs. (General)

Reference : http://tinyurl.com/zchxavb


If you have any questions or concerns, please let me know.

Previous Post Next Post