Database design DBDS
The specification, design and maintenance of mechanisms for storage and access to both structured and unstructured information, in support of business information needs.
Levels
| Defined at these levels: | 2 | 3 | 4 | 5 | 6 |
Click to learn why SFIA skills are not defined at all 7 levels.
Database design: Level 1
This skill is not typically observed when working at this level of responsibility.
Database design: Level 2
Translates and implements simple development project requirements into physical database structures. Assesses proposed changes to object and data structures and implements these changes in physical databases. Assists in database management system support activities for operational database systems.
Database design: Level 3
Develops specialist knowledge of database concepts, object and data modelling techniques and design principles. Translates object and data models into appropriate database schemas within design constraints. Interprets installation standards to meet project needs and produces database components as required. Evaluates potential solutions, demonstrating, installing and commissioning selected products.
Database design: Level 4
Develops and maintains specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software and facilities. Analyses data requirements to establish, modify or maintain object/data models. Evaluates potential solutions, demonstrating, installing and commissioning selected products.
Database design: Level 5
Maintains and applies up to date, specialist knowledge of database concepts, object and data modelling techniques and design principles, and a detailed knowledge of the full range of database architectures, software and facilities available. Analyses data requirements, to establish, modify or maintain a data model. Takes account of specialist requirements (e.g. geocoding, for geographic information systems). Interprets the model into an appropriate database schema within set policies. Demonstrates, installs and commissions selected products.
Database design: Level 6
Sets strategies for effective use of database technology taking account of the complex interrelations between hardware/software. Provides specialist expertise in the development, use or operation of database management system tools and facilities. Provides expert knowledge in the selection, provision and use of database architectures, software and facilities, typically taking responsibility for a team of technical staff.
Database design: Level 7
This skill is not typically observed when working at this level of responsibility.