Database Design
Designing and maintaining databases to support optimal storage and access of data.
Level 1. Demonstrates introductory understanding, directing people to the appropriate source for further information.
BEHAVIORS
- Explains basic concepts in database and data warehouse design.
- Describes common database models (e.g., relational, object-oriented) and their features.
- Identifies various elements of a database and their relationships.
QUESTIONS
- Describe a situation where you were required to have an understanding of database and data warehouse design.
Probing Questions
* What was the situation?
* What database and data warehouse design concepts did you need to understand?
* What did you need to accomplish?
* What was the outcome?
- Describe a situation where you relied on your knowledge of different database design features.
Probing Questions
* What was the situation?
* How was your knowledge of the features of the database important in this situation?
* What did you need to accomplish?
* What was the outcome?
Level 2. Applies the competency in common situations that present limited difficulties, working with a moderate level of guidance.
BEHAVIORS
- Assists in requirements analysis, collecting input from stakeholders in specific domains.
- Develops simple elements of a physical database design with guidance.
- Follows standard guidelines to install databases.
QUESTIONS
- Describe a situation where you installed a database or several databases following a standard set of guidelines.
Probing Questions
* What was the situation?
* What was your role?
* What did you need to accomplish?
* What did you do?
* What was the outcome?
- Describe a situation where you developed simple elements of a physical database design within a team.
Probing Questions
* What was the situation?
* What was your role and responsibilities within the team?
* What did you need to accomplish?
* What did you do?
* What was the outcome?
Level 3. Applies the competency in the full range of typical situations, requiring guidance in only the most complex or new situations.
BEHAVIORS
- Conducts requirements analysis with domain experts.
- Determines the optimal database model to meet system or application requirements.
- Translates complex requirements into efficient database designs to meet business needs or application development requirements
- Identifies alternative options for new changes to data structures.
QUESTIONS
- Describe a situation where you determined the type of database or data warehouse for a specific application requirement.
Probing Questions
* What was the situation?
* What did you need to accomplish?
* What did you do?
* What was the outcome?
- Describe a situation where you identified various options for new changes to data structures in a database or data warehouse.
Probing Questions
* What was the situation?
* What changes needed to be made?
* What did you do?
* What was the result?
Level 4. Applies the competency in new or complex situations and advises others.
BEHAVIORS
- Makes technical recommendations to improve the efficiency and security of enterprise databases.
- Implements data models as well as logical models and physical databases for major and/or multiple applications.
- Evaluates database products and services to meet business requirements.
- Reviews system and programming designs to ensure efficient use of database resources.
- Develops mapping requirements to translate and port old databases to new schemas.
- Performs quality assurance to optimize and tune databases and objects.
QUESTIONS
- Describe a situation when you had to implement data models, logical models and physical databases for multiple applications.
Probing Questions
* What was the situation?
* What did you need to accomplish?
* What did you do?
* What was the end result?
- Describe a situation where you reviewed system designs to ensure the efficient use of databases or data warehouses.
Probing Questions
* What was the situation?
* How did you complete your review?
* What recommendations did you make?
* What was the outcome?
Level 5. Develops new approaches and methods in the area. Is recognized as an expert within the organization.
BEHAVIORS
- Develops enterprise-wide multi-disciplinary architectural documents, translating business data requirements into topographical format.
- Guides the selection and development of database designs in support of software applications.
- Leads the design and implementation of database management systems.
- Selects appropriate database technologies to meet the design needs and scalability requirements.
- Researches and prototypes new database features, design, and architecture ahead of mainstream development.
QUESTIONS
- Describe a situation where you had to select the appropriate database technologies to meet large scalability needs.
Probing Questions
* What was the situation?
* What were the requirements?
* What did you do?
* What was the end result?
- Describe a situation when you had to lead the design and implementation of a database management system.
Probing Questions
* What was the situation?
* What did you need to accomplish?
* What did you do?
* What was the end result?