DBA Roles and Responsibilities

1.  Installation and Configuration of SQL Server
2.  Up-gradation of SQL Server from lower version to higher version
3.  Migration of SQL Server Database from One Server to Another Server
4.  Applying patch and hot fix to SQL Server
5.  Monitoring SQL Server Health
6.  Monitoring Operating System Health
7.  Troubleshooting the MSSQL, Database and Operating System Performance issue
8.  Setting Up SQL Server Level, Database Level and Operating System Alerts
9.  Capacity planning for the hardware requirement
10.  Designing and Implementing Backup/Recovery Strategies
11.  Implementing HA Solutions (Replication, Mirroring, Clustering and Log Shipping)
12.  Managing Logins, Users and Security
13.  Establishing and Enforcing Standards
14.  Implementation of robust maintenance plan (Index Defrag, Stats Update, DBCC)
15.  T-SQL Tuning
16.  Creating and Scheduling Jobs through Maintenance plan
17.  Expert in troubleshooting the SQL Server and Database Issues
18.  Documentation of any implementation and change
19.  Expert level knowledge of SQL Server Architecture
20.  Co-ordination with third party vendor for any product related issue
21.  Knowledge of ITIL standards(Problem Management/Incident Management/Chain Management etc.)
22.  Knowledge of Operating System
23.  Knowledge of all the SQL versions and newer features.
24.  Closely work with Developer .
25. Work as part of a team and provide 24×7 supports when required.