# 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. - Code: 15-1243.00 (O*NET-SOC; SOC 2018 15-1243) - Family: [Computer & Mathematical](https://foundation.org.ai/occupations#family-15), one of its 38 occupations - Tasks: 25 tasks (24 core and 1 supplemental) - Page: https://foundation.org.ai/occupations/15-1243.00 - JSON: https://foundation.org.ai/data/tasks/15-1243.00.json ## What the work is made of 1. Develop and document database architectures. Core task · Task 16115 · Rated by 21 occupational experts, August 2023 2. Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements. Core task · Task 16113 · Rated by 21 occupational experts, August 2023 3. Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements. Core task · Task 16114 · Rated by 21 occupational experts, August 2023 4. Design databases to support business applications, ensuring system scalability, security, performance, and reliability. Core task · Task 16109 · Rated by 21 occupational experts, August 2023 5. Develop data models for applications, metadata tables, views or related database structures. Core task · Task 16108 · Rated by 21 occupational experts, August 2023 6. 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. Core task · Task 16110 · Rated by 21 occupational experts, August 2023 7. Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs. Core task · Task 21653 · Rated by 21 occupational experts, August 2023 8. Create and enforce database development standards. Core task · Task 16112 · Rated by 21 occupational experts, August 2023 9. Document and communicate database schemas, using accepted notations. Core task · Task 16105 · Rated by 21 occupational experts, August 2023 10. Develop data model describing data elements and their use, following procedures and using pen, template or computer software. Core task · Task 21652 · Rated by 21 occupational experts, August 2023 11. Work as part of a project team to coordinate database development and determine project scope and limitations. Core task · Task 21659 · Rated by 21 occupational experts, August 2023 12. Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management. Core task · Task 21655 · Rated by 21 occupational experts, August 2023 13. Set up database clusters, backup, or recovery processes. Core task · Task 16100 · Rated by 21 occupational experts, August 2023 14. Demonstrate database technical functionality, such as performance, security and reliability. Core task · Task 16111 · Rated by 21 occupational experts, August 2023 15. Develop load-balancing processes to eliminate down time for backup processes. Core task · Task 16107 · Rated by 21 occupational experts, August 2023 16. Plan and install upgrades of database management system software to enhance database performance. Core task · Task 16102 · Rated by 21 occupational experts, August 2023 17. Identify, evaluate and recommend hardware or software technologies to achieve desired database performance. Core task · Task 16101 · Rated by 21 occupational experts, August 2023 18. Test programs or databases, correct errors, and make necessary modifications. Core task · Task 21657 · Rated by 21 occupational experts, August 2023 19. Identify and correct deviations from database development standards. Core task · Task 16104 · Rated by 21 occupational experts, August 2023 20. Review project requests describing database user needs to estimate time and cost required to accomplish project. Core task · Task 21656 · Rated by 21 occupational experts, August 2023 21. Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions. Core task · Task 21660 · Rated by 21 occupational experts, August 2023 22. Develop or maintain archived procedures, procedural codes, or queries for applications. Core task · Task 16106 · Rated by 21 occupational experts, August 2023 23. Provide technical support to junior staff or clients. Core task · Task 16099 · Rated by 21 occupational experts, August 2023 24. Establish and calculate optimum values for database parameters, using manuals and calculators. Core task · Task 21654 · Rated by 21 occupational experts, August 2023 25. Train users and answer questions. Supplemental task · Task 21658 · Rated by 21 occupational experts, August 2023 ## More in Computer & Mathematical - [Actuaries](https://foundation.org.ai/occupations/15-2011.00): 15 tasks - [Bioinformatics Technicians](https://foundation.org.ai/occupations/15-2099.01): 19 tasks - [Biostatisticians](https://foundation.org.ai/occupations/15-2041.01): 25 tasks - [Blockchain Engineers](https://foundation.org.ai/occupations/15-1299.07): 17 tasks - [Business Intelligence Analysts](https://foundation.org.ai/occupations/15-2051.01): 17 tasks - [Clinical Data Managers](https://foundation.org.ai/occupations/15-2051.02): 21 tasks - [Computer and Information Research Scientists](https://foundation.org.ai/occupations/15-1221.00): 15 tasks - [Computer Network Architects](https://foundation.org.ai/occupations/15-1241.00): 33 tasks - [Computer Network Support Specialists](https://foundation.org.ai/occupations/15-1231.00): 26 tasks - [Computer Occupations, All Other](https://foundation.org.ai/occupations/15-1299.00): no tasks listed - [Computer Programmers](https://foundation.org.ai/occupations/15-1251.00): 17 tasks - [Computer Systems Analysts](https://foundation.org.ai/occupations/15-1211.00): 22 tasks - [Computer Systems Engineers/Architects](https://foundation.org.ai/occupations/15-1299.08): 28 tasks - [Computer User Support Specialists](https://foundation.org.ai/occupations/15-1232.00): 16 tasks - [Data Scientists](https://foundation.org.ai/occupations/15-2051.00): 16 tasks - [Data Warehousing Specialists](https://foundation.org.ai/occupations/15-1243.01): 18 tasks - [Database Administrators](https://foundation.org.ai/occupations/15-1242.00): 18 tasks - [Digital Forensics Analysts](https://foundation.org.ai/occupations/15-1299.06): 20 tasks - [Document Management Specialists](https://foundation.org.ai/occupations/15-1299.03): 23 tasks - [Geographic Information Systems Technologists and Technicians](https://foundation.org.ai/occupations/15-1299.02): 29 tasks - [Health Informatics Specialists](https://foundation.org.ai/occupations/15-1211.01): 17 tasks - [Information Security Analysts](https://foundation.org.ai/occupations/15-1212.00): 11 tasks - [Information Security Engineers](https://foundation.org.ai/occupations/15-1299.05): 20 tasks - [Information Technology Project Managers](https://foundation.org.ai/occupations/15-1299.09): 21 tasks - [Mathematical Science Occupations, All Other](https://foundation.org.ai/occupations/15-2099.00): no tasks listed - [Mathematicians](https://foundation.org.ai/occupations/15-2021.00): 11 tasks - [Network and Computer Systems Administrators](https://foundation.org.ai/occupations/15-1244.00): 20 tasks - [Operations Research Analysts](https://foundation.org.ai/occupations/15-2031.00): 17 tasks - [Penetration Testers](https://foundation.org.ai/occupations/15-1299.04): 22 tasks - [Software Developers](https://foundation.org.ai/occupations/15-1252.00): 19 tasks - [Software Quality Assurance Analysts and Testers](https://foundation.org.ai/occupations/15-1253.00): 30 tasks - [Statisticians](https://foundation.org.ai/occupations/15-2041.00): 19 tasks - [Telecommunications Engineering Specialists](https://foundation.org.ai/occupations/15-1241.01): 26 tasks - [Video Game Designers](https://foundation.org.ai/occupations/15-1255.01): 24 tasks - [Web Administrators](https://foundation.org.ai/occupations/15-1299.01): 35 tasks - [Web and Digital Interface Designers](https://foundation.org.ai/occupations/15-1255.00): 30 tasks - [Web Developers](https://foundation.org.ai/occupations/15-1254.00): 29 tasks ## Where this comes from Quoted from O*NET 29.0, U.S. Department of Labor, Employment and Training Administration, under CC BY 4.0: free to copy and reuse, with credit. Nothing on this page is written by the Org.AI Foundation.