- Manage and monitor the database storage, database space utilisation, table extents and growth, and alert or report to the Customer on potential performance or capacity issues, or bottlenecks with recommendations;
- Setup and manage the users accounts, access rights, privileges, roles and profiles;
- Plan and perform database backup and recovery;
- Review all daily logs, database alerts, database export logs and scheduled job logs;
- Plan and schedule regular database housekeeping and maintenance activities necessary to keep the database in a healthy state and at optimal performance;
- Manage scripts and database object deployment;
- Review, propose and carry out database reorganisation, upgrades or necessary to meet target system throughput and performance;
- Perform fault and performance monitoring;
- Respond to monitoring alerts and perform first-level troubleshooting when required;
- Perform database patch management;
- Work with Customer and Customer-appointed Supplier in identifying database related issues;
- Document and maintain database server administration guides and SOPs; and
- Perform annual database disaster recovery test on selected databases as determined by the Customer.
- Conduct a backup and restore exercise to validate that the database
x
