Database administration DBAD

(modified)

Installing, configuring, monitoring, maintaining and improving the performance of databases and data stores.

Guidance notes

(new)

Database administration may be in support of live operational databases in production use or for internal/interim purposes such as iterative developments and testing. 

Activities may include - but are not limited to...

  • identifying and acting on automation opportunities to improve performance and value from databases, data stores and data pipelines.
  • using database management system software and tools 
  • applying knowledge of the logical database schemata

Database administration: Level 5

(modified)

Identifies, evaluates and manages the adoption of database administration tools and processes, including automation. Develops and maintains procedures and documentation for databases. Contributes to the setting of standards for definition, security and integrity of database objects and ensures conformance to these standards. Manages database configuration including installing and upgrading software and maintaining relevant documentation. Monitors database activity and resource usage. Optimises database performance and plans for forecast resource needs.

Database administration: Level 4

(modified)

Develops and configures tools to enable automation of database administration tasks. Monitors performance statistics and create reports. Identify and investigates complex problems and issues and recommends corrective actions. Performs routine configuration, installation, and reconfiguration of database and related products.

Database administration: Level 3

(modified)

Performs standard database maintenance and administration tasks. Uses database management system software and tools to collect performance statistics.

Database administration: Level 2

(unchanged)

Assists in database support activities.