Database Architects

database administrators_1.webp
$134,870 Median Wage (2022)
4,500 Projected job openings (2022-2032)
10.00% Projected growth (2022-2032)

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.

Experience Requirements Overview

  • Job Zone Four: Considerable Preparation Needed
  • 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.
  • Most of these occupations require a four-year bachelor's degree, but some do not.
  • Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.

Education, Training and Experience

Required Level of Education: Bachelor's Degree

Related Work Experience: Over 4 years, up to and including 6 years

On-Site or In-Plant Training: N.A.

On-the-Job Training: Anything beyond short demonstration, up to and including 1 month

Detailed Work Activities

  • Provide technical support for software maintenance or use.
  • Develop database parameters or specifications.
  • Evaluate utility of software or hardware technologies.
  • Provide recommendations to others about computer hardware.
  • Create databases to store electronic data.
  • Install computer software.
  • Resolve computer software problems.
  • Document design or development procedures.
  • Communicate project information to others.
  • Develop procedures for data management.
  • Create electronic data backup to prevent loss of information.
  • Design computer modeling or simulation programs.
  • Develop models of information or communications systems.
  • Assess database performance.
  • Develop performance metrics or standards related to information technology.
  • Collaborate with others to determine design specifications or details.
  • Document technical specifications or requirements.
  • Develop guidelines for system implementation.
  • Analyze market or customer related data.
  • Analyze data to identify trends or relationships among variables.
  • Estimate time or monetary resources needed to complete projects.
  • Modify software programs to improve performance.
  • Train others in computer interface or software use.
  • Coordinate project activities with other personnel or departments.
  • Write computer programming code.

Work Values

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.

Recognition

Occupations that satisfy this work value offer advancement, potential for leadership, and are often considered prestigious. Corresponding needs are Advancement, Authority, Recognition and Social Status.

Relationships

Occupations that satisfy this work value allow employees to provide service to others and work with co-workers in a friendly non-competitive environment. Corresponding needs are Co-workers, Moral Values and Social Service.

Support

Occupations that satisfy this work value offer supportive management that stands behind employees. Corresponding needs are Company Policies, Supervision: Human Relations and Supervision: Technical.

Independence

Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.

Tasks

  • Develop and document database architectures.
  • 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.
  • 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.
  • 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 methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
  • Create and enforce database development standards.
  • Document and communicate database schemas, using accepted notations.
  • Develop data model describing data elements and their use, following procedures and using pen, template or computer software.
  • Work as part of a project team to coordinate database development and determine project scope and limitations.
  • Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
  • Set up database clusters, backup, or recovery processes.
  • Demonstrate database technical functionality, such as performance, security and reliability.
  • Develop load-balancing processes to eliminate down time for backup processes.
  • Plan and install upgrades of database management system software to enhance database performance.
  • Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
  • Test programs or databases, correct errors, and make necessary modifications.
  • Identify and correct deviations from database development standards.
  • Review project requests describing database user needs to estimate time and cost required to accomplish project.
  • Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
  • Develop or maintain archived procedures, procedural codes, or queries for applications.
  • Provide technical support to junior staff or clients.
  • Establish and calculate optimum values for database parameters, using manuals and calculators.
  • Train users and answer questions.

Work Styles

Achievement/Effort

Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.

Persistence

Job requires persistence in the face of obstacles.

Initiative

Job requires a willingness to take on responsibilities and challenges.

Leadership

Job requires a willingness to lead, take charge, and offer opinions and direction.

Cooperation

Job requires being pleasant with others on the job and displaying a good-natured, cooperative attitude.

Concern for Others

Job requires being sensitive to others' needs and feelings and being understanding and helpful on the job.

Social Orientation

Job requires preferring to work with others rather than alone, and being personally connected with others on the job.

Self-Control

Job requires maintaining composure, keeping emotions in check, controlling anger, and avoiding aggressive behavior, even in very difficult situations.

Stress Tolerance

Job requires accepting criticism and dealing calmly and effectively with high-stress situations.

Adaptability/Flexibility

Job requires being open to change (positive or negative) and to considerable variety in the workplace.

Dependability

Job requires being reliable, responsible, and dependable, and fulfilling obligations.

Attention to Detail

Job requires being careful about detail and thorough in completing work tasks.

Integrity

Job requires being honest and ethical.

Independence

Job requires developing one's own ways of doing things, guiding oneself with little or no supervision, and depending on oneself to get things done.

Innovation

Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.

Analytical Thinking

Job requires analyzing information and using logic to address work-related issues and problems.

Data Source: This page includes information from the O*NET 28.0 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license. O*NET® is a trademark of USDOL/ETA. This page includes Employment Projections program, Occupational Employment and Wage Statistics program, U.S. Bureau of Labor Statistics.