Database Architects
Every task in this role, whether it passes the census's structural hand-over screen, which models pass it, and why. It is a screen, not a claim about what AI can do: a task can pass and still be beyond the systems of the day. The stricter and looser rules re-vote every task, and small differences between roles are noise.
Passes the screen · 8 of 43 tasks
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
quick to check, an existing check settles it, and a mistake is cheap · 4.1% of the role's time · $367M · passed by Claude Sonnet, Gemini 3.1 Pro · the models disagreed
Map data between source systems, data warehouses, and data marts.
quick to check, an existing check settles it, and a mistake is cheap · 3.1% of the role's time · $280M · passed by Claude Sonnet, Gemini 3.1 Pro · the models disagreed
Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
quick to check, an existing check settles it, and a mistake is cheap · 2.4% of the role's time · $215M · passed by Claude Sonnet, Gemini 3.1 Pro · the models disagreed
Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
quick to check, an existing check settles it, and a mistake is cheap · 2.1% of the role's time · $189M · passed by Claude Sonnet, Gemini 3.1 Pro · the models disagreed
Test software systems or applications for software enhancements or new products.
quick to check, an existing check settles it, and a mistake is cheap · 1.7% of the role's time · $152M · passed by Claude Sonnet, Gemini 3.1 Pro · the models disagreed
Identify and correct deviations from database development standards.
quick to check, an existing check settles it, and a mistake is cheap · 1.5% of the role's time · $133M · passed by Claude Sonnet, Gemini 3.1 Pro · the models disagreed
Demonstrate database technical functionality, such as performance, security and reliability.
quick to check, an existing check settles it, and a mistake is cheap · 1.4% of the role's time · $128M · passed by Claude Sonnet, Gemini 3.1 Pro · the models disagreed
Establish and calculate optimum values for database parameters, using manuals and calculators.
quick to check, an existing check settles it, and a mistake is cheap · 0.8% of the role's time · $74.9M · passed by Claude Sonnet, Gemini 3.1 Pro · the models disagreed
Does not pass
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 4.2% of the role's time · $376M
Verify the structure, accuracy, or quality of warehouse data.
reason given most often: a failure is too expensive · 4.1% of the role's time · $370M · passed by Claude Sonnet · the models disagreed
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it, and a failure is too expensive · 4.0% of the role's time · $359M
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
reason given most often: nobody can tell quickly whether it worked, and a failure is too expensive · 3.8% of the role's time · $340M · passed by Gemini 3.1 Pro · the models disagreed
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it, and a failure is too expensive · 3.7% of the role's time · $336M
Implement business rules via stored procedures, middleware, or other technologies.
reason given most often: a failure is too expensive · 3.4% of the role's time · $305M · passed by Claude Sonnet · the models disagreed
Develop and document database architectures.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 3.4% of the role's time · $304M
Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it, and a failure is too expensive · 3.3% of the role's time · $298M
Provide or coordinate troubleshooting support for data warehouses.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it, and a failure is too expensive · 3.2% of the role's time · $292M
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 3.1% of the role's time · $283M
Design and implement warehouse database structures.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it, and a failure is too expensive · 3.1% of the role's time · $275M
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.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 3.0% of the role's time · $269M
Work as part of a project team to coordinate database development and determine project scope and limitations.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 2.8% of the role's time · $253M
Develop data model describing data elements and their use, following procedures and using pen, template or computer software.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 2.6% of the role's time · $231M · passed by Claude Sonnet · the models disagreed
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.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it, and a failure is too expensive · 2.5% of the role's time · $227M
Develop data models for applications, metadata tables, views or related database structures.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 2.3% of the role's time · $203M
Provide technical support to junior staff or clients.
reason given most often: no existing check settles it · 2.1% of the role's time · $193M
Review designs, codes, test plans, or documentation to ensure quality.
reason given most often: no existing check settles it · 2.1% of the role's time · $190M · waiting on a check
Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
reason given most often: no existing check settles it · 2.1% of the role's time · $187M · waiting on a check
Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
reason given most often: nobody can tell quickly whether it worked · 2.0% of the role's time · $179M
Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 2.0% of the role's time · $178M
Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 2.0% of the role's time · $176M
Test programs or databases, correct errors, and make necessary modifications.
reason given most often: a failure is too expensive · 1.8% of the role's time · $164M · passed by Claude Sonnet · the models disagreed
Create and enforce database development standards.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 1.8% of the role's time · $160M
Create or implement metadata processes and frameworks.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 1.8% of the role's time · $160M
Document and communicate database schemas, using accepted notations.
reason given most often: no existing check settles it · 1.7% of the role's time · $157M · passed by Claude Sonnet · the models disagreed · waiting on a check
Develop or maintain archived procedures, procedural codes, or queries for applications.
reason given most often: no existing check settles it · 1.7% of the role's time · $152M · passed by Gemini 3.1 Pro · the models disagreed
Prepare functional or technical documentation for data warehouses.
reason given most often: no existing check settles it · 1.6% of the role's time · $146M · waiting on a check
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.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 1.5% of the role's time · $137M
Select methods, techniques, or criteria for data warehousing evaluative procedures.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 1.4% of the role's time · $129M
Review project requests describing database user needs to estimate time and cost required to accomplish project.
reason given most often: nobody can tell quickly whether it worked, and no existing check settles it · 1.4% of the role's time · $125M
Set up database clusters, backup, or recovery processes.
reason given most often: a failure is too expensive · 1.0% of the role's time · $91.3M
Develop load-balancing processes to eliminate down time for backup processes.
reason given most often: a failure is too expensive · 1.0% of the role's time · $88.9M
Plan and install upgrades of database management system software to enhance database performance.
reason given most often: nobody can tell quickly whether it worked, and a failure is too expensive · 0.9% of the role's time · $79.7M
Train users and answer questions.
reason given most often: no existing check settles it · 0.7% of the role's time · $62.0M
Where this role works
| Industry | Workers | Wage bill | Passes the screen | All three pass |
|---|---|---|---|---|
| Computer Systems Design and Related Services | 16,230 | $2.5B | $428M | $0 |
| Management of Companies and Enterprises | 6710 | $927M | $158M | $0 |
| Management, Scientific, and Technical Consulting Services | 4140 | $577M | $98.5M | $0 |
| Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services | 3590 | $560M | $95.5M | $0 |
| Insurance Carriers | 3430 | $469M | $80.0M | $0 |
| Credit Intermediation and Related Activities (5221 and 5223 only) | 2760 | $407M | $69.4M | $0 |
| Employment Services | 2550 | $384M | $65.5M | $0 |
| Software Publishers | 2060 | $316M | $53.9M | $0 |
| Professional and Commercial Equipment and Supplies Merchant Wholesalers | 1710 | $241M | $41.2M | $0 |
| Agencies, Brokerages, and Other Insurance Related Activities | 1570 | $205M | $35.0M | $0 |