Computer and Mathematical · SOC 15-1243
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.
Will AI replace this job?
The data cannot say, and anyone who gives you a percentage for “replaced” is guessing. What it does show is a gap between three things, for the 43 tasks O*NET lists for this occupation:
Could an LLM do it?
30%–79%
of tasks: an LLM alone could do the task or cut its time by half. Human raters say 30%, GPT-4 says 79%.
Counting tasks that need extra software around the model: 98%–100%.
Is it happening?
27 of 43 tasks
show measurable use in Claude conversations (Anthropic Economic Index). Anthropic’s occupation score, which counts only tasks that were also rated feasible, is 58%. Observed is a subset of “could” by construction.
Claude only, mostly US users, sampled periods in 2025. Not all AI use, and not employment.
What is left?
0 of 43 tasks
were rated “no LLM speed-up” by every rater (so, by Anthropic’s method, they cannot show up as observed use either). That is the part of the job these studies see no sign of AI touching.
It does not mean those tasks are safe. It means these methods found nothing there.
Task by task
Sorted with the tasks seen in use first. The three coloured squares are the three raters, in this order: human raters, GPT-4, GPT-4 with an alternative rubric. “Usage score” is Anthropic’s published task_penetration value; 0 means none seen.
| Task (O*NET 31.0) | Could an LLM? | Claude usage score |
|---|---|---|
| Develop and document database architectures. | all raters | 0.83 |
| Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements. | all raters | 0.77 |
| Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements. | all raters | 0.74 |
| Develop data models for applications, metadata tables, views or related database structures. | all raters | 0.83 |
| 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. | all raters | 0.82 |
| Create and enforce database development standards. | all raters | 0.79 |
| Document and communicate database schemas, using accepted notations. | all raters | 0.89 |
| Plan and install upgrades of database management system software to enhance database performance. | all raters | 0.92 |
| Test programs or databases, correct errors, and make necessary modifications. | all raters | 0.98 |
| Develop or maintain archived procedures, procedural codes, or queries for applications. | all raters | 0.88 |
| Provide technical support to junior staff or clients. | all raters | 0.74 |
| Develop data warehouse process models, including sourcing, loading, transformation, and extraction. | all raters | 0.80 |
| Map data between source systems, data warehouses, and data marts. | all raters | 0.94 |
| Develop and implement data extraction procedures from other systems, such as administration, billing, or claims. | all raters | 0.91 |
| Design and implement warehouse database structures. | all raters | 0.87 |
| Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases. | all raters | 0.82 |
| Provide or coordinate troubleshooting support for data warehouses. | all raters | 0.85 |
| Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies. | all raters | 0.93 |
| Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements. | all raters | 0.82 |
| Perform system analysis, data analysis or programming, using a variety of computer languages and procedures. | all raters | 0.99 |
| Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. | all raters | 0.87 |
| Create or implement metadata processes and frameworks. | all raters | 0.94 |
| Select methods, techniques, or criteria for data warehousing evaluative procedures. | all raters | 0.88 |
| Implement business rules via stored procedures, middleware, or other technologies. | all raters | 0.98 |
| Prepare functional or technical documentation for data warehouses. | all raters | 0.78 |
| Demonstrate database technical functionality, such as performance, security and reliability. | 2 of 3 raters | 0.74 |
| Identify, evaluate and recommend hardware or software technologies to achieve desired database performance. | 2 of 3 raters | 0.73 |
| Design databases to support business applications, ensuring system scalability, security, performance, and reliability. | all raters | none seen |
| Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs. | all raters | none seen |
| Develop data model describing data elements and their use, following procedures and using pen, template or computer software. | all raters | none seen |
Show the other 13 tasks
| Work as part of a project team to coordinate database development and determine project scope and limitations. | all raters | none seen |
| Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management. | all raters | none seen |
| Set up database clusters, backup, or recovery processes. | all raters | none seen |
| Develop load-balancing processes to eliminate down time for backup processes. | all raters | none seen |
| Identify and correct deviations from database development standards. | all raters | none seen |
| Review project requests describing database user needs to estimate time and cost required to accomplish project. | all raters | none seen |
| Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions. | all raters | none seen |
| Establish and calculate optimum values for database parameters, using manuals and calculators. | all raters | n/a |
| Verify the structure, accuracy, or quality of warehouse data. | all raters | none seen |
| Review designs, codes, test plans, or documentation to ensure quality. | all raters | none seen |
| Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing. | all raters | none seen |
| Test software systems or applications for software enhancements or new products. | all raters | none seen |
| Train users and answer questions. (supplemental) | all raters | none seen |
Try it with your own task list
Sources: task list from O*NET® Database (U.S. Department of Labor, CC BY 4.0; modified by noworkleft.com); “could” labels from Eloundou et al., GPTs are GPTs (OpenAI/University of Pennsylvania, MIT licence, labels from early-2023 models); “seen in use” from the Anthropic Economic Index (Claude usage only, CC BY). Dates, versions and limits.
Other jobs in Computer and Mathematical
- Computer Programmers (75% observed)
- Software Quality Assurance Analysts and Testers (52% observed)
- Information Security Analysts (49% observed)
- Web Developers (48% observed)
- Mathematical Science Occupations, All Other (48% observed)
- Computer User Support Specialists (47% observed)
- Data Scientists (46% observed)
- Operations Research Analysts (43% observed)
Data built 2026-11-06. O*NET 31.0. Task match rates: 99.4% with the OpenAI/Penn labels, 99.2% with Anthropic usage.