Database design DBDS
Specifying, designing and maintaining mechanisms for storing and accessing data.
Updates for SFIA 9
- There is an updated version of this skill for SFIA 9.
- Theme(s) influencing the updates for this skill: Making SFIA easier to consume (enhance readability/guidance/descriptions), Making SFIA easier to consume (new levels).
- New level 2 added to support entry-level roles.
- Content changes have been made to level 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
Activities may include — but are not limited to:
- designing operational databases
- designing on-premise or cloud-based databases
- defining physical or virtual data warehouse structures required to support machine learning, business intelligence or data analytics services
- designing operational data stores to integrate data from multiple sources to support data pipelines and enable additional operations on the data.
Levels of responsibility for this skill
| 3 | 4 | 5 |
Database design: Levels 1-2
This skill is not typically observed or practiced at these levels of responsibility and accountability.
Database design: Level 3
Interprets installation standards to meet project needs and produces database or data warehouse component specifications.
Develops appropriate physical database or data warehouse design elements, within set policies, to meet data requirements.
Database design: Level 4
Implements physical database designs to support transactional data requirements for performance and availability.
Develops and maintains specialist knowledge of database and data warehouse concepts, design principles, architectures, software and facilities.
Assesses proposed changes to object/data structures and evaluates alternative options.
Implements data warehouse designs that support demands for business intelligence and data analytics.
Database design: Level 5
Provides specialist expertise in the design characteristics of database management systems or data warehouse products/services.
Provides expert guidance in the selection, provision and use of database and data warehouse architectures, software and facilities.
Ensures that physical database design policy supports transactional data requirements for performance and availability.
Ensures that data warehouse design policy supports demands for business intelligence and data analytics.
Database design: Levels 6-7
This skill is not typically observed or practiced at these levels of responsibility and accountability.