Designs strategies for enterprise database systems and set standards for operations, programming, and security. Designs and constructs large relational databases. Integrates new systems with existing warehouse structure and refines system performance and functionality.
This career is part of the Information Technology cluster Information Support and Services pathway.
A person in this career:
- Designs databases to support business applications, ensuring system scalability, security, performance and reliability.
- Develops database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Develops data models for applications, metadata tables, views or related database structures.
- Collaborates with system architects, software architects, design analysts, and others to understand business or industry requirements.
- Sets up database clusters, backup, or recovery processes.
- Creates and enforces database development standards.
- Develops and documents database architectures.
- Designs database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
- Monitors and reports systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
- Documents and communicates database schemas, using accepted notations.