Database administration DBAD
Installing, configuring, monitoring, maintaining and improving the performance of databases and data stores.
Updates for SFIA 9
- There is an updated version of this skill for SFIA 9.
- Theme(s) influencing the updates for this skill: Application of SFIA skills for cloud-based working, Making SFIA easier to consume (enhance readability/guidance/descriptions), Support for cyber security working practices (both specialised and general).
- Content changes have been made to levels 2, 3, 4, and 5.
- You can move to SFIA 9 when you are ready - SFIA 8 skill descriptions will still be available to use.
- Previous SFIA assessments or skills mapping are not impacted by this change.
Guidance notes
Database administration may support live operational databases in production use or internal/interim databases used for 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 schema.
Levels of responsibility for this skill
| 2 | 3 | 4 | 5 |
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
Performs standard database maintenance and administration tasks.
Uses database management system software and tools to collect performance statistics.
Database administration: Level 4
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 5
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: Levels 6-7
This skill is not typically observed or practiced at these levels of responsibility and accountability.