Skip to content

O*NET-SOC 15-1243.00

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.

From O*NET 30.3

Tasks

From O*NET 30.3, by importance, as O*NET OnLine lists them

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

Technology Skills

From O*NET 30.3, 322 examples in 59 categories, 112 Hot Technology

Free · O*NET 30.3

Word processing software

  • 3M Post-it App
  • Google DocsHot Technology
  • Microsoft WordHot Technology

Enterprise resource planning ERP software

  • Ab Initio
  • Ellucian Banner ERP
  • Informatica Corporation PowerCenter
  • Microsoft Dynamics
  • Microsoft Dynamics GP
  • NetSuite ERP
  • Oracle Fusion Applications
  • Oracle Hyperion
  • Oracle JD Edwards EnterpriseOne
  • Oracle PeopleSoftHot Technology
  • Oracle PeopleSoft Financials
  • SAP Business Objects
  • SAP softwareHot Technology

Access software

  • Access management software
  • Citrix cloud computing software

Backup or archival software

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

Development environment software

  • Adeptia ETL Suite
  • Apache Ant
  • Apache KafkaHot TechnologyIn Demand
  • Apache MavenHot Technology
  • CHot Technology
  • CloverETL
  • Common business oriented language COBOL
  • Eclipse IDEHot Technology
  • GoHot Technology
  • Integrated development environment IDE software
  • Microsoft .NET FrameworkHot Technology
  • Microsoft Azure softwareHot TechnologyIn Demand
  • Microsoft PowerShellHot Technology
  • Microsoft Visual BasicHot Technology
  • Microsoft Visual Basic for Applications VBAHot Technology
  • Microsoft Visual Basic Scripting Edition VBScript
  • Microsoft Visual StudioHot Technology
  • Oracle Jdeveloper
  • Oracle SQL DeveloperHot Technology
  • Prolog
  • Quest SQL Optimizer for Oracle
  • Restructured extended executor REXX
  • RubyHot Technology

Data base management system software

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

Document management software

  • Adobe AcrobatHot Technology
  • IBM Content Manager
  • Microsoft SharePointHot Technology

Web page creation and editing software

  • Adobe Dreamweaver
  • Google Sites

Object or component oriented development software

  • Advanced business application programming ABAP
  • Apache Groovy
  • Apache SparkHot TechnologyIn Demand
  • C#Hot Technology
  • C++Hot Technology
  • jQueryHot Technology
  • Jupyter Notebook
  • Microsoft ActiveX
  • Microsoft Visual Basic.NET
  • Microsoft Visual C# .NET
  • Oracle JavaHot TechnologyIn Demand
  • PerlHot Technology
  • PythonHot TechnologyIn Demand
  • RHot Technology
  • SAP PowerBuilder
  • ScalaHot Technology
  • SwiftHot Technology

Web platform development software

  • AJAXHot Technology
  • Apache Struts
  • Apache TomcatHot Technology
  • Backbone.js
  • Cascading style sheets CSSHot Technology
  • DjangoHot Technology
  • Drupal
  • Dynamic hypertext markup language DHTML
  • Enterprise JavaBeans
  • Ext JS
  • Extensible hypertext markup language XHTML
  • Google AngularHot Technology
  • Hypertext markup language HTMLHot Technology
  • JavaScriptHot Technology
  • JavaScript Object Notation JSONHot Technology
  • LAMP Stack
  • Microsoft Active Server Pages ASPHot Technology
  • Microsoft ASP.NETHot Technology
  • Microsoft ASP.NET Core MVC
  • Node.jsHot Technology
  • Oracle Application Express APEX
  • Oracle Designer
  • Oracle JavaServer Pages JSP
  • PHPHot Technology
  • ReactHot Technology
  • Ruby on Rails
  • Spring FrameworkHot Technology

Metadata management software

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

Data base user interface and query software

  • Amazon Elastic Compute Cloud EC2Hot Technology
  • Amazon RedshiftHot Technology
  • Amazon Web Services AWS softwareHot TechnologyIn Demand
  • Apache HiveHot Technology
  • Blackboard software
  • Cloudera Impala
  • FileMaker Pro
  • IBM DB2Hot Technology
  • Microsoft AccessHot Technology
  • Microsoft SQL ServerHot Technology
  • Oracle DatabaseHot Technology
  • Oracle JDBC
  • Structured query language SQLHot TechnologyIn Demand
  • Teradata Active Enterprise Data Warehouse
  • Transact-SQLHot Technology

Storage networking software

  • Amazon Simple Storage Service S3
  • Storage area network SAN software

Cloud-based management software

  • Amazon Web Services AWS CloudFormationHot Technology
  • IBM WebSphere
  • Jitterbit
  • Splunk EnterpriseHot Technology

Expert system software

  • Ansible softwareHot Technology
  • Apache Mahout

