Occupation Summary

Database Architects

O*NET 15-1243.00

Description:

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.

Annual Wages:
$139,570.00
Employment Rate:
Employment is expected to increase by 32.93%.
Education Level:
Bachelor's Degree. According to O*Net, the majority of people employed in this occupation have this level of education.
Endorsement:
Business and Industry, Science Technology Engineering and Math (STEM)

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


National Industry Employment Patterns


Industry % of Database Architects employed Annual Growth Rate
Computer systems design and related services 35.6 1.32
Insurance carriers 6.3 0.48
Employment services 4.5 0.00
Management, scientific, and technical consulting services 4.5 0.99
Software publishers 4.1 1.44
Professional and commercial equipment and supplies merchant wholesalers 2.3 0.00


Labor Market Information


2023 Statewide average hourly wage $67.10
2023 National average hourly wage $65.88
2022 National employment 64,000
2022 Texas employment 6,311
Texas projected employment by 2032 8,389
Texas projected annual employment and Turnover openings through 2032 630




TEXAS COUNTY MAP BY WORKFORCE DEVELOPMENT AREA
* Due to confidentiality rules, not all regions may have the data displayed. The sum of all the regions may not be equal to the state total.


Top 10 Relevant Knowledge Areas Relevant Importance Levels
Computers and Electronics
Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
86.00%
Engineering and Technology
Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
79.00%
Design
Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
74.20%
Mathematics
Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
73.40%
English Language
Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
62.80%
Administration and Management
Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
57.20%
Education and Training
Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.
52.40%
Customer and Personal Service
Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
46.60%
Law and Government
Knowledge of laws, legal codes, court procedures, precedents, government regulations, executive orders, agency rules, and the democratic political process.
44.80%
Telecommunications
Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.
41.00%


Top 10 Relevant Skill Areas Relevant Importance Levels
Reading Comprehension
Understanding written sentences and paragraphs in work-related documents.
77.60%
Critical Thinking
Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
77.60%
Complex Problem Solving
Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
77.60%
Judgment and Decision Making
Considering the relative costs and benefits of potential actions to choose the most appropriate one.
77.60%
Systems Analysis
Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
75.00%
Active Listening
Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
70.00%
Speaking
Talking to others to convey information effectively.
70.00%
Programming
Writing computer programs for various purposes.
67.60%
Systems Evaluation
Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
65.00%
Active Learning
Understanding the implications of new information for both current and future problem-solving and decision-making.
65.00%


Top 10 Relevant Abilities Relevant Importance Levels
Oral Comprehension
The ability to listen to and understand information and ideas presented through spoken words and sentences.
77.60%
Written Comprehension
The ability to read and understand information and ideas presented in writing.
77.60%
Deductive Reasoning
The ability to apply general rules to specific problems to produce answers that make sense.
77.60%
Inductive Reasoning
The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
75.00%
Information Ordering
The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
75.00%
Oral Expression
The ability to communicate information and ideas in speaking so others will understand.
75.00%
Problem Sensitivity
The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing that there is a problem.
75.00%
Near Vision
The ability to see details at close range (within a few feet of the observer).
72.40%
Speech Clarity
The ability to speak clearly so others can understand you.
72.40%
Category Flexibility
The ability to generate or use different sets of rules for combining or grouping things in different ways.
67.60%


  • Working with Computers
    -- Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
  • Analyzing Data or Information
    -- Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
  • Getting Information
    -- Observing, receiving, and otherwise obtaining information from all relevant sources.
  • Processing Information
    -- Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
  • Making Decisions and Solving Problems
    -- Analyzing information and evaluating results to choose the best solution and solve problems.
Other Activities


  • Achievement
    - Occupations that satisfy this work value are results oriented and allow employees to use their strongest abilities, giving them a feeling of accomplishment. Corresponding needs are Ability Utilization and Achievement.
  • Working Conditions
    - Occupations that satisfy this work value offer job security and good working conditions. Corresponding needs are Activity, Compensation, Independence, Security, Variety and Working Conditions.



Tools

Desktop computers: Desktop computers;

Hard disk arrays: Redundant array of independent disks RAID systems;

Hard disk drives: Hard disk drives;

Laser fax machine: Laser facsimile machines;

Mainframe computers: Mainframe computers;

Notebook computers: Notebook computers;

Personal computers: Personal computers;

Photocopiers: Copy machines;

Server load balancer: Load balancers;

Tape arrays: Tape libraries;


Technology

Access software: Access management software; Citrix cloud computing software;

Administration software: Redgate SQL Server;

Analytical or scientific software: Safe Software FME; SAS; Minitab; IBM SPSS Statistics; Infobright Community Edition ICE; StataCorp Stata; Test data generator software; The MathWorks MATLAB;

Application server software: Spring Boot; GitHub; Docker; Application server software; Oracle Application Server; Red Hat OpenShift; Red Hat WildFly; Oracle WebLogic Server;

