Category: Development and implementation

Subcategory: Data and analytics

Database design - DBDS

Specifying, designing and maintaining mechanisms for storing and accessing data across various environments and platforms.

Levels:

Level 2:
Description: Assists in creating and documenting detailed database designs under routine supervision. Follows established procedures and guidelines. Helps create and maintain documentation.

Level 3:
Description: Interprets installation standards to meet project needs and produces database or data warehouse component specifications. Develops physical database or data warehouse design elements, within set policies, to meet data requirements.

Level 4:
Description: 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 business intelligence and data analytics.

Level 5:
Description: 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 design policies optimise transactional data systems for performance and availability while meeting the needs of business intelligence and analytics platforms.