Backup/Restore

The DBA will create backup and recovery plans and procedures based on industry best practices, then make sure that the necessary steps are followed.

Whilst other personnel may create and provide the backups, it is the DBA’s responsibility to make sure that everything is validated and completed safely on schedule. In the case of a server failure, and different types of failures may require different recovery strategies, we will be plan for any eventuality

Patching

Our application of a set of changes to a SQL RDBMS designed to update, fix, or improve it.

This includes fixing security vulnerabilities and improving the functionality, usability or performance.

Capacity Planning

We need to know how large the database currently is and how fast it is growing in order to make predictions about future needs.

Storage refers to how much room the database takes up in server and backup space. Capacity refers to usage level.

Regular House-Keeping

Refresh of all SQL environments from Production to include schemas, configurations, permissions, obfuscated data, and DDL.

Monitoring databases for performance issues and slowing down processing may require us to make configuration changes to the software or add additional hardware capacity. We use a variety of monitoring tools and we need to understand what they need and how to interpret results.

We are on call for troubleshooting in case of any problems. Whether they need to quickly restore lost data or correct an issue to minimise damage, we need to quickly understand and respond to problems when they occur.

We create tasks that are all run with the intention to improve our database(s). There are routines meant to help performance, free up disk space, check for data errors, check for hardware faults, update internal statistics, and many other things