To provide guidance to junior database administrators and play a pro-active role in achieving of a stable and secure production database environment which performs in alignment with predefined standards and is recoverable in case of hardware failure or disaster situations
To assess the current status of the database and keep track of the changes in workload and performance.
Monitoring the CPU utilization, Memory, Disk utilization, etc.
Check all database log files
Database log files need to be checked on a daily basis to ensure that no errors have been logged during the day or at night.
E.g. Backup log file to ensure that the database backup completed successfully or if it failed.
Fault escalation : Snr DBA or Vendor
The DBA can identify complicated faults that require senior expertise while monitoring the databases. Such faults must be escalated to the Senior DBA or vendor for further investigation or assistance.
The responsibility for resolving such faults still remains with the DBA.
The DBA is responsible for the installation of Database / Related software.
The additional installation of software patches and fixes for The database. The installation of latest version of the Database software.
The software must be investigated, tested and impact analysis has been done before implementation.
To provide accurate documentation of the database, system and processes.
The processes such as how to create users, recover a database, creating tablespace, creating and implementing a backup procedure must be documented.
Account, Role and Profile management
The creating, maintaining, and deleting of users, roles and profiles.
To ensure that all policies and procedures are adhered to when creating users, database objects, database files (permissions), etc.
To ensure that the database is setup according to the standards and policies applicable to the Database Environment.
To simplify the work of the database administration by creating scripts to assist them to automate jobs. E.g. backups, etc.
Documenting the database’s configuration and keeping it current.
The documentation should include the hardware and software configuration including system and disk space layout.
System maintenance and administration
The regular task performed by the database administrator on a day-to-day basis or by a request for service.
Tasks such as creating tables, indexes, tablespaces, creating users, configuring profiles, writing scripts, compiling procedures, completing database checklist and assisting the users with request for service calls.
Keeping the proper license information per database, per server and maintaining that information on regular basis.
To ensure that all copies of licenses are kept and renewed with the relevant vendors when required as agreed by the client.
To ensure that change control procedures are followed when major changes are taking place in the Database Environment, such as upgrading or installing patches.
Trouble shooting and problem resolution
The identifying and solving of problems that may arise, by means of investigating and analysis of problem (referring to manuals, supports sites, etc.)
Database Performance Tuning
The DBA provides assistance with the database performance tuning.
To optimize the performance on the database by prioritizing certain jobs and processes accordingly.
To provide the client with relevant performance statistics by using tools.
To fully utilize the potential of the CPU and memory on the servers.
To allocate data across disks accordingly by making use of stripes sets, etc.
The DBA provides assistance with the capacity planning.
To be able to forecast growth in data and to be able to provide information to the client that will allow the client to plan for the future.
System configuration and implementation of all services
Installing and customization of services and products when required, either during projects or for new projects for both hardware and software.
To provide accurate reports on all problems that occurs on databases.
To analyze any new changes to the database environment and to be able to analyze the impact the changes will have on the environment.
System investigation, evaluation and innovation
Evaluate new software on the market that will benefit the client and to improve on services offer