Procedure management software

  • Apache AirflowHot Technology

Information retrieval or search software

  • Apache Avro
  • Data validation software
  • LexisNexis

Portal server software

  • Apache HTTP Server

File versioning software

  • Apache Subversion SVNHot Technology
  • GitHot Technology

Operating system software

  • Apple macOSHot Technology
  • BashHot Technology
  • C shell
  • Cisco IOS
  • DOS shell script
  • Hewlett Packard HP-UX
  • IBM AIX
  • Job control language JCL
  • KornShell
  • LinuxHot Technology
  • Microsoft WindowsHot Technology
  • Microsoft Windows ServerHot Technology
  • Oracle Solaris
  • Perl shell
  • Red Hat Enterprise LinuxHot Technology
  • Shell scriptHot Technology
  • Ubuntu
  • UNIXHot Technology
  • UNIX ShellHot Technology

Data base reporting software

  • ASG Technologies ASG-Zeke
  • Microsoft SQL Server Reporting Services SSRSHot Technology
  • Oracle Reports
  • Oracle SQL Loader
  • Oracle SQL Plus
  • ReCrystallize Crystal Reports
  • SAP Crystal Reports

Enterprise application integration software

  • Atlassian Bamboo
  • BMC Software Control-M
  • Extensible markup language XMLHot Technology
  • IBM InfoSphere DataStage
  • Microsoft SQL Server Integration Services SSISHot Technology
  • Oracle Data Integrator
  • Oracle Fusion Middleware
  • SAS Data Integration Studio
  • SMSi Twister Data Integrator
  • Talend Open Studio

Project management software

  • Atlassian ConfluenceHot Technology
  • Microsoft ProjectHot Technology
  • Oracle Primavera Enterprise Project Portfolio ManagementHot Technology

Content workflow software

  • Atlassian JIRAHot Technology

Computer aided design CAD software

  • Autodesk RevitHot Technology

Customer relationship management CRM software

  • Blackbaud The Raiser's Edge
  • Oracle Eloqua
  • Salesforce softwareHot Technology

Manufacturing execution system MES software

  • CA Easytrieve Report Generator

Configuration management software

  • ChefHot Technology
  • Deployment software
  • Perforce Helix software
  • PuppetHot Technology
  • Red Hat Ansible Engine

Video conferencing software

  • Cisco WebexHot Technology
  • Google Meet
  • LogMeIn GoToMeeting

Clustering software

  • Cluster server software
  • Oracle Real Application Cluster RAC
  • VMware

Program testing software

  • Computer Associates Log Analyzer
  • Database testing software
  • Hewlett Packard LoadRunner
  • JUnitHot Technology
  • SeleniumHot Technology

Transaction server software

  • Customer information control system CICS

Requirements analysis and system architecture software

  • Database capacity planning software
  • Unified modeling language UML

Network security or virtual private network VPN management software

  • Database security software

Application server software

  • DockerHot Technology
  • GitHubHot Technology
  • Oracle Application Server
  • Oracle WebLogic Server
  • Red Hat OpenShiftHot Technology
  • Red Hat WildFly
  • Spring BootHot Technology

Transaction security and virus protection software

  • Encryption software
  • McAfee
  • NortonLifeLock cybersecurity software

Medical software

  • Epic SystemsHot Technology

Geographic information system

  • ESRI ArcGIS softwareHot Technology
  • Geographic information system GIS software

Data mining software

  • Google AnalyticsHot Technology
  • IBM InfoSphere Warehouse
  • Rapid-I RapidMiner
  • SnowflakeHot TechnologyIn Demand

Cloud-based data access and sharing software

  • Google Drive

Object oriented data base management software

  • Hibernate ORMHot Technology
  • IBM Informix
  • Object database management system ODBMS
  • PostgreSQLHot Technology

Business intelligence and data analysis software

  • IBM Cognos Impromptu
  • Micosoft SQL Server Analysis Services SSAS
  • Microsoft Power BIHot TechnologyIn Demand
  • MicroStrategy
  • Oracle Business Intelligence Enterprise Edition
  • Qlik Tech QlikView
  • TableauHot TechnologyIn Demand

Communications server software

  • IBM Domino

Electronic mail software

  • IBM Notes
  • Microsoft Exchange
  • Microsoft OutlookHot Technology

Enterprise system management software

  • IBM Power Systems software

Analytical or scientific software

  • IBM SPSS StatisticsHot Technology
  • Infobright Community Edition ICE
  • Minitab
  • Safe Software FME
  • SASHot Technology
  • StataCorp Stata
  • Test data generator software
  • The MathWorks MATLABHot Technology

Storage media loading software

  • Intel Data Migration Software

Network conferencing software

  • LogMeIn GoToWebinar

Spreadsheet software

  • Microsoft ExcelHot TechnologyIn Demand

