The database administrator or DBA plays a significant role in the installation and ongoing support of software packages and operating environments. It is typically configured to optimize performance and with the most stringent backup and recovery processes in place so that NO data is lost in the case of failures.
Configuration can vary depending on the types of activities that are going on.
Backup and Recovery One of the most important areas for the DBA to focus on, is proper backup and recovery procedures for each database. The starting point for each, is what are the availability requirements and recovery requirements. The next step in developing the backup strategy is to review the size and configuration of the database, and determine which backup options will meet the requirements. Cold Backups 2. Hot Backups 3.