Database design DBDS

(modified)

Specifying, designing and maintaining mechanisms for storing and accessing data.

Guidance notes

(new)

Activities may include - but are not limited to...

  • designing operational databases
  • defining physical or virtual data warehouse structures required to support machine learning, business intelligence, data analytics services
  • designing operational data stores to integrate datfrom multiple sources to support data pipelines and enable additional operations on the data

Database design: Level 5

(modified)

Provides specialist expertise in the design characteristics of database management systems (DBMS) 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: Level 4

(modified)

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, in order to evaluate alternative options. Implements data warehouse designs that support demands for business intelligence and data analytics.

Database design: Level 3

(modified)

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 business change or development project data requirements.