Apply
Employment Percentage
12.72144742
SOC ID
15-1245
SOC Title
Database Administrators and Architects
ONET ID
15-1243.00
ONET Concat ID
15124300
Median Salary
98217.04
Ed Level High School
0
Ed Level Certificate
0
Ed Level Some College
0
Ed Level Associates
4.17
Ed Level Bachelors
62.5
Ed Level Masters
29.17
Ed Level Doctors
4.17
Typical Ed Level
a Bachelor's degree
Career 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.
Core Tasks
  • Design databases to support business applications, ensuring system scalability, security, performance and reliability.
  • Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
  • Develop data models for applications, metadata tables, views or related database structures.
  • Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
  • Set up database clusters, backup, or recovery processes.
  • Create and enforce database development standards.
  • 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.
  • Develop and document database architectures.
  • Document and communicate database schemas, using accepted notations.
  • Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
  • Demonstrate database technical functionality, such as performance, security and reliability.
  • Develop or maintain archived procedures, procedural codes, or queries for applications.
  • Develop load-balancing processes to eliminate down time for backup processes.
  • Provide technical support to junior staff or clients.
  • Identify and correct deviations from database development standards.
  • Plan and install upgrades of database management system software to enhance database performance.
Start Annual Earnings
54314.45
Top Annual Earnings
168351.69
EMSI Career Title Slug
database-architect