Summary Report for:
15-1199.06 - Database Architects
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.
This title represents an occupation for which data collection is currently underway.
- Develop and document database architectures.
- Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
- Create and enforce database development standards.
- Demonstrate database technical functionality, such as performance, security 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.
- Design databases to support business applications, ensuring system scalability, security, performance and reliability.
- Develop data models for applications, metadata tables, views or related database structures.
- Develop load-balancing processes to eliminate down time for backup processes.
- Develop or maintain archived procedures, procedural codes, or queries for applications.
Tools & Technology
Tools used in this occupation:
|Facsimile machines — Fax machines|
|Photocopiers — Copy machines|
|Server load balancer — Load balancers|
Technology used in this occupation:
|Backup or archival software — Data Recovery Software SQL Server Data Recovery; Oracle Data Guard; Oracle Recovery Manager|
|Data base management system software — Microsoft SQL Server; MySQL software; Oracle Migration Workbench *; SAP Sybase Replication Server|
|Development environment software — Microsoft .NET Framework; Microsoft Visual Basic; Oracle Jdeveloper *; Quest SQL Optimizer for Oracle|
|Enterprise application integration software — Extensible markup language XML; IBM InfoSphere DataStage; Oracle Data Integrator; SAS Data Integration Studio|
|Metadata management software — Altova MapForce; Data modeling software; IBM Rational System Architect; Interface Computers Data Loader|
|Operating system software — C shell; Microsoft Windows; Perl shell; UNIX|
* Software developed by a government agency and/or distributed as freeware or shareware.
Interest code: ICE
|Investigative — Investigative occupations frequently involve working with ideas, and require an extensive amount of thinking. These occupations can involve searching for facts and figuring out problems mentally.|
|Conventional — Conventional occupations frequently involve following set procedures and routines. These occupations can include working with data and details more than with ideas. Usually there is a clear line of authority to follow.|
|Enterprising — Enterprising occupations frequently involve starting up and carrying out projects. These occupations can involve leading people and making many decisions. Sometimes they require risk taking and often deal with business.|
|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.|
|Independence — Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.|
Wages & Employment Trends
Median wages data collected from Computer Occupations, All Other.
Employment data collected from Computer Occupations, All Other.
Industry data collected from Computer Occupations, All Other.
|Median wages (2012)||$39.01 hourly, $81,140 annual|
|Employment (2010)||210,000 employees|
|Projected growth (2010-2020)||Slower than average (3% to 9%)|
|Projected job openings (2010-2020)||51,600|
|Top industries (2010)|
State & National
Source: Bureau of Labor Statistics 2012 wage data and 2010-2020 employment projections . "Projected growth" represents the estimated change in total employment over the projections period (2010-2020). "Projected job openings" represent openings due to growth and replacement.