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.
- O*NET-SOC code
15-1243.00 - Preparation Job Zone Four: Considerable Preparation Needed
Wages
| 10th | 25th | Median | 75th | 90th |
|---|---|---|---|---|
| $86,240 | $109,370 | $139,500 | $169,290 | $204,000 |
By state (49)
| State | Employment | Median annual | Location quotient |
|---|---|---|---|
| Alabama | 270 | $105,450 | 0.29 |
| Alaska | 70 | $112,500 | 0.53 |
| Arizona | 1,200 | $156,100 | 0.86 |
| Arkansas | 360 | $104,070 | 0.63 |
| California | 6,210 | $170,160 | 0.79 |
| Colorado | 1,950 | $154,560 | 1.57 |
| Connecticut | 1,140 | $144,460 | 1.55 |
| Delaware | $147,800 | ||
| District of Columbia | 790 | $150,010 | 2.61 |
| Florida | 1,810 | $138,320 | 0.42 |
| Georgia | 2,590 | $139,500 | 1.23 |
| Hawaii | 60 | $134,040 | 0.22 |
| Idaho | 260 | $121,380 | 0.69 |
| Illinois | 1,590 | $142,500 | 0.60 |
| Indiana | 500 | $132,830 | 0.36 |
| Iowa | 240 | $124,040 | 0.36 |
| Kansas | 360 | $129,990 | 0.57 |
| Kentucky | 350 | $125,400 | 0.40 |
| Maine | 190 | $133,120 | 0.69 |
| Maryland | 1,370 | $132,940 | 1.14 |
| Massachusetts | 2,690 | $161,650 | 1.71 |
| Michigan | 1,390 | $131,000 | 0.73 |
| Minnesota | 1,240 | $133,050 | 0.98 |
| Mississippi | 100 | $98,420 | 0.20 |
| Missouri | 1,410 | $110,570 | 1.11 |
| Montana | $109,990 | ||
| Nebraska | 610 | $134,320 | 1.39 |
| Nevada | 420 | $140,200 | 0.63 |
| New Hampshire | 120 | $139,990 | 0.40 |
| New Jersey | 3,090 | $120,790 | 1.67 |
| New Mexico | 120 | $117,950 | 0.32 |
| New York | 3,850 | $141,350 | 0.92 |
| North Carolina | 4,070 | $134,630 | 1.91 |
| North Dakota | 60 | $109,430 | 0.30 |
| Ohio | 1,820 | $132,910 | 0.76 |
| Oklahoma | 860 | $110,110 | 1.17 |
| Oregon | 730 | $138,250 | 0.86 |
| Pennsylvania | 2,840 | Not available | 1.09 |
| Rhode Island | 160 | $140,320 | 0.72 |
| South Carolina | 1,160 | $130,000 | 1.16 |
| South Dakota | 40 | $136,540 | 0.20 |
| Tennessee | 650 | $115,170 | 0.46 |
| Texas | 8,270 | $151,370 | 1.36 |
| Utah | 630 | $131,740 | 0.84 |
| Virginia | 5,260 | $160,360 | 2.96 |
| Washington | 2,990 | $128,760 | 1.95 |
| West Virginia | 120 | Not available | 0.40 |
| Wisconsin | 520 | $137,810 | 0.41 |
| Wyoming | 160 | Not available | 1.35 |
Similar occupations
Similarity is our measure: the cosine of importance x level over all 120 O*NET skills, knowledge areas and abilities. It is not an O*NET finding. More.
Circles are the 20 most similar occupations, coloured by Job Zone. Lines join pairs where one is among the other's 10 most similar; darker lines are pairs O*NET also lists as related. Drag a circle to move it out of the way; select one to open it.
| # | Occupation | Job Zone | Similarity |
|---|---|---|---|
| 1 | Computer and Information Research Scientists | 5 | 0.976 |
| 2 | Blockchain Engineers | 4 | 0.976 |
| 3 | Data Warehousing Specialists | 4 | 0.975 |
| 4 | Database Administrators | 4 | 0.975 |
| 5 | Software Quality Assurance Analysts and Testers | 4 | 0.970 |
| 6 | Web Developers | 3 | 0.965 |
| 7 | Computer Systems Engineers/Architects | 3 | 0.963 |
| 8 | Computer Network Architects | 4 | 0.963 |
| 9 | Computer Programmers | 4 | 0.962 |
| 10 | Computer Hardware Engineers | 4 | 0.961 |
One skill away
Among the 50 occupations most similar to Database Architects, those at the same Job Zone or lower, where exactly one skill rated at least 3 in importance needs a level more than 0.75 points higher (on O*NET's 0-7 level scale). Our definition. Change the thresholds.
| Occupation | Skill to build | Level gap | Similarity |
|---|---|---|---|
| Software Quality Assurance Analysts and Testers | Quality Control Analysis | 1.74 | 0.970 |
| Computer Hardware Engineers | Operations Monitoring | 0.88 | 0.961 |
| Information Security Engineers | Operations Monitoring | 1.00 | 0.961 |
| Web Administrators | Quality Control Analysis | 1.50 | 0.950 |
| Business Intelligence Analysts | Mathematics | 0.76 | 0.944 |
| Penetration Testers | Quality Control Analysis | 1.50 | 0.944 |
| Clinical Data Managers | Mathematics | 0.76 | 0.941 |
Software to learn next
Software used by at least 3 of the 20 occupations most similar to Database Architects, excluding software Database Architects already lists and any you named. Ranked by how many of them use it, weighted by how much more common it is among them than across all occupations (lift). Our ranking.
| Software | Similar jobs using it | Lift |
|---|---|---|
| Objective C | 10 of 20 | 25.6x |
| Oracle E-Business Suite Financials | 11 of 20 | 11.3x |
| Adobe ActionScript | 10 of 20 | 14.0x |
| Verilog | 9 of 20 | 17.3x |
| Adobe Flex | 7 of 20 | 35.9x |
| IBM Terraform | 7 of 20 | 32.3x |
| Human resource management software HRMS | 10 of 20 | 10.5x |
| Firewall software | 8 of 20 | 18.5x |
| National Instruments LabVIEW | 11 of 20 | 8.2x |
| IBM Rational Rose XDE | 6 of 20 | 39.6x |
Skills
From O*NET data. Importance is rated 1 to 5 and level 0 to 7.
| Skill | Type | Importance | Level |
|---|---|---|---|
| Reading Comprehension | Essential skill | 3.88 | 4.12 |
| Complex Problem Solving | Transferable skill | 3.88 | 4.00 |
| Critical Thinking | Essential skill | 3.88 | 3.88 |
| Judgment and Decision Making | Transferable skill | 3.88 | 3.88 |
| Systems Analysis | Transferable skill | 3.75 | 3.75 |
| Speaking | Essential skill | 3.50 | 3.88 |
| Active Listening | Essential skill | 3.50 | 3.75 |
| Programming | Transferable skill | 3.38 | 4.12 |
| Systems Evaluation | Transferable skill | 3.25 | 3.75 |
| Active Learning | Essential skill | 3.25 | 3.62 |
| Writing | Essential skill | 3.12 | 3.88 |
| Monitoring | Essential skill | 3.12 | 3.62 |
| Operations Analysis | Transferable skill | 3.12 | 3.38 |
| Coordination | Transferable skill | 3.00 | 3.12 |
| Mathematics | Essential skill | 3.00 | 3.12 |
| Service Orientation | Transferable skill | 3.00 | 3.00 |
| Social Perceptiveness | Transferable skill | 3.00 | 3.00 |
| Technology Design | Transferable skill | 3.00 | 3.00 |
| Time Management | Transferable skill | 3.00 | 3.00 |
| Instructing | Transferable skill | 2.88 | 3.62 |
| Learning Strategies | Essential skill | 2.88 | 3.00 |
| Persuasion | Transferable skill | 2.88 | 3.00 |
| Negotiation | Transferable skill | 2.62 | 2.88 |
| Management of Personnel Resources | Transferable skill | 2.50 | 2.75 |
| Operations Monitoring | Transferable skill | 2.12 | 2.12 |
| Quality Control Analysis | Transferable skill | 2.00 | 1.88 |
| Management of Financial Resources | Transferable skill | 2.00 | 1.25 |
| Management of Material Resources | Transferable skill | 2.00 | 1.25 |
| Troubleshooting | Transferable skill | 1.88 | 2.12 |
| Science | Essential skill | 1.88 | 1.75 |
| Operation and Control | Transferable skill | 1.75 | 1.38 |
| Equipment Selection | Transferable skill | 1.62 | 0.75 |
| Installation | Transferable skill | 1.62 | 0.75 |
| Equipment Maintenance | Transferable skill | 1.12 | not rated |
| Repairing | Transferable skill | 1.12 | not rated |
Knowledge (33) and abilities (52)
| Name | Importance | Level |
|---|---|---|
| Computers and Electronics | 4.30 | 6.00 |
| Engineering and Technology | 3.95 | 5.19 |
| Design | 3.71 | 4.67 |
| Mathematics | 3.67 | 4.81 |
| English Language | 3.14 | 4.00 |
| Administration and Management | 2.86 | 4.10 |
| Education and Training | 2.62 | 4.19 |
| Customer and Personal Service | 2.33 | 3.10 |
| Law and Government | 2.24 | 2.67 |
| Telecommunications | 2.05 | 2.24 |
| Communications and Media | 2.00 | 2.14 |
| Production and Processing | 2.00 | 2.05 |
| Public Safety and Security | 1.95 | 2.24 |
| Economics and Accounting | 1.86 | 1.81 |
| Administrative | 1.81 | 2.29 |
| Personnel and Human Resources | 1.76 | 2.29 |
| Psychology | 1.67 | 1.57 |
| Geography | 1.65 | 1.80 |
| Sales and Marketing | 1.62 | 1.67 |
| Foreign Language | 1.38 | 0.75 |
| Sociology and Anthropology | 1.33 | 0.95 |
| Physics | 1.25 | not rated |
| Transportation | 1.24 | not rated |
| Chemistry | 1.19 | not rated |
| Mechanical | 1.19 | not rated |
| Therapy and Counseling | 1.15 | not rated |
| Fine Arts | 1.14 | not rated |
| History and Archeology | 1.14 | not rated |
| Medicine and Dentistry | 1.14 | not rated |
| Biology | 1.10 | not rated |
| Building and Construction | 1.10 | not rated |
| Philosophy and Theology | 1.10 | not rated |
| Food Production | 1.05 | not rated |
| Name | Importance | Level |
|---|---|---|
| Oral Comprehension | 3.88 | 4.50 |
| Deductive Reasoning | 3.88 | 4.38 |
| Written Comprehension | 3.88 | 4.00 |
| Information Ordering | 3.75 | 4.12 |
| Inductive Reasoning | 3.75 | 4.00 |
| Oral Expression | 3.75 | 4.00 |
| Problem Sensitivity | 3.75 | 3.88 |
| Near Vision | 3.62 | 4.00 |
| Speech Clarity | 3.62 | 3.00 |
| Category Flexibility | 3.38 | 3.62 |
| Written Expression | 3.25 | 3.88 |
| Fluency of Ideas | 3.25 | 3.75 |
| Flexibility of Closure | 3.25 | 3.12 |
| Selective Attention | 3.25 | 3.00 |
| Mathematical Reasoning | 3.12 | 3.25 |
| Number Facility | 3.12 | 3.12 |
| Perceptual Speed | 3.12 | 3.00 |
| Originality | 3.00 | 3.88 |
| Speech Recognition | 3.00 | 3.00 |
| Visualization | 2.88 | 3.00 |
| Speed of Closure | 2.75 | 2.88 |
| Memorization | 2.50 | 2.38 |
| Far Vision | 2.38 | 2.50 |
| Time Sharing | 2.00 | 2.12 |
| Hearing Sensitivity | 2.00 | 1.75 |
| Visual Color Discrimination | 2.00 | 1.50 |
| Auditory Attention | 2.00 | 1.25 |
| Depth Perception | 2.00 | 1.12 |
| Trunk Strength | 1.88 | 1.50 |
| Wrist-Finger Speed | 1.88 | 1.50 |
| Arm-Hand Steadiness | 1.88 | 1.12 |
| Finger Dexterity | 1.88 | 1.12 |
| Manual Dexterity | 1.88 | 1.12 |
| Control Precision | 1.88 | 1.00 |
| Dynamic Strength | 1.25 | not rated |
| Dynamic Flexibility | 1.00 | not rated |
| Explosive Strength | 1.00 | not rated |
| Extent Flexibility | 1.00 | not rated |
| Glare Sensitivity | 1.00 | not rated |
| Gross Body Coordination | 1.00 | not rated |
| Gross Body Equilibrium | 1.00 | not rated |
| Multilimb Coordination | 1.00 | not rated |
| Night Vision | 1.00 | not rated |
| Peripheral Vision | 1.00 | not rated |
| Rate Control | 1.00 | not rated |
| Reaction Time | 1.00 | not rated |
| Response Orientation | 1.00 | not rated |
| Sound Localization | 1.00 | not rated |
| Spatial Orientation | 1.00 | not rated |
| Speed of Limb Movement | 1.00 | not rated |
| Stamina | 1.00 | not rated |
| Static Strength | 1.00 | not rated |
Software used
Examples from O*NET data. "Hot" and "in demand" are O*NET flags for technologies often listed in job postings.
- Amazon Web Services AWS software in demand
- Apache Kafka in demand
- Apache Spark in demand
- Microsoft Azure software in demand
- Microsoft Excel in demand
- Microsoft Office software in demand
- Microsoft Power BI in demand
- Microsoft PowerPoint in demand
- Oracle Java in demand
- Python in demand
- Snowflake in demand
- Structured query language SQL in demand
- Tableau in demand
- AJAX hot
- Adobe Acrobat hot
- Amazon DynamoDB hot
- Amazon Elastic Compute Cloud EC2 hot
- Amazon Redshift hot
- Amazon Web Services AWS CloudFormation hot
- Ansible software hot
- Apache Airflow hot
- Apache Cassandra hot
- Apache Hadoop hot
- Apache Hive hot
- Apache Maven hot
- Apache Subversion SVN hot
- Apache Tomcat hot
- Apple macOS hot
- Atlassian Confluence hot
- Atlassian JIRA hot
All 322
- Autodesk Revit hot
- Bash hot
- C hot
- C# hot
- C++ hot
- Cascading style sheets CSS hot
- Chef hot
- Cisco Webex hot
- Django hot
- Docker hot
- ESRI ArcGIS software hot
- Eclipse IDE hot
- Elasticsearch hot
- Epic Systems hot
- Extensible markup language XML hot
- Git hot
- GitHub hot
- Go hot
- Google Analytics hot
- Google Angular hot
- Google Docs hot
- Hibernate ORM hot
- Hypertext markup language HTML hot
- IBM DB2 hot
- IBM SPSS Statistics hot
- Informatica software hot
- JUnit hot
- JavaScript hot
- JavaScript Object Notation JSON hot
- Linux hot
- Microsoft .NET Framework hot
- Microsoft ASP.NET hot
- Microsoft Access hot
- Microsoft Active Server Pages ASP hot
- Microsoft Outlook hot
- Microsoft PowerShell hot
- Microsoft Project hot
- Microsoft SQL Server hot
- Microsoft SQL Server Integration Services SSIS hot
- Microsoft SQL Server Reporting Services SSRS hot
- Microsoft SharePoint hot
- Microsoft Visio hot
- Microsoft Visual Basic hot
- Microsoft Visual Basic for Applications VBA hot
- Microsoft Visual Studio hot
- Microsoft Windows hot
- Microsoft Windows Server hot
- Microsoft Word hot
- MongoDB hot
- MySQL hot
- NoSQL hot
- Node.js hot
- Oracle Database hot
- Oracle PL/SQL hot
- Oracle PeopleSoft hot
- Oracle Primavera Enterprise Project Portfolio Management hot
- Oracle SQL Developer hot
- PHP hot
- Perl hot
- PostgreSQL hot
- Puppet hot
- R hot
- React hot
- Red Hat Enterprise Linux hot
- Red Hat OpenShift hot
- Ruby hot
- SAP software hot
- SAS hot
- Salesforce software hot
- Scala hot
- Selenium hot
- Shell script hot
- Splunk Enterprise hot
- Spring Boot hot
- Spring Framework hot
- Swift hot
- Teradata Database hot
- The MathWorks MATLAB hot
- Transact-SQL hot
- UNIX hot
- UNIX Shell hot
- jQuery hot
- 3M Post-it App
- ADO.NET
- ASG Technologies ASG-Zeke
- Ab Initio
- Access management software
- Acronis Recovery Expert
- Adeptia ETL Suite
- Adobe Dreamweaver
- Advanced business application programming ABAP
- Altova MapForce
- Amazon Kinesis
- Amazon Simple Storage Service S3
- Apache Ant
- Apache Avro
- Apache Flume
- Apache Groovy
- Apache HBase
- Apache HTTP Server
- Apache Mahout
- Apache Oozie
- Apache Pig
- Apache Solr
- Apache Sqoop
- Apache Struts
- Apatar
- Atlassian Bamboo
- BMC Software Change Manager
- BMC Software Control-M
- BMC Software Recovery Manager RMAN
- Backbone.js
- Blackbaud The Raiser's Edge
- Blackboard software
- C shell
- CA Easytrieve Report Generator
- CA IDMS
- CA Technologies ERWin Data Modeler
- Catalog navigation software
- Cisco IOS
- Citrix cloud computing software
- Cloudera Impala
- CloverETL
- Cluster server software
- Coglin Mill RODIN
- Common business oriented language COBOL
- Computer Associates Log Analyzer
- Concurrency control software
- Couchbase Server
- Customer information control system CICS
- DOS shell script
- Data Recovery Software SQL Server Data Recovery
- Data definition language DDL
- Data dictionary software
- Data manipulation language DML
- Data mapping software
- Data modeling software
- Data transformation services DTS software
- Data validation software
- Database capacity planning software
- Database cloning software
- Database design software
- Database management systems
- Database security software
- Database testing software
- Deployment software
- Drupal
- Dynamic hypertext markup language DHTML
- EMC NetWorker
- Ellucian Banner ERP
- Embarcadero Technologies DBArtisan
- Encryption software
- Enterprise JavaBeans
- Ext JS
- Extensible hypertext markup language XHTML
- FileMaker Pro
- Flat File Checker
- Geographic information system GIS software
- Google Drive
- Google Meet
- Google Sites
- Greenplum Database
- HP DataProtector
- Hewlett Packard HP-UX
- Hewlett Packard LoadRunner
- HiT Software Allora
- IBM ADSTAR
- IBM AIX
- IBM Cognos Impromptu
- IBM Content Manager
- IBM Domino
- IBM InfoSphere DataStage
- IBM InfoSphere Warehouse
- IBM Informix
- IBM Interactive System Productivity Facility ISPF
- IBM Notes
- IBM Power Systems software
- IBM Rational Data Architect
- IBM Rational System Architect
- IBM WebSphere
- Index tuning software
- Infobright Community Edition ICE
- Informatica Big Data
- Informatica Corporation PowerCenter
- Informatica PowerCenter
- Integrated development environment IDE software
- Intel Data Migration Software
- Interface Computers Data Loader
- Jitterbit
- Job control language JCL
- Jupyter Notebook
- KornShell
- LAMP Stack
- LexisNexis
- LogMeIn GoToMeeting
- LogMeIn GoToWebinar
- MapR Converged Data Platform
- MariaDB
- McAfee
- Micosoft SQL Server Analysis Services SSAS
- MicroStrategy
- Microsoft ASP.NET Core MVC
- Microsoft ActiveX
- Microsoft Dynamics
- Microsoft Dynamics GP
- Microsoft Exchange
- Microsoft Publisher
- Microsoft Visual Basic Scripting Edition VBScript
- Microsoft Visual Basic.NET
- Microsoft Visual C# .NET
- Minitab
- Multidimensional Expressions MDX
- Nagios
- Nearpod
- NetSuite ERP
- NortonLifeLock cybersecurity software
- Object database management system ODBMS
- Oracle Application Express APEX
- Oracle Application Server
- Oracle Business Intelligence Enterprise Edition
- Oracle Data Guard
- Oracle Data Integrator
- Oracle Designer
- Oracle Eloqua
- Oracle Enterprise Manager
- Oracle Enterprise Manager Cloud Control
- Oracle Fusion Applications
- Oracle Fusion Middleware
- Oracle Golden Gate
- Oracle Hyperion
- Oracle JD Edwards EnterpriseOne
- Oracle JDBC
- Oracle JavaServer Pages JSP
- Oracle Jdeveloper
- Oracle Migration Workbench
- Oracle PeopleSoft Financials
- Oracle Real Application Cluster RAC
- Oracle Recovery Manager
- Oracle Reports
- Oracle SQL Loader
- Oracle SQL Plus
- Oracle Solaris
- Oracle WebLogic Server
- Pentaho Kettle
- Perforce Helix software
- Perl shell
- Prolog
- Qlik Tech QlikView
- Quest Central
- Quest Erwin Data Modeler
- Quest SQL Optimizer for Oracle
- Quest SharePlex
- Rapid-I RapidMiner
- ReCrystallize Crystal Reports
- Red Hat Ansible Engine
- Red Hat WildFly
- Redgate SQL Server
- Relational database management software
- Relational database management system software
- Restructured extended executor REXX
- Ruby on Rails
- SAP Adaptive Server Enterprise
- SAP Business Objects
- SAP Crystal Reports
- SAP PowerBuilder
- SAP PowerDesigner
- SAP Replication Server
- SAS Data Integration Studio
- SMSi Twister Data Integrator
- Safe Software FME
- Scriptella
- SentryOne SQL Sentry
- Skype
- SolarWinds
- StataCorp Stata
- Storage area network SAN software
- Storage management software
- Systems and data disaster recovery software
- Talend Big Data Integration
- Talend Data Fabric
- Talend Open Studio
- Teradata Active Enterprise Data Warehouse
- Test data generator software
- Ubuntu
- Unified modeling language UML
- VMware
- Veritas NetBackup
- Virtual private networking VPN software
- Visual Paradigm DB Visual ARCHITECT
- Wireshark
- WisdomForce DatabaseSync System
- Zabbix
Where it concentrates
Metro areas ranked by BLS location quotient: the occupation's share of the area's jobs divided by its share of all US jobs. Above 1 means more concentrated than the nation. Metros employing fewer than 100 are left out.
| Metro area | Employment | Location quotient | Median annual |
|---|---|---|---|
| Cheyenne, WY | 110 | 5.12 | $67,630 |
| Olympia-Lacey-Tumwater, WA | 210 | 3.82 | $133,500 |
| Durham-Chapel Hill, NC | 560 | 3.78 | $141,770 |
| Washington-Arlington-Alexandria, DC-VA-MD-WV | 4,740 | 3.50 | $162,870 |
| Seattle-Tacoma-Bellevue, WA | 2,500 | 2.77 | $105,430 |
| Charlotte-Concord-Gastonia, NC-SC | 1,560 | 2.66 | $138,870 |
| Dallas-Fort Worth-Arlington, TX | 4,320 | 2.47 | $154,770 |
| San Jose-Sunnyvale-Santa Clara, CA | 1,120 | 2.29 | $197,960 |
| Omaha, NE-IA | 490 | 2.27 | $136,620 |
| Raleigh-Cary, NC | 710 | 2.21 | $132,740 |