Org.AI Foundation Partner

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.

Tasks
25 tasks24 core, 1 supplemental
Family
Computer & MathematicalOne of its 38 occupations
Code
15-1243.00SOC 2018: 15-1243

Read the 25 tasks Download this record as JSON

What the work is made of

24 core tasks and 1 supplemental, each quoted as published, with the survey it came from.

Show

Core: central to the jobSupplemental: done by some, not all

  1. Task 1. Develop and document database architectures.Core taskTask 16115Rated by 21 occupational experts, August 2023
  2. Task 2. Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.Core taskTask 16113Rated by 21 occupational experts, August 2023
  3. Task 3. Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.Core taskTask 16114Rated by 21 occupational experts, August 2023
  4. Task 4. Design databases to support business applications, ensuring system scalability, security, performance, and reliability.Core taskTask 16109Rated by 21 occupational experts, August 2023
  5. Task 5. Develop data models for applications, metadata tables, views or related database structures.Core taskTask 16108Rated by 21 occupational experts, August 2023
  6. Task 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 taskTask 16110Rated by 21 occupational experts, August 2023
  7. Task 7. Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.Core taskTask 21653Rated by 21 occupational experts, August 2023
  8. Task 8. Create and enforce database development standards.Core taskTask 16112Rated by 21 occupational experts, August 2023
  9. Task 9. Document and communicate database schemas, using accepted notations.Core taskTask 16105Rated by 21 occupational experts, August 2023
  10. Task 10. Develop data model describing data elements and their use, following procedures and using pen, template or computer software.Core taskTask 21652Rated by 21 occupational experts, August 2023
  11. Task 11. Work as part of a project team to coordinate database development and determine project scope and limitations.Core taskTask 21659Rated by 21 occupational experts, August 2023
  12. Task 12. Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.Core taskTask 21655Rated by 21 occupational experts, August 2023
  13. Task 13. Set up database clusters, backup, or recovery processes.Core taskTask 16100Rated by 21 occupational experts, August 2023
  14. Task 14. Demonstrate database technical functionality, such as performance, security and reliability.Core taskTask 16111Rated by 21 occupational experts, August 2023
  15. Task 15. Develop load-balancing processes to eliminate down time for backup processes.Core taskTask 16107Rated by 21 occupational experts, August 2023
  16. Task 16. Plan and install upgrades of database management system software to enhance database performance.Core taskTask 16102Rated by 21 occupational experts, August 2023
  17. Task 17. Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.Core taskTask 16101Rated by 21 occupational experts, August 2023
  18. Task 18. Test programs or databases, correct errors, and make necessary modifications.Core taskTask 21657Rated by 21 occupational experts, August 2023
  19. Task 19. Identify and correct deviations from database development standards.Core taskTask 16104Rated by 21 occupational experts, August 2023
  20. Task 20. Review project requests describing database user needs to estimate time and cost required to accomplish project.Core taskTask 21656Rated by 21 occupational experts, August 2023
  21. Task 21. Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.Core taskTask 21660Rated by 21 occupational experts, August 2023
  22. Task 22. Develop or maintain archived procedures, procedural codes, or queries for applications.Core taskTask 16106Rated by 21 occupational experts, August 2023
  23. Task 23. Provide technical support to junior staff or clients.Core taskTask 16099Rated by 21 occupational experts, August 2023
  24. Task 24. Establish and calculate optimum values for database parameters, using manuals and calculators.Core taskTask 21654Rated by 21 occupational experts, August 2023
  25. Task 25. Train users and answer questions.Supplemental taskTask 21658Rated by 21 occupational experts, August 2023

Where this comes from

Quoted from the U.S. Department of Labor, and credited. Nothing on this page is written by us.

How we copy and credit sources
  1. Published by
    O*NET 29.0, U.S. Department of LaborEmployment and Training Administration
  2. Classification
    Standard Occupational Classification 2018, 15-1243
  3. License
    CC BY 4.0Free to copy and reuse, with credit
  4. Changed by us
    Nothing.

More in Computer & Mathematical

37 other occupations in this family, each with its own page.

Use this record

Every task on this page is free to reuse, with credit to O*NET. The code and data behind the record are public.

This record as JSONGitHub/llms.txt

Partner with us

Fund the next pass, contribute data, or build on the record. Tell us what you have in mind.

Partner with us