Career Details
Career Details
Use this dropdown to update your zip code
Back to top

Career Details

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.


Key Facts
Expand or Shrink Accordion
Bright Outlook
Career Details
Green Job
Career Details
Current Employment
N/A
Estimate
Forecasted Employment
N/A
Estimate
Change in Employment
N/A
Estimate
Change in Employment %
N/A
Estimate
Tasks
Expand or Shrink Accordion
Tasks
The tasks listed below can be performed to prepare you for a career in this field.
Core
  • Provide technical support to junior staff or clients.
  • Set up database clusters, backup, or recovery processes.
  • Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
  • Plan and install upgrades of database management system software to enhance database performance.
  • Identify and correct deviations from database development standards.
  • Document and communicate database schemas, using accepted notations.
  • Develop or maintain archived procedures, procedural codes, or queries for applications.
  • Develop load-balancing processes to eliminate down time for backup processes.
  • Develop data models for applications, metadata tables, views or related database structures.
  • Design databases to support business applications, ensuring system scalability, security, performance and reliability.
  • 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.
  • Demonstrate database technical functionality, such as performance, security and reliability.
  • Create and enforce database development standards.
  • Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
  • Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
  • Develop and document database architectures.
Generic
  • Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
  • Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
  • Establish and calculate optimum values for database parameters, using manuals and calculator.
  • Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
  • Review project requests describing database user needs to estimate time and cost required to accomplish project.
  • Test programs or databases, correct errors, and make necessary modifications.
  • Train users and answer questions.
  • Work as part of a project team to coordinate database development and determine project scope and limitations.
  • Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Knowledge
Expand or Shrink Accordion
Knowledge

The items listed below are organized into sections that contain knowledge useful for pursuing a career in this field. Each section also contains a "Percentage of Importance" statistic that shows how relevant an item is to the occupation.
 Computers and Electronics
  • 92%
    Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
 English Language
  • 79%
    Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
 Design
  • 72%
    Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
 Mathematics
  • 72%
    Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
 Engineering and Technology
  • 67%
    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.
 Education and Training
  • 54%
    Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.
 Administration and Management
  • 52%
    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.
 Telecommunications
  • 52%
    Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Tools
