15-1243.00 Bright Outlook

Database Architects

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.

Career Cluster:Digital Technology
Job Family:Computer and Mathematical
Job Zone:Job Zone Four: Considerable Preparation Needed
STEM:Research, Development, Design, and Practitioners
Industry:Information
Build Resume

Technology Tools

AJAXAmazon DynamoDBAmazon Elastic Compute Cloud EC2Amazon RedshiftAmazon Web Services AWS softwareAnsible softwareApache AirflowApache CassandraApache HadoopApache HiveApache KafkaApache MavenApache SparkApache Subversion SVNApache TomcatApple macOSAtlassian ConfluenceAtlassian JIRAAutodesk RevitBashCC#C++ChefCisco WebexDjangoDockerEclipse IDEElasticsearchEpic SystemsESRI ArcGIS softwareExtensible markup language XMLGitGitHubGoGoogle AnalyticsGoogle AngularGoogle DocsHibernate ORMHypertext markup language HTMLIBM DB2IBM SPSS StatisticsInformatica softwareJavaScriptJavaScript Object Notation JSONjQueryJUnitLinuxMicrosoft AccessMicrosoft Active Server Pages ASPMicrosoft ASP.NETMicrosoft Azure softwareMicrosoft ExcelMicrosoft Office softwareMicrosoft OutlookMicrosoft Power BIMicrosoft PowerPointAmazon Web Services AWS CloudFormationCascading style sheets CSSMicrosoft .NET FrameworkPerlMicrosoft SQL Server Reporting Services SSRSMySQLScalaMicrosoft Visual StudioMicrosoft WindowsOracle PeopleSoftMicrosoft PowerShellMicrosoft Windows ServerMicrosoft ProjectNode.jsMicrosoft SharePointRMicrosoft SQL ServerNoSQLMicrosoft SQL Server Integration Services SSISMicrosoft VisioSalesforce softwareMicrosoft Visual BasicMicrosoft Visual Basic for Applications VBAPHPMicrosoft WordPostgreSQLMongoDBAdobe AcrobatReactSplunk EnterpriseOracle DatabaseRed Hat Enterprise LinuxOracle JavaOracle Primavera Enterprise Project Portfolio ManagementSwiftOracle SQL DeveloperTableauSeleniumPuppetPythonRed Hat OpenShiftSpring BootRubySAP softwareSASTransact-SQLShell scriptSnowflakeSpring FrameworkStructured query language SQLTeradata DatabaseThe MathWorks MATLABUNIXUNIX Shell

Key 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.

Skills

Reading Comprehension
72%
Complex Problem Solving
72%
Critical Thinking
72%
Judgment and Decision Making
72%
Systems Analysis
69%
Speaking
63%
Active Listening
63%
Programming
60%
Active Learning
56%
Systems Evaluation
56%
Writing
53%
Operations Analysis
53%
Monitoring
53%
Coordination
50%
Mathematics
50%
Service Orientation
50%
Time Management
50%
Social Perceptiveness
50%
Technology Design
50%
Persuasion
47%
Instructing
47%
Learning Strategies
47%
Negotiation
41%
Management of Personnel Resources
38%
Operations Monitoring
28%
Management of Material Resources
25%
Management of Financial Resources
25%
Quality Control Analysis
25%
Troubleshooting
22%
Science
22%
Operation and Control
19%
Installation
16%
Equipment Selection
16%
Repairing
3%
Equipment Maintenance
3%

Knowledge

Computers and Electronics
83%
Engineering and Technology
74%
Design
68%
Mathematics
67%
English Language
54%
Administration and Management
47%
Education and Training
41%
Customer and Personal Service
33%
Law and Government
31%
Telecommunications
26%
Communications and Media
25%
Production and Processing
25%
Public Safety and Security
24%
Economics and Accounting
22%
Administrative
20%
Personnel and Human Resources
19%
Psychology
17%
Geography
16%
Sales and Marketing
16%
Foreign Language
10%
Sociology and Anthropology
8%
Transportation
6%
Physics
6%
Mechanical
5%
Chemistry
5%
History and Archeology
4%
Fine Arts
4%
Medicine and Dentistry
4%
Therapy and Counseling
4%
Philosophy and Theology
3%
Biology
3%
Building and Construction
3%
Food Production
1%

