DBA Responsiblilities

DATABASE ADMINISTRATION:

Database Administrator is a person responsible for the database design,Implementation,Maintenance and repair of the data.
   
            The main goal of DBA is to keep the database server always up and make it available to users.In case of any failures DBA should minimize the data lose by implementing powerful backup   and restoring techniques.

DBA RESPONSIBILITIES:

AS a DBA we have to perform these.

1. Maintaining the availability of databases by minimizing the downtime Data recovery, We have to minimize the data loss in case of failures by implementing high availabilities.
2. provide high security in accessing the databases externally.
3. Database Administration with proficiency in SQL Server 2005, 2008 & 2012 Production Environment. 
4. Providing day-to-day Support and Maintenance for SQL Server databases.
5. Involved in Installation and configuration of MS-SQL Server 2005, 2008, 2012 in Windows environment.
6. Migration of databases from SQL server 2005 to SQL Server 2008 or 2012.Applying new service packs on production servers.
7. Need to monitor the performance of server,implement various techniques to increase the performance.
8. Regularly monitor database growth,disk space,sql server logs.Event viewer logs to avoid issues and to identify  any bottlenecks.
9. Performing and maintaining all types of Database backups and recovery operations. Creating and Administering the SQL Server Databases like data and log file placements.
10.  Performing maintenance tasks like rebuilding/reorganizing indexes and update statistics, resolving fragmentation issuesIdentifying and resolving Blocking by using Activity Monitor, System stored procedures and Profiler.
11. Experience in User Management activities like adding the user and managing the permissions.
12. Coordinating with user to resolve login failures issues.
13. Troubleshooting permission issues faced by users.
14. Refreshing databases from prod to test and prod to development environment.
15. Patching the sql server instances by applying Cumulative updates and coordinating the downtime with windows and application teams.
16. Follow ITIL process, creating change management, incidents, user service request.