Expand or Shrink Accordion
Tools
The tools listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.
 Duplicating machines
  • Copy machines
  • Laser facsimile machines
 Computers
  • Desktop computers
  • Mainframe computers
  • Notebook computers
  • Personal computers
 Media storage devices
  • Hard disk drives
  • Redundant array of independent disks RAID systems
  • Tape libraries
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Technology
Expand or Shrink Accordion
Technology
The technologies listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.
 Content authoring and editing software
  • 3M Post-it App
  • Adobe Systems Adobe Dreamweaver
  • Google DocsHOT
  • Google Sites
  • Microsoft ExcelHOT
  • Microsoft PowerPointHOT
  • Microsoft Publisher
  • Microsoft VisioHOT
  • Microsoft WordHOT
 Finance accounting and enterprise resource planning ERP software
  • Ab InitioHOT
  • Ellucian Banner ERPHOT
  • Informatica Corporation PowerCenterHOT
  • Microsoft DynamicsHOT
  • Microsoft Dynamics GPHOT
  • NetSuite ERPHOT
  • Oracle Fusion ApplicationsHOT
  • Oracle HyperionHOT
  • Oracle JD Edwards EnterpriseOneHOT
  • Oracle PeopleSoftHOT
  • Oracle PeopleSoft FinancialsHOT
  • SAPHOT
  • SAP Business ObjectsHOT
 Networking software
  • Access management software
  • Amazon Simple Storage Service S3HOT
  • Amazon Web Services AWS CloudFormationHOT
  • CitrixHOT
  • IBM Domino
  • Storage area network SAN software
 Utility and device driver 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
  • Intel Data Migration Software
  • Oracle Data Guard
  • Oracle Recovery Manager
  • Storage management software
  • Systems and data disaster recovery software
  • Veritas NetBackup
 Development software
  • Adeptia ETL Suite
  • Advanced business application programming ABAPHOT
  • AJAXHOT
  • Apache AntHOT
  • Apache GroovyHOT
  • Apache KafkaHOT
  • Apache Maven
  • Apache SparkHOT
  • Apache StrutsHOT
  • Apache TomcatHOT
  • Atlassian BambooHOT
  • Backbone.jsHOT
  • BMC Software Control-M
  • C
  • C#HOT
  • C++HOT
  • Cascading Style Sheets CSSHOT
  • Chef
  • CloverETL
  • Common business oriented language COBOLHOT
  • Computer Associates Log Analyzer
  • Database capacity planning software
  • Database testing software
  • Deployment software
  • DjangoHOT
  • DrupalHOT
  • Dynamic hypertext markup language DHTML
  • Eclipse IDEHOT
  • Enterprise JavaBeans
  • Ext JS
  • Extensible HyperText Markup Language XHTML
  • Extensible markup language XMLHOT
  • GoHOT
  • Google AngularJSHOT
  • Hewlett Packard LoadRunner
  • Hypertext markup language HTMLHOT
  • IBM InfoSphere DataStage
  • IBM WebSphereHOT
  • Integrated development environment IDE softwareHOT
  • JavaScriptHOT
  • JavaScript Object Notation JSONHOT
  • Jitterbit
  • jQueryHOT
  • JUnitHOT
  • Jupyter Notebook
  • LAMP Stack
  • Microsoft .NET FrameworkHOT
  • Microsoft Active Server Pages ASPHOT
  • Microsoft ActiveX
  • Microsoft ASP.NETHOT
  • Microsoft ASP.NET Core MVCHOT
  • Microsoft AzureHOT
  • Microsoft PowerShellHOT
  • Microsoft SQL Server Integration Services SSISHOT
  • Microsoft Visual BasicHOT
  • Microsoft Visual Basic for Applications VBAHOT
  • Microsoft Visual Basic Scripting Edition VBScriptHOT
  • Microsoft Visual Basic.NET
  • Microsoft Visual C# .NET
  • Microsoft Visual StudioHOT
  • Node.jsHOT
  • Oracle Application Express APEX
  • Oracle Data Integrator
  • Oracle Designer
  • Oracle Fusion MiddlewareHOT
  • Oracle JavaHOT
  • Oracle JavaServer Pages JSPHOT
  • Oracle Jdeveloper
  • Perforce Helix software
  • PHP: Hypertext PreprocessorHOT
  • Practical extraction and reporting language PerlHOT
  • Prolog
  • PuppetHOT
  • PythonHOT
  • Quest SQL Optimizer for Oracle
  • RHOT
  • ReactHOT
  • Red Hat Ansible Engine
  • Restructured extended executor REXX
  • RubyHOT
  • Ruby on RailsHOT
  • SAP PowerBuilder
  • SAS Data Integration Studio
  • ScalaHOT
  • SeleniumHOT
  • SMSi Twister Data Integrator
  • Spring FrameworkHOT
  • SwiftHOT
  • Talend Open Studio
  • Unified modeling language UMLHOT
  • VMWareHOT
 Data management and query software
  • ADO.NET
  • Altova MapForce
  • Amazon DynamoDBHOT
  • Amazon Elastic Compute Cloud EC2HOT
  • Amazon Kinesis
  • Amazon RedshiftHOT
  • Amazon Web Services AWS softwareHOT
  • Apache Avro
  • Apache CassandraHOT
  • Apache Flume
  • Apache HadoopHOT
  • Apache Hbase
  • Apache HiveHOT
  • Apache HTTP ServerHOT
  • Apache Oozie
  • Apache PigHOT
  • Apache SolrHOT
  • Apache Sqoop
  • Apatar
  • ASG Technologies ASG-Zeke
  • Blackbaud The Raiser's Edge
  • Blackboard software
  • BMC Software Change Manager
  • CA Erwin Data Modeler
  • CA IDMS
  • CA Technologies ERWin Data Modeler
  • Catalog navigation software
  • Cloudera Impala
  • Cluster server software
  • Coglin Mill RODIN
  • Concurrency control software
  • Couchbase Server
  • Customer information control system CICS
  • Data definition language DDL
  • Data dictionary software
  • Data entry softwareHOT
  • Data manipulation language DML
  • Data mapping software
  • Data modeling software
  • Data transformation services DTS software
  • Data validation software
  • Database design software
  • ElasticsearchHOT
  • Embarcadero Technologies DBArtisan
  • FileMaker Pro
  • Flat File Checker
  • Google AnalyticsHOT
  • Greenplum Database
  • Hibernate ORM
  • HiT Software Allora
  • IBM Cognos ImpromptuHOT
  • IBM DB2
  • IBM Informix
  • IBM InfoSphere Warehouse
  • IBM Interactive System Productivity Facility ISPF
  • IBM Rational Data Architect
  • IBM Rational System Architect
  • Index tuning software
  • Informatica Big Data
  • Informatica PowerCenter
  • Interface Computers Data Loader
  • LexisNexis
  • MapR Converged Data Platform
  • MariaDB
  • Micosoft SQL Server Analysis Services SSAS
  • Microsoft AccessHOT
  • Microsoft SQL ServerHOT
  • Microsoft SQL Server Reporting ServicesHOT
  • MicroStrategyHOT
  • MongoDBHOT
  • Multidimensional Expressions MDX
  • MySQLHOT
  • NoSQLHOT
  • Object database management system ODBMS
  • Oracle Business Intelligence Enterprise EditionHOT
  • Oracle Eloqua
  • Oracle Enterprise Manager
  • Oracle Enterprise Manager Cloud Control
  • Oracle Golden Gate
  • Oracle JDBCHOT
  • Oracle Migration Workbench
  • Oracle PL/SQLHOT
  • Oracle Real Application Cluster RAC
  • Oracle Reports
  • Oracle softwareHOT
  • Oracle SQL Loader
  • Oracle SQL Plus
  • Pentaho Kettle
  • PostgreSQLHOT
  • Qlik Tech QlikViewHOT
  • Quest Central
  • Quest SharePlex
  • Rapid-I RapidMiner
  • ReCrystallize Crystal Reports
  • Relational database management softwareHOT
  • Salesforce softwareHOT
  • SAP Adaptive Server Enterprise
  • SAP Crystal ReportsHOT
  • SAP PowerDesigner
  • SAP Replication Server
  • Scriptella
  • SentryOne SQL Sentry
  • Structured query language SQLHOT
  • TableauHOT
  • Talend Big Data Integration
  • Talend Data Fabric
  • Teradata Active Enterprise Data Warehouse
  • Teradata DatabaseHOT
  • Transact-SQLHOT
  • Visual Paradigm DB Visual ARCHITECT
  • WisdomForce DatabaseSync System
 Content management software
  • Adobe Systems Adobe AcrobatHOT
  • Apache Subversion SVNHOT
  • Atlassian JIRAHOT
  • GitHOT
  • IBM Content Manager
 Business function specific software
  • Ansible softwareHOT
  • Apache Mahout
  • ConfluenceHOT
  • Google DriveHOT
  • Microsoft OfficeHOT
  • Microsoft ProjectHOT
  • Microsoft SharePointHOT
  • Oracle Primavera Enterprise Project Portfolio ManagementHOT
 Operating environment software
  • Apple macOSHOT
  • BashHOT
  • C shell
  • Cisco IOS
  • DOS shell script
  • Hewlett Packard HP-UX
  • IBM AIX
  • Job control language JCL
  • KornShell
  • LinuxHOT
  • Microsoft WindowsHOT
  • Microsoft Windows ServerHOT
  • Oracle SolarisHOT
  • Perl shell
  • Red Hat Enterprise LinuxHOT
  • Shell scriptHOT
  • Ubuntu
  • UNIXHOT
  • UNIX ShellHOT
 Network applications software
  • Application server software
  • DockerHOT
  • GitHubHOT
  • Oracle Application Server
  • Oracle WebLogic ServerHOT
  • Red Hat OpenShiftHOT
  • Red Hat WildFlyHOT
  • Skype
  • Spring BootHOT
 Industry specific software
  • Autodesk RevitHOT
  • CA Easytrieve Report Generator
  • Epic SystemsHOT
  • IBM SPSS StatisticsHOT
  • Infobright Community Edition ICE
  • MinitabHOT
  • Safe Software FME
  • SASHOT
  • StataCorp Stata
  • Test data generator software
  • The MathWorks MATLABHOT
 Information exchange software
  • Cisco Systems Webex
  • ESRI ArcGIS softwareHOT
  • Geographic information system GIS softwareHOT
  • Google Meet
  • IBM NotesHOT
  • LogMeIn GoToMeeting
  • LogMeIn GoToWebinar
  • Microsoft ExchangeHOT
  • Microsoft OutlookHOT
 Security and protection software
  • Database security software
  • Encryption software
  • McAfee
  • SymantecHOT
  • Virtual private networking VPN softwareHOT
 System management software
  • IBM Power Systems software
  • Splunk EnterpriseHOT
 Network management software
  • NagiosHOT
  • Redgate SQL Server
  • SolarWinds
  • WiresharkHOT
  • Zabbix
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Certifications
Expand or Shrink Accordion
Certifications
The certifications listed below are useful to pursue if you are interested in a career in this field.
No specific certifications are listed for this career
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Licensing
Expand or Shrink Accordion
Licensing
The licensing information below is organized into sections and is useful for pursuing if you are interested in a career in this field.
No specific licensing information is listed for this occupation in the area you have selected.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Related Programs
Expand or Shrink Accordion
Online Programs related to this career, offered by participating institution(s), are listed below.

Clicking on the Degree programs in the list below will take you away from the Careers page.
INSTITUTION
PROGRAMS
Blue Ridge Community College
Brightpoint Community College
Central Virginia Community College
Germanna Community College
J Sargeant Reynolds Community College
Laurel Ridge Community College
Mountain Empire Community College
Mountain Gateway Community College
New River Community College
Northern Virginia Community College
Patrick & Henry Community College
Paul D. Camp Community College
Piedmont Virginia Community College
Rappahannock Community College
Southside Virginia Community College
Southwest Virginia Community College
Tidewater Community College
Virginia Peninsula Community College
Virginia Western Community College
Wytheville Community College