Build a Resume for Database Architects

Create a professional, ATS-optimized resume tailored to this career path.

Create Resume

Abilities

Deductive Reasoning
72%
Oral Comprehension
72%
Written Comprehension
72%
Problem Sensitivity
69%
Oral Expression
69%
Inductive Reasoning
69%
Information Ordering
69%
Speech Clarity
66%
Near Vision
66%
Category Flexibility
60%
Selective Attention
56%
Fluency of Ideas
56%
Flexibility of Closure
56%
Written Expression
56%
Perceptual Speed
53%
Mathematical Reasoning
53%
Number Facility
53%
Speech Recognition
50%
Originality
50%
Visualization
47%
Speed of Closure
44%
Memorization
38%
Far Vision
35%
Hearing Sensitivity
25%
Auditory Attention
25%
Depth Perception
25%
Time Sharing
25%
Visual Color Discrimination
25%
Arm-Hand Steadiness
22%
Finger Dexterity
22%
Control Precision
22%
Trunk Strength
22%
Wrist-Finger Speed
22%
Manual Dexterity
22%
Dynamic Strength
6%
Sound Localization
0%
Reaction Time
0%
Extent Flexibility
0%
Night Vision
0%
Stamina
0%
Static Strength
0%
Explosive Strength
0%
Peripheral Vision
0%
Multilimb Coordination
0%
Spatial Orientation
0%
Speed of Limb Movement
0%
Glare Sensitivity
0%
Gross Body Equilibrium
0%
Rate Control
0%
Dynamic Flexibility
0%
Response Orientation
0%
Gross Body Coordination
0%

Work Activities

Working with Computers
94%
Analyzing Data or Information
91%
Processing Information
85%
Getting Information
85%
Making Decisions and Solving Problems
82%
Updating and Using Relevant Knowledge
81%
Communicating with Supervisors, Peers, or Subordinates
79%
Identifying Objects, Actions, and Events
78%
Thinking Creatively
73%
Evaluating Information to Determine Compliance with Standards
73%
Estimating the Quantifiable Characteristics of Products, Events, or Information
73%
Documenting/Recording Information
72%
Developing Objectives and Strategies
70%
Organizing, Planning, and Prioritizing Work
68%
Providing Consultation and Advice to Others
64%
Monitoring Processes, Materials, or Surroundings
64%
Interpreting the Meaning of Information for Others
63%
Establishing and Maintaining Interpersonal Relationships
62%
Judging the Qualities of Objects, Services, or People
58%
Coaching and Developing Others
54%
Developing and Building Teams
54%
Training and Teaching Others
54%
Coordinating the Work and Activities of Others
53%
Communicating with People Outside the Organization
51%
Scheduling Work and Activities
51%
Guiding, Directing, and Motivating Subordinates
51%
Resolving Conflicts and Negotiating with Others
49%
Performing Administrative Activities
36%
Drafting, Laying Out, and Specifying Technical Devices, Parts, and Equipment
35%
Inspecting Equipment, Structures, or Materials
35%
Selling or Influencing Others
32%
Staffing Organizational Units
31%
Monitoring and Controlling Resources
30%
Assisting and Caring for Others
29%
Performing for or Working Directly with the Public
14%
Controlling Machines and Processes
13%
Repairing and Maintaining Electronic Equipment
12%
Handling and Moving Objects
5%
Performing General Physical Activities
5%
Repairing and Maintaining Mechanical Equipment
1%
Operating Vehicles, Mechanized Devices, or Equipment
0%

Work Context

E-Mail

How frequently does your job require you to use E-mail?

99%

Spend Time Sitting

How much does this job require sitting?

95%

Telephone Conversations

How often do you have telephone conversations in this job?

86%

Face-to-Face Discussions with Individuals and Within Teams

How frequently does your job require face-to-face discussions with individuals and within teams?

82%

Freedom to Make Decisions

How much decision making freedom, without supervision, does the job offer?

80%

Importance of Being Exact or Accurate

