Careers
>Information Technology
>Information Support and Services
>Information Technology
>Network Systems
>Database Architects
Database Architects
Overview
Demand
Core Tasks
Technology Skills
Tools Used
Top 10 Knowledge Required
Top 10 Skills
Top 10 Abilities
Top 10 Work Activities
Detailed Work Activities
Work Context
Education
Majors
Interests
Top 10 Work Styles
Work Values
Overview
Job Zone Four: Considerable Preparation Needed
Experience
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.
Education
Most of these occupations require a four-year bachelor's degree, but some do not.
Job Training
Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.
Examples
Many of these occupations involve coordinating, supervising, managing, or training others. Examples include real estate brokers, sales managers, database administrators, graphic designers, chemists, art directors, and cost estimators.
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.
Demand
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.
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
Develop data models for applications, metadata tables, views or related database structures.
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.
Identify and correct deviations from database development standards.
Provide technical support to junior staff or clients.
Plan and install upgrades of database management system software to enhance database performance.
Technology Skills
Technology
Example
Hot Technology
Tools Used
Tool
Example
Top 10 Knowledge Required
Computers and Electronics
93%
Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
English Language
80%
Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
Design
73%
Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
Mathematics
72%
Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
Engineering and Technology
67%
Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
Education and Training
55%
Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.
Administration and Management
53%
Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
Telecommunications
52%
Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.
Customer and Personal Service
50%
Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
Communications and Media
42%
Knowledge of media production, communication, and dissemination techniques and methods. This includes alternative ways to inform and entertain via written, oral, and visual media.
Top 10 Skills
Critical Thinking
78%
Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
Judgment and Decision Making
73%
Considering the relative costs and benefits of potential actions to choose the most appropriate one.
Reading Comprehension
73%
Understanding written sentences and paragraphs in work related documents.
Active Listening
70%
Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
Complex Problem Solving
70%
Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
Speaking
70%
Talking to others to convey information effectively.
Systems Analysis
70%
Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
Writing
68%
Communicating effectively in writing as appropriate for the needs of the audience.
Coordination
65%
Adjusting actions in relation to others' actions.
Monitoring
65%
Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
Top 10 Abilities
Deductive Reasoning
80%
The ability to apply general rules to specific problems to produce answers that make sense.
Information Ordering
78%
The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
Problem Sensitivity
78%
The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.
Written Comprehension
78%
The ability to read and understand information and ideas presented in writing.
Inductive Reasoning
75%
The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
Oral Comprehension
75%
The ability to listen to and understand information and ideas presented through spoken words and sentences.
Oral Expression
73%
The ability to communicate information and ideas in speaking so others will understand.
Near Vision
70%
The ability to see details at close range (within a few feet of the observer).
Speech Clarity
70%
The ability to speak clearly so others can understand you.
Category Flexibility
68%
The ability to generate or use different sets of rules for combining or grouping things in different ways.
Top 10 Work Activities
Interacting With Computers
97%
Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
Analyzing Data or Information
90%
Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
Getting Information
90%
Observing, receiving, and otherwise obtaining information from all relevant sources.
Making Decisions and Solving Problems
88%
Analyzing information and evaluating results to choose the best solution and solve problems.
Processing Information
86%
Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
Updating and Using Relevant Knowledge
85%
Keeping up-to-date technically and applying new knowledge to your job.
Communicating with Supervisors, Peers, or Subordinates
83%
Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
Provide Consultation and Advice to Others
82%
Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.
Evaluating Information to Determine Compliance with Standards
81%
Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.
Thinking Creatively
81%
Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
Detailed Work Activities
Create databases to store electronic data.
Develop procedures for data management.
Collaborate with others to determine design specifications or details.
Design computer modeling or simulation programs.
Develop models of information or communications systems.
Develop database parameters or specifications.
Develop performance metrics or standards related to information technology.
Document technical specifications or requirements.
Document design or development procedures.
Communicate project information to others.
Evaluate utility of software or hardware technologies.
Provide recommendations to others about computer hardware.
Assess database performance.
Create electronic data backup to prevent loss of information.
Provide technical support for software maintenance or use.
Resolve computer software problems.
Install computer software.
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 Context
Electronic Mail
How often do you use electronic mail in this job?
Indoors, Environmentally Controlled
How often does this job require working indoors in environmentally controlled conditions?
Spend Time Sitting
How much does this job require sitting?
Face-to-Face Discussions
How often do you have to have face-to-face discussions with individuals or teams in this job?
Telephone
How often do you have telephone conversations in this job?
Importance of Being Exact or Accurate
How important is being very exact or highly accurate in performing this job?
Freedom to Make Decisions
How much decision making freedom, without supervision, does the job offer?
Importance of Repeating Same Tasks
How important is repeating the same physical activities (e.g., key entry) or mental activities (e.g., checking entries in a ledger) over and over, without stopping, to performing this job?
Work With Work Group or Team
How important is it to work with others in a group or team in this job?
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?
Education
Majors
Major
Interests
Investigative
77%
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
58%
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
53%
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.
Artistic
39%
Artistic occupations frequently involve working with forms, designs and patterns. They often require self-expression and the work can be done without following a clear set of rules.
Realistic
39%
Realistic occupations frequently involve work activities that include practical, hands-on problems and solutions. They often deal with plants, animals, and real-world materials like wood, tools, and machinery. Many of the occupations require working outside, and do not involve a lot of paperwork or working closely with others.
Social
24%
Social occupations frequently involve working with, communicating with, and teaching people. These occupations often involve helping or providing service to others.
Top 10 Work Styles
Analytical Thinking
98%
Job requires analyzing information and using logic to address work-related issues and problems.
Attention to Detail
94%
Job requires being careful about detail and thorough in completing work tasks.
Initiative
83%
Job requires a willingness to take on responsibilities and challenges.
Integrity
83%
Job requires being honest and ethical.
Dependability
81%
Job requires being reliable, responsible, and dependable, and fulfilling obligations.
Innovation
79%
Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.
Persistence
77%
Job requires persistence in the face of obstacles.
Achievement/Effort
76%
Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.
Cooperation
75%
Job requires being pleasant with others on the job and displaying a good-natured, cooperative attitude.
Leadership
75%
Job requires a willingness to lead, take charge, and offer opinions and direction.
Work Values
Achievement
86%
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.
Independence
77%
Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.
Working Conditions
77%
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
62%
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.
Support
53%
Occupations that satisfy this work value offer supportive management that stands behind employees. Corresponding needs are Company Policies, Supervision: Human Relations and Supervision: Technical.
Relationships
39%
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.