Database administration DBAD
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).
Moving to SFIA 8
There is an updated version of this skill for SFIA 8.
- The skill descriptions have been edited for readability and guidance notes have been added
- Details available here - SFIA 8 Database administration
- SFIA 7 skill descriptions will remain available for you to use
- Previous SFIA assessments are not impacted by this change.
2 | 3 | 4 | 5 |
Levels of responsibility for this skill
Database administration: Level 1
This skill is not typically observed or practiced at this level of responsibility and accountability.
Database administration: Level 2
Assists in database support activities.
Database administration: Level 3
Uses database management system software and tools to collect agreed performance statistics. Carries out agreed database maintenance and administration tasks.
Database administration: Level 4
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 5
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: Levels 6-7
This skill is not typically observed or practiced at these levels of responsibility and accountability.