Office suite software

  • Microsoft Office softwareHot TechnologyIn Demand

Presentation software

  • Microsoft PowerPointHot TechnologyIn Demand

Desktop publishing software

  • Microsoft Publisher

Process mapping and design software

  • Microsoft VisioHot Technology
  • Visual Paradigm DB Visual ARCHITECT

Network monitoring software

  • Nagios
  • Wireshark
  • Zabbix

Multi-media educational software

  • Nearpod

Administration software

  • Redgate SQL Server

Desktop communications software

  • Skype

Cloud-based protection or security software

  • SolarWinds

Network security and virtual private network VPN equipment software

  • Virtual private networking VPN software

Detailed Work Activities

From O*NET 30.3, under their work activities; open one for the AI skills Workforce Automation maps to it

Free · O*NET 30.3

Estimating the Quantifiable Characteristics of Products, Events, or Information

  • Estimate time or monetary resources needed to complete projects.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Judging the Qualities of Objects, Services, or People

  • Assess database performance.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 19 AI skills mapped to this activity, by automation level

    • Replaces 1
    • Augments 11
    • Supports 4
    • Informs 3
  • Evaluate utility of software or hardware technologies.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Analyzing Data or Information

  • Analyze market or customer related data.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Analyze data to identify trends or relationships among variables.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Thinking Creatively

  • Design computer modeling or simulation programs.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Modify software programs to improve performance.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 24 AI skills mapped to this activity, by automation level

    • Augments 11
    • Supports 8
    • Informs 5
    • golang-performancesamber/cc-skills-golang42,006 installsAugments
      Gen Agent Trust Hub Pass
      Snyk Pass
      Socket Pass
      ZeroLeaks Pass
    • Wp performanceclaudeskills.infoAugments
    • Performancecognitedata/dune-skills338 installsAugments
      Gen Agent Trust Hub Pass
      Snyk Pass
      Socket Pass
      ZeroLeaks Pass
    • Vtex io application performancevtex/skills1,158 installsAugments
      Gen Agent Trust Hub Pass
      Snyk Pass
      Socket Pass
      ZeroLeaks Pass
    • Agent orchestration improve agentsickn33/antigravity-awesome-skills574 installsAugments
      Gen Agent Trust Hub Pass
      Runlayer Warn
      Snyk Pass
      Socket Pass
      ZeroLeaks Pass
  • Develop database parameters or specifications.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Create databases to store electronic data.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Working with Computers

  • Write computer programming code.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Create electronic data backup to prevent loss of information.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Install computer software.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Resolve computer software problems.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Drafting, Laying Out, and Specifying Technical Devices, Parts, and Equipment

  • Develop performance metrics or standards related to information technology.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 11 AI skills mapped to this activity, by automation level

    • Augments 4
    • Supports 4
    • Informs 3
  • Develop models of information or communications systems.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Develop procedures for data management.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Develop guidelines for system implementation.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Documenting/Recording Information

  • Document technical specifications or requirements.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Document design or development procedures.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Communicating with Supervisors, Peers, or Subordinates

  • Collaborate with others to determine design specifications or details.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 10 AI skills mapped to this activity, by automation level

    • Augments 3
    • Supports 7
  • Communicate project information to others.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 26 AI skills mapped to this activity, by automation level

    • Augments 14
    • Supports 11
    • Informs 1

Training and Teaching Others

  • Train others in computer interface or software use.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 1 of 1 AI skills mapped to this activity, by automation level

    • Supports 1

Guiding, Directing, and Motivating Subordinates

  • Coordinate project activities with other personnel or departments.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 9 AI skills mapped to this activity, by automation level

    • Augments 5
    • Supports 4

Providing Consultation and Advice to Others

  • Provide technical support for software maintenance or use.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 5 AI skills mapped to this activity, by automation level

    • Augments 4
    • Supports 1
  • Provide recommendations to others about computer hardware.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Job Zone

From O*NET 30.3

Free · O*NET 30.3

Job Zone Four: Considerable Preparation Needed

Workforce Automation analysis, not part of the source

WFA coverage: AI skills for this job

WFA · Part of the paid plan when accounts open

Pilot mapping: these skill links come from our seed list and haven’t been reviewed yet. Expect them to change as each one is checked.

DWAs covered by an AI skill8 of 25
Distinct tools90
Level mix
  • Replaces 1
  • Augments 49
  • Supports 33
  • Informs 12

Equivalents

NICE work roles, with their DCWF equivalents

Mapped to this job by the ETO-CSET NICE/O*NET crosswalk (2024); roles from NICE Framework Components v2.2.0, DCWF equivalents from DoD DCWF Tool v5.3 (2026-09-25)

Free · NICE Framework Components v2.2.0 and DoD DCWF Tool v5.3 (2026-09-25)