1. Database Administration
A database administrator is a person responsible for the database design, implementation, maintenance, and repair of the database. 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 Database by implementing a powerful backup and restoring technique.
2. DBA Responsibilities
As a DBA we have to perform these tasks,
- 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 availability.
- Provide high security in accessing the databases externally.
- Need to monitor the performance of the server, implement various techniques to increases the performance
- Regularly monitor database growth, disk space SQL server logs, Event viewer logs to avoid issues and to identify any bottlenecks.
3. DBA Roles / Daily Activities
- As part of the DBA team need to provide 24/7 production support to client and users.
- Work on user requirements and problems that come in the form of tickets.
- Responding to alerts that we receive in the form of an email from third-party monitoring tools.
- Make sure all the maintenance jobs are running successfully.
- Make sure all backup jobs are 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.
Below topics further included in this series
- SQL Server Database Administration Introduction
- SQL Server Architecture
- SQL Server Storage Architecture
- SQL Server Database Architecture
- SQL Server Transaction Log Architecture
- SQL Server installation
- SQL Server Databases
- SQL Server Backups
- SQL Server Restoration Tutorial
- SQL Server Security
- SQL Server Automation Tutorial
- SQL Server Migration
- SQL Server Upgradation
- SQL Server Log Shipping in SQL Server