Details 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.
The occupation code you requested, 15-1099.08 (Database Architects), is no longer in use. In the future, please use 15-1199.06 (Database Architects) instead.
This title represents an occupation for which data collection is currently underway.
Tasks | Tools & Technology | Wages & Employment | Additional Information
Tasks Save Table (XLS/CSV)
- 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.
- Document and communicate database schemas, using accepted notations.
- Identify and correct deviations from database development standards.
- Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
- Plan and install upgrades of database management system software to enhance database performance.
- Set up database clusters, backup, or recovery processes.
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Provide technical support to junior staff or clients.
- Test changes to database applications or systems.
Tools & Technology Save Table (XLS/CSV)
Tools used in this occupation:
| Facsimile machines — Fax machines |
| Personal computers |
| Photocopiers — Copy machines |
| Server load balancer — Load balancers |
Technology used in this occupation:
| Analytical or scientific software — Infobright Community Edition ICE |
| Application server software — Oracle Application Server |
| Backup or archival software — Data Recovery Software SQL Server Data Recovery; Oracle Data Guard; Oracle Recovery Manager |
| Clustering software — Oracle Real Application Cluster RAC |
| Data base management system software — Microsoft SQL Server; MySQL software; Oracle Migration Workbench *; SAP Sybase Replication Server (see all 9 examples) |
| Data base user interface and query software — IBM DB2; Structured query language SQL; Transact-SQL |
| Data mining software — IBM Cognos 8 Business Intelligence; IBM InfoSphere Warehouse; Rapid-I RapidMiner * |
| Development environment software — Microsoft .NET Framework; Microsoft Visual Basic; Oracle Jdeveloper *; Quest SQL Optimizer for Oracle (see all 6 examples) |
| Document management software — IBM Content Manager |
| Enterprise application integration software — Extensible markup language XML; IBM InfoSphere DataStage; Oracle Data Integrator; SAS Data Integration Studio (see all 7 examples) |
| Metadata management software — Altova MapForce; Data modeling software; IBM Rational System Architect; Interface Computers Data Loader (see all 15 examples) |
| Network conferencing software — Microsoft SharePoint |
| Object or component oriented development software — Oracle Java *; Python |
| Operating system software — C shell; Microsoft Windows; Perl shell; UNIX (see all 11 examples) |
| Storage media loading software — Intel Data Migration Software |
| Web platform development software — Microsoft Active Server Pages ASP; Oracle Designer; PHP: Hypertext Preprocessor * |
* Software developed by a government agency and/or distributed as freeware or shareware.
Wages & Employment Trends
National
Median wages data collected from Computer Occupations, All Other*.
Employment data collected from Computer Specialists, All Other.
Industry data collected from Computer Specialists, All Other.
| Median wages (2010) | $38.10 hourly, $79,240 annual |
| Employment (2008) | 209,000 employees |
| Projected growth (2008-2018) | 
Average (7% to 13%)
|
| Projected job openings (2008-2018) | 72,600 |
| Top industries (2008) | Government (37% employed in this sector)
|
State & National
Source: Bureau of Labor Statistics 2010 wage data
and 2008-2018 employment projections
.
"Projected growth" represents the estimated change in total employment over the projections period (2008-2018). "Projected job openings" represent openings due to growth and replacement.
Sources of Additional Information
Disclaimer: Sources are listed to provide additional information on related jobs, specialties, and/or industries. Links to non-DOL Internet sites are provided for your convenience and do not constitute an endorsement.
- Computer network, systems, and database administrators
. Bureau of Labor Statistics, U.S. Department of Labor. Occupational Outlook Handbook, 2010-11 Edition.