Backup or archival software: Oracle Recovery Manager; Oracle Data Guard; BMC Software Recovery Manager RMAN; Acronis Recovery Expert; EMC NetWorker; Data Recovery Software SQL Server Data Recovery; Database cloning software; HP DataProtector; IBM ADSTAR; Storage management software; Systems and data disaster recovery software; Veritas NetBackup;

Business intelligence and data analysis software: Tableau; IBM Cognos Impromptu; Oracle Business Intelligence Enterprise Edition; MicroStrategy; Micosoft SQL Server Analysis Services SSAS; Microsoft Power BI; Qlik Tech QlikView;

Cloud-based data access and sharing software: Microsoft SharePoint; Google Drive;

Cloud-based management software: IBM WebSphere; Amazon Web Services AWS CloudFormation; Jitterbit; Splunk Enterprise;

Cloud-based protection or security software: SolarWinds;

Clustering software: VMware; Oracle Real Application Cluster RAC; Cluster server software;

Communications server software: IBM Domino;

Computer aided design CAD software: Autodesk Revit;

Configuration management software: Chef; Deployment software; Perforce Helix software; Puppet; Red Hat Ansible Engine;

Content workflow software: Atlassian JIRA;

Customer relationship management CRM software: Blackbaud The Raiser's Edge; Salesforce software; Oracle Eloqua;

Data base management system software: Oracle Enterprise Manager; Oracle Enterprise Manager Cloud Control; Oracle Golden Gate; Oracle Migration Workbench; Oracle PL/SQL; SAP Adaptive Server Enterprise; SAP Replication Server; SentryOne SQL Sentry; Relational database management software; Relational database management system software; Quest Central; Quest SharePlex; MapR Converged Data Platform; MariaDB; MongoDB; Multidimensional Expressions MDX; MySQL; NoSQL; BMC Software Change Manager; CA IDMS; Catalog navigation software; Amazon DynamoDB; Amazon Kinesis; ADO.NET; Apache Hadoop; Apache HBase; Apache Cassandra; Apache Flume; Apache Oozie; Apache Pig; Apache Solr; Apache Sqoop; Data manipulation language DML; Database design software; Database management systems; Data transformation services DTS software; Concurrency control software; Couchbase Server; Data definition language DDL; Elasticsearch; Embarcadero Technologies DBArtisan; IBM Interactive System Productivity Facility ISPF; Index tuning software; Informatica Big Data; Greenplum Database; Teradata Database; Talend Big Data Integration;

Data base reporting software: ASG Technologies ASG-Zeke; Microsoft SQL Server Reporting Services SSRS; ReCrystallize Crystal Reports; SAP Crystal Reports; Oracle Reports; Oracle SQL Loader; Oracle SQL Plus;

Data base user interface and query software: Oracle JDBC; Oracle Database; Microsoft SQL Server; Microsoft Access; Blackboard software; Cloudera Impala; Apache Hive; Amazon Redshift; Amazon Elastic Compute Cloud EC2; Amazon Web Services AWS software; IBM DB2; FileMaker Pro; Teradata Active Enterprise Data Warehouse; Structured query language SQL; Transact-SQL;

Data mining software: Google Analytics; IBM InfoSphere Warehouse; Rapid-I RapidMiner;

Desktop communications software: Skype;

Desktop publishing software: Microsoft Publisher;

Development environment software: Microsoft Visual Basic; Microsoft Visual Basic for Applications VBA; Microsoft Visual Basic Scripting Edition VBScript; Microsoft Visual Studio; Integrated development environment IDE software; Microsoft .NET Framework; Microsoft Azure software; Microsoft PowerShell; Prolog; Quest SQL Optimizer for Oracle; Restructured extended executor REXX; Ruby; Oracle Jdeveloper; Oracle SQL Developer; Go; Eclipse IDE; Apache Ant; Adeptia ETL Suite; Apache Kafka; Apache Maven; CloverETL; Common business oriented language COBOL; C;

Document management software: Adobe Acrobat; IBM Content Manager;

Electronic mail software: IBM Notes; Microsoft Exchange; Microsoft Outlook;

Enterprise application integration software: Microsoft SQL Server Integration Services SSIS; Oracle Data Integrator; Oracle Fusion Middleware; SMSi Twister Data Integrator; SAS Data Integration Studio; IBM InfoSphere DataStage; Extensible markup language XML; BMC Software Control-M; Atlassian Bamboo; Talend Open Studio;

Enterprise resource planning ERP software: Ab Initio; Ellucian Banner ERP; Informatica Corporation PowerCenter; SAP software; SAP Business Objects; Oracle PeopleSoft; Oracle PeopleSoft Financials; Oracle Hyperion; Oracle Fusion Applications; Oracle JD Edwards EnterpriseOne; NetSuite ERP; Microsoft Dynamics; Microsoft Dynamics GP;

Enterprise system management software: IBM Power Systems software;

Expert system software: Ansible software; Apache Mahout;

File versioning software: Apache Subversion SVN; Git;

Geographic information system: Geographic information system GIS software; ESRI ArcGIS software;

