Database Architects
Tasks
Core Tasks Include:
- Provide technical support to junior staff or clients.
- Set up database clusters, backup, or recovery processes.
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Plan and install upgrades of database management system software to enhance database performance.
- Identify and correct deviations from database development standards.
- Document and communicate database schemas, using accepted notations.
- Develop or maintain archived procedures, procedural codes, or queries for applications.
- Develop load-balancing processes to eliminate down time for backup processes.
- Develop data models for applications, metadata tables, views or related database structures.
- Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
- Design 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.
- Demonstrate database technical functionality, such as performance, security and reliability.
- Create and enforce database development standards.
- Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
- Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Develop and document database architectures.
- Develop data model describing data elements and their use, following procedures and using pen, template or computer software.
- Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
- Establish and calculate optimum values for database parameters, using manuals and calculators.
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
- Review project requests describing database user needs to estimate time and cost required to accomplish project.
- Test programs or databases, correct errors, and make necessary modifications.
- Work as part of a project team to coordinate database development and determine project scope and limitations.
- Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
Supplemental Tasks Include:
- Train users and answer questions.
The data sources for the information displayed here include: O*NET™. (Using onet291)
