Database design (DBDS)

The specification, design and maintenance of structures for information storage and access to support business information needs.

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.

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.

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.

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.

Level 6
Sets strategies for effective use of database technology, taking account of the complex interrelations between hardware and 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.