How important is being very exact or highly accurate in performing this job?

80%

Work With or Contribute to a Work Group or Team

How important is it to work with or contribute to a work group or team in this job?

80%

Indoors, Environmentally Controlled

How often does this job require working indoors in an environmentally controlled environment (like a warehouse with air conditioning)?

79%

Determine Tasks, Priorities and Goals

How much freedom does the worker have in determining the tasks, priorities, or goals of the job?

78%

Duration of Typical Work Week

Number of hours typically worked in one week.

72%

Contact With Others

How much does this job require the worker to be in contact with others (face-to-face, by telephone, or otherwise) in order to perform it?

70%

Impact of Decisions on Co-workers or Company Results

What results do your decisions usually have on other people or the image or reputation or financial resources of your employer?

70%

Level of Competition

To what extent does this job require the worker to compete or to be aware of competitive pressures?

70%

Coordinate or Lead Others in Accomplishing Work Activities

How important is it to coordinate or lead others (not as a supervisor or team leader) in accomplishing work activities in this job?

67%

Time Pressure

How often does this job require the worker to meet strict deadlines?

66%

Importance of Repeating Same Tasks

How important are continuous, repetitive, physical activities (like key entry) or mental activities (like checking entries in a ledger) to performing this job?

62%

Written Letters and Memos

How frequently does your job require written letters and memos?

58%

Consequence of Error

How serious would the result usually be if the worker made a mistake that was not easily correctable?

56%

Frequency of Decision Making

How often is the worker required to make decisions that affect other people, the financial resources, and/or the image and reputation of the organization?

54%

Work Outcomes and Results of Other Workers

How responsible is the worker for work outcomes and results of other workers?

54%

Conflict Situations

How frequently are there conflict situations the employee has to face in this job?

48%

Spend Time Using Your Hands to Handle, Control, or Feel Objects, Tools, or Controls

How much does this job require using your hands to handle, control, or feel objects, tools or controls?

43%

Degree of Automation

How automated is the job?

42%

Physical Proximity

To what extent does this job require the worker to perform job tasks physically close to other people?

38%

Public Speaking

How frequently does your job require public speaking (one speaker with an audience)?

36%

Deal With External Customers or the Public in General

How important is it to deal with external customers (as in retail sales) or the public in general (as in police work) in this job?

35%

Spend Time Making Repetitive Motions

How much does this job require making repetitive motions?

33%

Dealing With Unpleasant, Angry, or Discourteous People

How frequently does the worker have to deal with unpleasant, angry, or discourteous individuals as part of the job requirements?

31%

Health and Safety of Other Workers

How much responsibility is there for the health and safety of others in this job?

23%

Spend Time Standing

How much does this job require standing?

23%

Exposed to Sounds, Noise Levels that are Distracting or Uncomfortable

How often does this job require working exposed to sounds and noise levels that are distracting or uncomfortable?

19%

Work Schedules

How regular are the work schedules for this job?

10%

Pace Determined by Speed of Equipment

How important is it to this job that the pace is determined by the speed of equipment or machinery? (This does not refer to keeping busy at all times on this job.)

8%

Spend Time Walking or Running

How much does this job require walking or running?

8%

Indoors, Not Environmentally Controlled

How often does this job require working in an environment that is not environmentally controlled (like a warehouse without air conditioning)?

6%

Exposed to Contaminants

How often does this job require working exposed to contaminants (such as pollutants, gases, dust or odors)?

5%

Dealing with Violent or Physically Aggressive People

How frequently does this job require the worker to deal with physical aggression of violent individuals?

4%

Exposed to Extremely Bright or Inadequate Lighting Conditions

How often does this job require working in extremely bright or inadequate lighting conditions?

4%

Exposed to Cramped Work Space, Awkward Positions

How often does this job require working in cramped work spaces that requires getting into awkward positions?

3%

Outdoors, Exposed to All Weather Conditions

How often does this job require working outdoors, exposed to all weather conditions?

3%

Spend Time Bending or Twisting Your Body

How much does this job require bending or twisting your body?

3%

Exposed to Disease or Infections

How often does this job require exposure to disease/infections?

