Reference and guide to SFIA version 7. Framework status: Development. Show revision-marked text

Database administration DBAD

(modified)

The installation, configuration, upgrade, administration, monitoring and maintenance of databases. Providing support for operational databases in production use and for internal or interim purposes such as iterative developments and testing. Improving the performance of databases and the tools and processes for database administration (including automation).

Database administration: Level 5

(modified)

Develops and maintains procedures and documentation for databases. Identifies, evaluates and manages the adoption of appropriate database administration tools and processes, including automation. 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)

Uses database management system software and tools, and knowledge of logical database schemata, to investigate problems and collect performance statistics and create reports. Carries out routine configuration / installation and reconfiguration of database and related products. Develops and configures tools to enable automation of database administration tasks. Identify problems and issues and recommend corrective actions.

Database administration: Level 3

(unchanged)

Uses database management system software and tools to collect agreed performance statistics. Carries out agreed database maintenance and administration tasks.

Database administration: Level 2

(unchanged)

Assists in database support activities.