Database Architect

Design strategies for enterprise databases, data warehouse systems, and multidimensional networks. Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases or data warehouses. Create and optimize data models for warehouse infrastructure and workflow. Integrate new systems with existing warehouse structure and refine system performance and functionality.

O*NET reports this occupation under titles such as: Data Architect; Data Engineer; Data Officer; Database Analyst; Database Architect; Database Consultant; Database Developer; Database Programmer; Enterprise Architect; Information Architect

Tasks

• Develop and document database architectures.
• 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.
• Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
• Develop data models for applications, metadata tables, views or related database structures.
• 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.
• Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
• Create and enforce database development standards.
• Document and communicate database schemas, using accepted notations.
• Develop data model describing data elements and their use, following procedures and using pen, template or computer software.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
• Set up database clusters, backup, or recovery processes.
• Demonstrate database technical functionality, such as performance, security and reliability.
• Develop load-balancing processes to eliminate down time for backup processes.

Knowledge

• Computers and Electronics
• Engineering and Technology
• Design
• Mathematics
• English Language

Skills

• Reading Comprehension
• Critical Thinking
• Active Listening
• Speaking
• Active Learning
• Writing
• Monitoring
• Mathematics

Abilities

• Oral Comprehension
• Written Comprehension
• Deductive Reasoning
• Oral Expression
• Problem Sensitivity
• Inductive Reasoning
• Information Ordering
• Near Vision
• Speech Clarity
• Category Flexibility
• Written Expression
• Fluency of Ideas
• Flexibility of Closure
• Selective Attention
• Mathematical Reasoning
• Number Facility
• Perceptual Speed
• Originality
• Speech Recognition