1%

Exposed to Hazardous Conditions

How often does this job require exposure to hazardous conditions?

1%

Exposed to Hazardous Equipment

How often does this job require exposure to hazardous equipment?

1%

Exposed to Minor Burns, Cuts, Bites, or Stings

How often does this job require exposure to minor burns, cuts, bites, or stings?

1%

Exposed to Very Hot or Cold Temperatures

How often does this job require working in very hot (above 90 F degrees) or very cold (below 32 F degrees) temperatures?

1%

In an Enclosed Vehicle or Operate Enclosed Equipment

How often does this job require working in a closed vehicle or operate enclosed equipment (like a car)?

1%

Outdoors, Under Cover

How often does this job require working outdoors, under cover (like in an open shed)?

1%

Spend Time Kneeling, Crouching, Stooping, or Crawling

How much does this job require kneeling, crouching, stooping or crawling?

1%

Wear Common Protective or Safety Equipment such as Safety Shoes, Glasses, Gloves, Hearing Protection, Hard Hats, or Life Jackets

How often does this job require wearing common protective or safety equipment such as safety shoes, glasses, gloves, hearing protection, hard hats or life-jackets?

1%

Exposed to High Places

How often does this job require exposure to high places?

0%

Exposed to Radiation

How often does this job require exposure to radiation?

0%

Exposed to Whole Body Vibration

How often does this job require exposure to whole body vibration (like operating a jackhammer or earth moving equipment)?

0%

In an Open Vehicle or Operating Equipment

How often does this job require working in an open vehicle or operating equipment (like a tractor)?

0%

Spend Time Climbing Ladders, Scaffolds, or Poles

How much does this job require climbing ladders, scaffolds, poles, etc.?

0%

Spend Time Keeping or Regaining Balance

How much does this job require keeping or regaining your balance?

0%

Wear Specialized Protective or Safety Equipment such as Breathing Apparatus, Safety Harness, Full Protection Suits, or Radiation Protection

How often does this job require wearing specialized protective or safety equipment such as breathing apparatus, safety harness, full protection suits, or radiation protection?

0%

Education

Bachelor's degree

76%

Master's degree

14%

Post-secondary certificate

5%

Interests

Conventional

Work involves following procedures and regulations to organize information or data, typically in a business setting. Conventional occupations are often associated with office work, accounting, mathematics/statistics, information technology, finance, or hum

83

Investigative

Work involves studying and researching non-living objects, living organisms, disease or other forms of impairment, or human behavior. Investigative occupations are often associated with physical, life, medical, or social sciences, and can be found in the f

78

Enterprising

Work involves managing, negotiating, marketing, or selling, typically in a business setting, or leading or advising people in political and legal situations. Enterprising occupations are often associated with business initiatives, sales, marketing/advertis

29

Realistic

Work involves designing, building, or repairing of equipment, materials, or structures, engaging in physical activity, or working outdoors. Realistic occupations are often associated with engineering, mechanics and electronics, construction, woodworking, t

28

Artistic

Work involves creating original visual artwork, performances, written works, food, or music for a variety of media, or applying artistic principles to the design of various objects and materials. Artistic occupations are often associated with visual arts,

20

Social

Work involves helping, teaching, advising, assisting, or providing service to others. Social occupations are often associated with social, health care, personal service, teaching/education, or religious activities.

16

Work Styles

Attention to Detail
100%
Dependability
84%
Intellectual Curiosity
79%
Achievement Orientation
70%
Cautiousness
69%
Innovation
68%
Integrity
63%
Adaptability
57%
Perseverance
55%
Tolerance for Ambiguity
53%
Self-Confidence
51%
Initiative
47%
Cooperation
44%
Stress Tolerance
36%
Leadership Orientation
26%
Self-Control
26%
Social Orientation
17%
Humility
8%
Sincerity
7%
Empathy
2%
Optimism
1%

Work Values

Achievement
83%
Independence
72%
Working Conditions
72%
Recognition
56%
Support
45%
Relationships
28%

Ready to pursue a career as Database Architects?

Create a professional resume that highlights the right skills and experience for this role.

Build Your Resume Now