Database Architects
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.
Also known as: ADP Planner (Automatic Data Processing Planner), Big Data Architect, Big Data Engineer, Cloud Architect, Cloud Infrastructure Architect, Computer Architect, Data Analyst, Data Architect, ...
Annual Salary
Median annual wage (May 2024)
Job Outlook
Projected growth, 2024–2034 (Much faster than average)
What You'd Do
- 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.
Top Skills
Importance scale: 1 (low) – 5 (high)
Knowledge Areas
Importance scale: 1 (low) – 5 (high)
Education Level Distribution
Percentage of workers in this occupation by education level
Technology & Tools
Software and tools commonly used in this role
In-Demand Technologies
Work Styles
Personality traits and work styles important for this career
Key Abilities
Cognitive, physical, and sensory abilities important for this role
Importance scale: 1 (low) – 5 (high)
Work Activities
General types of job behaviors occurring on this job
Importance scale: 1 (low) – 5 (high)
Work Environment
Physical and social factors that influence the nature of work
Related Careers
Is Database Architects right for you?
Take our free career quiz to see how you match with this and 900+ other careers.
Salary data: BLS Occupational Employment and Wage Statistics, May 2024. Outlook data: BLS Employment Projections, 2024–2034.
This page includes information from the O*NET 30.2 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license.