Information retrieval or search software: Data validation software; Apache Avro; LexisNexis;

Manufacturing execution system MES software: CA Easytrieve Report Generator;

Medical software: Epic Systems;

Metadata management software: Flat File Checker; Data dictionary software; Data mapping software; Data modeling software; HiT Software Allora; IBM Rational Data Architect; IBM Rational System Architect; Informatica PowerCenter; Informatica software; CA Technologies ERWin Data Modeler; Coglin Mill RODIN; Apatar; Altova MapForce; Interface Computers Data Loader; Pentaho Kettle; Scriptella; Quest Erwin Data Modeler; Talend Data Fabric; SAP PowerDesigner; WisdomForce DatabaseSync System;

Multi-media educational software: Nearpod;

Network conferencing software: LogMeIn GoToWebinar;

Network monitoring software: Nagios; Zabbix; Wireshark;

Network security and virtual private network VPN equipment software: Virtual private networking VPN software;

Network security or virtual private network VPN management software: Database security software;

Object or component oriented development software: Apache Spark; Apache Groovy; Advanced business application programming ABAP; C#; C++; Microsoft Visual Basic.NET; Microsoft Visual C# .NET; Jupyter Notebook; jQuery; Microsoft ActiveX; R; Scala; SAP PowerBuilder; Python; Perl; Oracle Java; Swift;

Object oriented data base management software: PostgreSQL; Object database management system ODBMS; IBM Informix; Hibernate ORM;

Office suite software: Microsoft Office software;

Operating system software: Job control language JCL; KornShell; Linux; Operating system software; Microsoft Windows; Microsoft Windows Server; Perl shell; Oracle Solaris; Shell script; Red Hat Enterprise Linux; Hewlett Packard HP-UX; IBM AIX; DOS shell script; C shell; Cisco IOS; Apple macOS; Bash; UNIX; UNIX Shell; Ubuntu;

Portal server software: Apache HTTP Server;

Presentation software: Microsoft PowerPoint;

Process mapping and design software: Microsoft Visio; Visual Paradigm DB Visual ARCHITECT;

Program testing software: JUnit; Selenium; Computer Associates Log Analyzer; Database testing software; Hewlett Packard LoadRunner;

Project management software: Atlassian Confluence; Oracle Primavera Enterprise Project Portfolio Management; Microsoft Project;

Requirements analysis and system architecture software: Database capacity planning software; Unified modeling language UML;

Spreadsheet software: Microsoft Excel;

Storage media loading software: Intel Data Migration Software;

Storage networking software: Amazon Simple Storage Service S3; Storage area network SAN software;

Transaction security and virus protection software: Encryption software; McAfee; NortonLifeLock cybersecurity software;

Transaction server software: Customer information control system CICS;

Video conferencing software: Google Meet; Cisco Webex; LogMeIn GoToMeeting;

Web page creation and editing software: Adobe Dreamweaver; Google Sites;

Web platform development software: Google Angular; Hypertext markup language HTML; Django; Enterprise JavaBeans; Ext JS; Extensible hypertext markup language XHTML; Drupal; Dynamic hypertext markup language DHTML; AJAX; Apache Struts; Cascading style sheets CSS; Apache Tomcat; Backbone.js; LAMP Stack; JavaScript; JavaScript Object Notation JSON; Microsoft Active Server Pages ASP; Microsoft ASP.NET; Microsoft ASP.NET Core MVC; Oracle Application Express APEX; Node.js; Oracle Designer; Oracle JavaServer Pages JSP; PHP; Ruby on Rails; React; Spring Framework;

Word processing software: Microsoft Word; 3M Post-it App; Google Docs;


Related O*NET occupational titles for Database Architects include:
  • 15-1299.07 Blockchain Engineers
  • 15-1211.00 Computer Systems Analysts
  • 15-1299.08 Computer Systems Engineers/Architects
  • 15-2051.00 Data Scientists
  • 15-1243.01 Data Warehousing Specialists
  • 15-1242.00 Database Administrators
  • 15-1299.05 Information Security Engineers
  • 15-1244.00 Network and Computer Systems Administrators
  • 15-1252.00 Software Developers
  • 15-1253.00 Software Quality Assurance Analysts and Testers


Sources of Additional Information
  • For more information about database administrators and architects, visit: Association for Computing Machinery
  • Computing Research Association
  • IEEE Computer Society
  • For more information about opportunities for women pursuing information technology careers, visit: National Center for Women & Information Technology
  • For a career video on database administrators and architects, visit: Database Architects
  • Data Warehousing Specialists
  • Database Administrators
  • Database Architects

  • Contact Texas Workforce Commission
    Labor Market and Career Information  |  101 E. 15th Street, Annex Room 0252  |  Austin, Texas 78778
    Official Website  |  1-800-822-PLAN (7526)  |  512.936.3200

    ** The information in this report may be derived from many sources like O*NET, BLS (Bureau of Labor Statistics), OOH (Occupational Outlook Handbook), and Career One Stop.