15-1243.00 · Task explorer
Database Architects: reported tasks and exploration worksheet
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.
Use the skill profile to plan your next practice →
Read the task inventory
This source lists 25 tasks, including 24 marked Core and 1 marked Supplemental. Labels and dates are retained below. Employers can combine or divide these responsibilities differently; explore the task itself before assuming it belongs in every version of the role.
Task source dates: 08/2023.
25 tasks shown
Core · Task 16115 · 08/2023 · Occupational Expert
Develop and document database architectures.
Core · Task 16113 · 08/2023 · Occupational Expert
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
Core · Task 16114 · 08/2023 · Occupational Expert
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
Core · Task 16109 · 08/2023 · Occupational Expert
Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
Core · Task 16108 · 08/2023 · Occupational Expert
Develop data models for applications, metadata tables, views or related database structures.
Core · Task 16110 · 08/2023 · Occupational Expert
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 21653 · 08/2023 · Occupational Expert
Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
Core · Task 16112 · 08/2023 · Occupational Expert
Create and enforce database development standards.
Core · Task 16105 · 08/2023 · Occupational Expert
Document and communicate database schemas, using accepted notations.
Core · Task 21652 · 08/2023 · Occupational Expert
Develop data model describing data elements and their use, following procedures and using pen, template or computer software.
Core · Task 21659 · 08/2023 · Occupational Expert
Work as part of a project team to coordinate database development and determine project scope and limitations.
Core · Task 21655 · 08/2023 · Occupational Expert
Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
Core · Task 16100 · 08/2023 · Occupational Expert
Set up database clusters, backup, or recovery processes.
Core · Task 16111 · 08/2023 · Occupational Expert
Demonstrate database technical functionality, such as performance, security and reliability.
Core · Task 16107 · 08/2023 · Occupational Expert
Develop load-balancing processes to eliminate down time for backup processes.
Core · Task 16102 · 08/2023 · Occupational Expert
Plan and install upgrades of database management system software to enhance database performance.
Core · Task 16101 · 08/2023 · Occupational Expert
Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
Core · Task 21657 · 08/2023 · Occupational Expert
Test programs or databases, correct errors, and make necessary modifications.
Core · Task 16104 · 08/2023 · Occupational Expert
Identify and correct deviations from database development standards.
Core · Task 21656 · 08/2023 · Occupational Expert
Review project requests describing database user needs to estimate time and cost required to accomplish project.
Core · Task 21660 · 08/2023 · Occupational Expert
Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
Core · Task 16106 · 08/2023 · Occupational Expert
Develop or maintain archived procedures, procedural codes, or queries for applications.
Core · Task 16099 · 08/2023 · Occupational Expert
Provide technical support to junior staff or clients.
Core · Task 21654 · 08/2023 · Occupational Expert
Establish and calculate optimum values for database parameters, using manuals and calculators.
Supplemental · Task 21658 · 08/2023 · Occupational Expert
Train users and answer questions.
Make the shortlist useful
- Choose one to three activities that tell you something different about the work. Avoid selecting several ways of describing the same interest.
- For each, write an example you can discuss or a question that would change your understanding of the role.
- Keep source task IDs with your notes so you can return to the same description. Do not include private employer or customer information.
The exported worksheet distinguishes the reported task from your own notes. It supports exploration, not a hiring decision or a validated assessment.
Keep your worksheet
Download before leaving this page. Unsaved writing remains only in the page and is cleared on refresh. Notes and learning actions are not sent to a server. This guide describes an occupation and supports study planning; it does not provide clinical, legal or equipment-operating procedures.
Source and practice material
Occupational context uses the O*NET® 31.0 Database from the U.S. Department of Labor, Employment and Training Administration, under CC BY 4.0. View the occupation.
Skill Workbench selected and adapted the occupational information and added its own fictional cases, calculations, guidance and worksheets. USDOL/ETA has not approved, endorsed or tested these additions. O*NET® is a trademark of USDOL/ETA.