Database administration DBAD
(modified)
Installing, configuring, monitoring, maintaining databases and data stores, ensuring performance, security, and adapting to evolving technologies.
This is a prototype for SFIA 9. It is subject to change before publication.
Guidance notes
(modified)
Database administration involves managing operational databases in production environments as well as supporting databases for development, testing, and iterative improvements. The focus is on ensuring database availability, integrity, security, and performance across a variety of database types, including relational, NoSQL, and cloud-based databases.
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 including both cloud-based and on-premises solutions
- applying knowledge of the logical database schema
- ensuring compliance with data privacy laws and regulations
- designing and implementing disaster recovery and backup strategies
- integrating and managing databases across hybrid environments, combining on-premises and cloud-based solutions
- monitoring emerging database technologies and trends
Levels
| Defined at these levels: | 2 | 3 | 4 | 5 |
Click to learn why SFIA skills are not defined at all 7 levels.
Database administration: Level 1
This skill is not typically observed when working at this level of responsibility.
Database administration: Level 2
(modified)
Supports basic database maintenance tasks under supervision.
Assists with data backup and simple issue resolution.
Database administration: Level 3
(modified)
Performs standard database maintenance and administration tasks.
Uses database management system software and tools to collect performance statistics and identify optimisation opportunities.
Database administration: Level 4
(unchanged)
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
(modified)
Leads in identifying, evaluating, and integrating improvements in database administration tools and processes.
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 when working at these levels of responsibility.