DBA'S Roles and Daily Activities

DBA's Roles and Daily Activities:

• As part of DBA team need to provide 24/7 production support to client and users.
• We will look into client mail box first and respond to required mails
• We will check Ticketing tool and will work on the available tickets which includes Incidents, SR's, Changes and Problem tickets based on priority whether it's P1\P2\P3 
• We will check and work on recurring activities if any such as weekly, monthly, quarterly, half yearly and yearly.
• We will work on adhoc requests which are requested  by client.
• Make sure all the maintainence jobs are running successfully.
• Make sure all backup jobs executed successfully without any issues on all servers.
• Checking sql server logs to identify bottlenecks.
• Checking drive spaces on critical servers to ensure that there is ample amount of space.
• Regularly monitor data file growth,log file growth,database growth as part of capacity planning.
• Maintain documentation of all the tasks and issues that you encounter for future reference.
• Check whether all sql services are running or not.

Read More

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.

Read More