15-1242.00Apprenticeship

Database Administrators

Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. Identify, investigate, and resolve database performance issues, database capacity, and database scalability. May plan, coordinate, and implement security measures to safeguard computer databases.

Career Cluster:Digital Technology
Job Family:Computer and Mathematical
Job Zone:Job Zone Four: Considerable Preparation Needed
STEM:Research, Development, Design, and Practitioners
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 AngularHibernate ORMHypertext markup language HTMLIBM DB2IBM SPSS StatisticsInformatica softwareJavaScriptJavaScript Object Notation JSONjQueryJUnitLinuxMarketo Marketing AutomationMicrosoft 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 WordPostgreSQLMongoDBSplunk 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

  • Modify existing databases and database management systems or direct programmers and analysts to make changes.
  • Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
  • Plan and install upgrades of database management system software to enhance database performance.
  • Specify users and user access levels for each segment of database.
  • Test changes to database applications or systems.
  • Test programs or databases, correct errors, and make necessary modifications.
  • Train users and answer questions.
  • Provide technical support to junior staff or clients.
  • Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.
  • Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
  • Develop data models describing data elements and how they are used, following procedures and using pen, template, or computer software.
  • Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
  • Select and enter codes to monitor database performance and to create production databases.
  • Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
  • Review procedures in database management system manuals to make changes to database.
  • Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
  • Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
  • Revise company definition of data as defined in data dictionary.

Skills

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

Knowledge

Computers and Electronics
95%
English Language
74%
Customer and Personal Service
73%
Mathematics
64%
Telecommunications
64%
Engineering and Technology
63%
Administration and Management
53%
Education and Training
52%
Design
45%
Economics and Accounting
43%
Communications and Media
39%
Public Safety and Security
39%
Personnel and Human Resources
38%
Law and Government
36%
Administrative
34%
Production and Processing
28%
Transportation
25%
Psychology
22%
Sales and Marketing
18%
Mechanical
17%
Medicine and Dentistry
17%
Physics
15%
Geography
13%
Foreign Language
9%
Building and Construction
8%
History and Archeology
7%
Chemistry
7%
Sociology and Anthropology
5%
Biology
4%
Philosophy and Theology
3%
Therapy and Counseling
2%
Fine Arts
1%
Food Production
1%

Build a Resume for Database Administrators

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

Create Resume

Abilities

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

Work Activities

Working with Computers
96%
Making Decisions and Solving Problems
80%
Identifying Objects, Actions, and Events
78%
Getting Information
78%
Analyzing Data or Information
75%
Processing Information
73%
Establishing and Maintaining Interpersonal Relationships
72%
Communicating with Supervisors, Peers, or Subordinates
71%
Evaluating Information to Determine Compliance with Standards
69%
Thinking Creatively
68%
Updating and Using Relevant Knowledge
67%
Organizing, Planning, and Prioritizing Work
66%
Documenting/Recording Information
65%
Interpreting the Meaning of Information for Others
62%
Resolving Conflicts and Negotiating with Others
61%
Monitoring Processes, Materials, or Surroundings
61%
Scheduling Work and Activities
59%
Developing Objectives and Strategies
58%
Coordinating the Work and Activities of Others
52%
Estimating the Quantifiable Characteristics of Products, Events, or Information
51%
Training and Teaching Others
50%
Providing Consultation and Advice to Others
48%
Developing and Building Teams
48%
Assisting and Caring for Others
46%
Monitoring and Controlling Resources
45%
Judging the Qualities of Objects, Services, or People
42%
Communicating with People Outside the Organization
40%
Coaching and Developing Others
30%
Performing Administrative Activities
30%
Inspecting Equipment, Structures, or Materials
29%
Guiding, Directing, and Motivating Subordinates
28%
Repairing and Maintaining Electronic Equipment
25%
Staffing Organizational Units
23%
Controlling Machines and Processes
22%
Selling or Influencing Others
20%
Operating Vehicles, Mechanized Devices, or Equipment
13%
Repairing and Maintaining Mechanical Equipment
13%
Drafting, Laying Out, and Specifying Technical Devices, Parts, and Equipment
12%
Performing General Physical Activities
11%
Handling and Moving Objects
10%
Performing for or Working Directly with the Public
3%

Work Context

E-Mail

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

98%

Indoors, Environmentally Controlled

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

94%

Telephone Conversations

How often do you have telephone conversations in this job?

90%

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?

90%

Freedom to Make Decisions

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

87%

Importance of Being Exact or Accurate

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

84%

Spend Time Sitting

How much does this job require sitting?

83%

Determine Tasks, Priorities and Goals

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

81%

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?

78%

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?

73%

Consequence of Error

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

72%

Spend Time Making Repetitive Motions

How much does this job require making repetitive motions?

72%

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?

65%

Work Outcomes and Results of Other Workers

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

62%

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?

60%

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?

57%

Face-to-Face Discussions with Individuals and Within Teams

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

55%

Duration of Typical Work Week

Number of hours typically worked in one week.

51%

Spend Time Standing

How much does this job require standing?

50%

Time Pressure

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

50%

Written Letters and Memos

How frequently does your job require written letters and memos?

50%

Level of Competition

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

44%

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?

42%

Degree of Automation

How automated is the job?

41%

Conflict Situations

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

36%

Physical Proximity

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

35%

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%

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?

28%

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?

28%

Health and Safety of Other Workers

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

27%

Spend Time Bending or Twisting Your Body

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

22%

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)?

17%

Public Speaking

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

15%

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?

15%

Spend Time Kneeling, Crouching, Stooping, or Crawling

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

14%

Spend Time Walking or Running

How much does this job require walking or running?

12%

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)?

9%

Dealing with Violent or Physically Aggressive People

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

6%

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

5%

Exposed to High Places

How often does this job require exposure to high places?

4%

Work Schedules

How regular are the work schedules for this job?

4%

Exposed to Contaminants

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

3%

Outdoors, Exposed to All Weather Conditions

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

3%

Outdoors, Under Cover

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

3%

Exposed to Cramped Work Space, Awkward Positions

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

2%

Exposed to Extremely Bright or Inadequate Lighting Conditions

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

2%

Exposed to Hazardous Equipment

How often does this job require exposure to hazardous equipment?

2%

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?

2%

Spend Time Climbing Ladders, Scaffolds, or Poles

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

2%

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?

2%

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%

In an Open Vehicle or Operating Equipment

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

1%

Spend Time Keeping or Regaining Balance

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

1%

Exposed to Minor Burns, Cuts, Bites, or Stings

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

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%

Education

Bachelor's degree

89%

Post-baccalaureate certificate

4%

Associate's degree

3%

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

93

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

63

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

31

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

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.

21

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,

5

Work Styles

Attention to Detail
100%
Dependability
88%
Cautiousness
82%
Integrity
77%
Intellectual Curiosity
73%
Achievement Orientation
59%
Adaptability
57%
Perseverance
56%
Initiative
49%
Tolerance for Ambiguity
44%
Innovation
41%
Cooperation
40%
Stress Tolerance
40%
Self-Confidence
38%
Self-Control
38%
Leadership Orientation
30%
Sincerity
18%
Humility
11%
Social Orientation
9%
Optimism
4%

Work Values

Support
67%
Working Conditions
67%
Achievement
61%
Recognition
56%
Relationships
45%
Independence
39%

Ready to pursue a career as Database Administrators?

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

Build Your Resume Now