Skill description
Specifying, designing and maintaining mechanisms for storing and accessing data across various environments and platforms.
Guidance notes
Activities may include, but are not limited to:
- designing operational databases, data warehouses, data lakes, or data stores for on-premise, cloud-based, or hybrid environments.
- defining physical or virtual structures required to support applications, analytics, machine learning, business intelligence or other data-driven services.
- designing operational data stores to integrate data from multiple sources to support data pipelines and enable additional operations on the data.
- aligning designs with data architectures, enterprise architectures, standards, policies and regulations.
- considering scalability, performance, availability, recovery and other operational requirements.
Level 2Assist
Assists in creating and documenting detailed database designs under routine supervision.
Follows established procedures and guidelines.
Helps create and maintain documentation.
Level 3Apply
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 4Enable
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 5Ensure, advise
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.
No notes added yet.
Comments
0 comments
Please sign in to leave a comment.