Database Architects
SOC: 15-1199.06

Description:

Design strategies for enterprise database systems and set standards for operations, programming, and security. Design and construct large relational databases. Integrate new systems with existing warehouse structure and refine system performance and functionality.


National Salary Information:

Hourly Statistics:

Annual Statistics:

Source: Bureau of Labor Statistics 2015 wage data.


Employment Projections:

Employment (2014):
233,000 employed

Projected (2024):
240,800 employed

Projected growth (2014-2024)


Source: Bureau of Labor Statistics 2015 2014-2024 employment projections external site. "Projected growth" represents the estimated change in total employment over the projections period (2014-2024). "Projected job openings" represent openings due to growth and replacement.


Alternate Titles:

  • Data Administrator
  • Data Analyst
  • Data Architect
  • Data Base Design Analyst
  • Data Officer
  • Data Warehouse Architect
  • Database Analyst
  • Database Architect
  • Database Consultant
  • Database Design Analyst
  • Database Designer
  • Database Engineer
  • Database Modeler
  • Information Architect
  • Information Engineer
  • Information Modeling Engineer Specialist
  • Information Technology Architect (IT Architect)
  • Infrastructure Architect
  • Knowledge Architect
  • Management Analyst
  • SQL Server Developer
  • System Engineer
  • Technical Operations Vice President


  • Job Zone Four: Considerable Preparation Needed

    Experience:

    A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.

    Education:

    Most of these occupations require a four-year bachelor's degree, but some do not.

    Job Training:

    Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.


    Required Skills:

  • Reading Comprehension
  • Active Listening
  • Writing
  • Speaking
  • Mathematics
  • Science
  • Critical Thinking
  • Active Learning
  • Learning Strategies
  • Monitoring
  • Social Perceptiveness
  • Coordination
  • Persuasion
  • Negotiation
  • Instructing
  • Service Orientation
  • Complex Problem Solving
  • Operations Analysis
  • Technology Design
  • Equipment Selection
  • Installation
  • Programming
  • Operation Monitoring
  • Operation and Control
  • Troubleshooting
  • Quality Control Analysis
  • Judgment and Decision Making
  • Systems Analysis
  • Systems Evaluation
  • Time Management
  • Management of Financial Resources
  • Management of Material Resources
  • Management of Personnel Resources

  • Knowledge Used:

  • Administration and Management
  • Clerical
  • Economics and Accounting
  • Sales and Marketing
  • Customer and Personal Service
  • Personnel and Human Resources
  • Production and Processing
  • Computers and Electronics
  • Engineering and Technology
  • Design
  • Mechanical
  • Mathematics
  • Psychology
  • Sociology and Anthropology
  • Geography
  • Education and Training
  • English Language
  • Public Safety and Security
  • Law and Government
  • Telecommunications
  • Communications and Media


  • Tasks:

  • Test changes to database applications or systems.
  • 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.
  • Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
  • 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.

  • Tools & Technology:

  • Copy machines
  • Laser facsimile machines
  • Load balancers
  • Personal computers
  • Adeptia ETL Suite
  • Altova MapForce
  • Amazon Kinesis
  • Apache Avro
  • Apache Cassandra
  • Apache Flume
  • Apache Hadoop
  • Apache Hbase
  • Apache Hive
  • Apache HTTP Server
  • Apache Oozie
  • Apache Pig
  • Apache Solr
  • Apache Sqoop
  • Apatar
  • Apple Macintosh OS
  • Application server software
  • Bash
  • C shell
  • C#
  • C++
  • CA Erwin Data Modeler
  • CA Technologies ERWin Data Modeler
  • Cisco IOS
  • Citrix software
  • Cloudera Impala
  • CloverETL
  • Coglin Mill RODIN
  • Common business oriented language COBOL
  • Customer information control system CICS
  • Data modeling software
  • Data Recovery Software SQL Server Data Recovery
  • Enterprise JavaBeans
  • Epic Systems software
  • ESRI ArcGIS software
  • Extensible markup language XML
  • Flat File Checker
  • Hewlett Packard HP-UX
  • HiT Software Allora
  • IBM AIX
  • IBM Cognos Impromptu
  • IBM Content Manager
  • IBM DB2
  • IBM InfoSphere DataStage
  • IBM InfoSphere Warehouse
  • IBM Rational Data Architect
  • IBM Rational System Architect
  • IBM WebSphere
  • Infobright Community Edition ICE
  • Informatica PowerCenter
  • Integrated development environment IDE software
  • Intel Data Migration Software
  • Interface Computers Data Loader
  • Jitterbit
  • Job control language JCL
  • KornShell
  • Linux
  • Microsoft .NET Framework
  • Microsoft Access
  • Microsoft Active Server Pages ASP
  • Microsoft ActiveX
  • Microsoft Excel
  • Microsoft SharePoint software
  • Microsoft SQL Server Reporting Services
  • Microsoft SQL Server software
  • Microsoft Visio
  • Microsoft Visual Basic
  • Microsoft Visual Basic Scripting Edition VBScript
  • Microsoft Visual Studio
  • Microsoft Windows
  • MicroStrategy software
  • MongoDB
  • Multidimensional Expressions MDX
  • MySQL software
  • Nagios
  • NoSQL software
  • Oracle Application Server
  • Oracle Business Intelligence Enterprise Edition
  • Oracle Data Guard
  • Oracle Data Integrator
  • Oracle Designer
  • Oracle Enterprise Manager
  • Oracle Golden Gate
  • Oracle Hyperion software
  • Oracle Java
  • Oracle JD Edwards EnterpriseOne
  • Oracle Jdeveloper
  • Oracle Migration Workbench
  • Oracle PL/SQL
  • Oracle Real Application Cluster RAC
  • Oracle Recovery Manager
  • Oracle Solaris
  • Oracle WebLogic Server
  • Pentaho Kettle
  • Perforce Helix software
  • Perl shell
  • PHP: Hypertext Preprocessor
  • PostgreSQL software
  • Practical extraction and reporting language Perl
  • Puppet
  • Python
  • Qlik Tech QlikView
  • Quest SQL Optimizer for Oracle
  • R
  • Rapid-I RapidMiner
  • Red Hat Enterprise Linux
  • Relational database management software
  • SAP Business Objects software
  • SAP Crystal Reports
  • SAP software
  • SAP Sybase Adaptive Server Enterprise
  • SAP Sybase PowerDesigner
  • SAP Sybase Replication Server
  • SAS Data Integration Studio
  • SAS software
  • Scriptella
  • SMSi Twister Data Integrator
  • Spark
  • Splunk Enterprise
  • Spring Framework
  • SPSS software
  • Structured query language SQL
  • Sybase software
  • Symantec security software
  • Tableau software
  • Talend Big Data Integration
  • Talend Data Fabric
  • Talend Open Studio
  • Teradata Database
  • Transact-SQL
  • Unified modeling language UML
  • UNIX
  • Veritas NetBackup
  • WisdomForce DatabaseSync System


  • computer and mathematical


    industry stats

    SOC: 15-0000

    Total Employed: 4,005,250

    Average Annual Salary: $86,170