Database Management
Knowledge and ability to apply methods, practices and policy to plan, develop, manage databases and retrieval.
Proficiency Level
Level 1 (Follow)
- Demonstrate basic understanding of database management, logical design concepts and levels of database security.
- Understand the difference between different database structures (e.g, relational vs. network).
- Comprehend database design (e.g., diagrams, schemas, models).
- Demonstrate basic understanding of data manipulation language (DML).
- Demonstrate an awareness of performance issues (e.g., distribution of data, size definitions).
Level 2 (Assist)
- Understand a single database management system (DBMS), its components and how they relate to each other.
- Demonstrate a good knowledge of data manipulation language (DML) and data definition language (DDL).
- Code/test basic database access modules (e.g., stored procedures).
- Troubleshoot, at a basic level, to understand database problem and identify where to direct it (e.g., basic database accessibility).
- Recognise the importance of database basic recovery and, with guidance, perform backup and recovery.
- Understand database release management, applications business rules, data integrity issues, database security implementation, workload manager and interaction with DBMS.
- Perform data population, debugging and testing.
- Conduct basic impact analysis for database change management.
Level 3 (Apply)
- Demonstrate working level understanding of single DBMS relevant operating systems, applications business rules and its dependencies with other applications, databases and/or business partners.
- Apply wide range of concepts to the corporate/vendor environment (e.g., database security and/or individual profiles).
- Make recommendations on logical/physical models (e.g., converts from logical model, implements, and maintains physical model to meet storage, availability, and performance requirements).
- Develop, code, test, and review complex database access modules.
- Solve problems that impact on the business or service, resolves data integrity issues and implements data integrity safeguards, and use diagnostic and monitoring tools to prevent problems/enhance performance and availability.
- Demonstrate a solid knowledge of system testing and integration environments.
- Develop, select, recommend, and implement strategies for backup and recovery, data population and migration.
- Conduct general impact analysis on database change.
Level 4 (Ensure)
- Demonstrate broad understanding of multiple DBMS or an in-depth knowledge of one or more DBMS.
- Develop logical models incorporating business requirements such as high availability, redundancy, and disaster recovery into the logical/physical database design.
- Research, pilot, evaluate new technologies and standards, identify how they will integrate with the corporate network and recommend strategies.
- Solve unusual problems or problems with a significant impact on the business.
- Deal with major and/or multiple application groups.
- Create or review certification testing.
- Develop standards and procedures for implementing new database technology.
- Mentor people and provide input/guidance to cross-functional teams.
Level 5 (Strategise)
- Demonstrate expert knowledge of data management, data stewardship, government-wide data management initiatives and trends in data management and how they can be applied.
- Hold an enterprise-wide view and/or is regarded as the subject matter expert in one or more areas of expertise and provide effective strategic direction to enterprise-wide data management.
- Develop enterprise-wide multi-disciplinary architectural documents translating business data requirements into topographical format.
- Demonstrate broad-based knowledge of information technology (e.g., programming, data management, platforms).
- Develop business cases for enterprise-wide data management initiatives as a direct response to business drivers.
- Guide and oversee multiple-concurrent data management projects.
- Conduct procurement for data management solutions and related services.
- Develop strategies, policy and standards for corporate data management and contributes to standards working groups and/or industry.