Careers

>

Information Technology

>

Network Systems

>

Database Administrators

Database Administrators

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.

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.

Demand
Career Demand by State Career Demand by State Legend
Core Tasks

Test programs or databases, correct errors, and make necessary modifications.

Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.

Modify existing databases and database management systems or direct programmers and analysts to make changes.

Specify users and user access levels for each segment of database.

Select and enter codes to monitor database performance and to create production database.

Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.

Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.

Review procedures in database management system manuals to make changes to database.

Revise company definition of data as defined in data dictionary.

Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.

Train users and answer questions.

Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.

Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.

Develop data model describing data elements and how they are used, following procedures and using pen, template, or computer software.

Technology Skills
Technology
Example
Hot Technology
Access software
Citrix
Accounting software
Fund accounting software
Administration software
SolarWinds
Analytical or scientific software
The MathWorks MATLAB
Application server software
Spring Boot
Backup or archival software
VERITAS NetBackup
Business intelligence and data analysis software
Tableau
Clustering software
Oracle Real Application Cluster RAC
Communications server software
IBM Domino
Computer aided design CAD software
Dassault Systemes CATIA
Computer based training software
Computer based training software
Configuration management software
VMWare
Content workflow software
Atlassian JIRA
Customer relationship management CRM software
Salesforce software
Data base management system software
Teradata Database
Data base reporting software
SAP Crystal Reports
Data base user interface and query software
Structured query language SQL
Data mining software
Google Analytics
Desktop communications software
Skype
Desktop publishing software
Microsoft Publisher
Development environment software
Ruby
Electronic mail software
Microsoft Outlook
Enterprise application integration software
Oracle Fusion Middleware
Enterprise resource planning ERP software
SAP Business Objects
Enterprise system management software
Splunk Enterprise
Expert system software
Ansible software
File versioning software
Git
Financial analysis software
Oracle E-Business Suite Financials
Graphical user interface development software
Salesforce Visualforce
Graphics or photo imaging software
Microsoft Visio
Human resources software
Oracle Taleo
Industrial control software
Supervisory control and data acquisition SCADA software
Information retrieval or search software
LexisNexis
Manufacturing execution system MES software
CA Easytrieve Report Generator
Map creation software
Geographic information system GIS software
Medical software
Epic Systems
Metadata management software
Visual Paradigm DB Visual ARCHITECT
Multi-media educational software
Nearpod
Network conferencing software
LogMeIn GoToWebinar
Network monitoring software
Wireshark
Network security and virtual private network VPN equipment software
Virtual private networking VPN software
Network security or virtual private network VPN management software
Database security software
Object or component oriented development software
Swift
Object oriented data base management software
Transact-SQL
Office suite software
Microsoft Office
Operating system software
UNIX Shell
Platform interconnectivity software
Amazon Web Services AWS CloudFormation
Portal server software
Apache HTTP Server
Presentation software
Microsoft PowerPoint
Program testing software
Selenium
Project management software
Oracle Primavera Enterprise Project Portfolio Management
Requirements analysis and system architecture software
Unified modeling language UML
Sales and marketing software
Marketo Marketing Automation
Spreadsheet software
Microsoft Excel
Storage networking software
Amazon Simple Storage Service S3
Transaction security and virus protection software
Symantec
Transaction server software
Customer information control system CICS
Video conferencing software
LogMeIn GoToMeeting
Web page creation and editing software
Adobe Systems Adobe Dreamweaver
Web platform development software
Spring Framework
Word processing software
Microsoft Word
Tools Used
Tool
Example
Components for information technology or broadcasting or telecommunications
Redundant array of independent disks RAID systems
Computer Equipment and Accessories
Notebook computers
Top 10 Knowledge Required
Computers and Electronics
90%
Importance

Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.

English Language
67%
Importance

Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.

Telecommunications
65%
Importance

Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.

Mathematics
63%
Importance

Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.

Clerical
60%
Importance

Knowledge of administrative and clerical procedures and systems such as word processing, managing files and records, stenography and transcription, designing forms, and other office procedures and terminology.

Communications and Media
60%
Importance

Knowledge of media production, communication, and dissemination techniques and methods. This includes alternative ways to inform and entertain via written, oral, and visual media.

Administration and Management
59%
Importance

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.

Education and Training
59%
Importance

Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.

Public Safety and Security
57%
Importance

Knowledge of relevant equipment, policies, procedures, and strategies to promote effective local, state, or national security operations for the protection of people, data, property, and institutions.

Customer and Personal Service
55%
Importance

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.

Top 10 Skills
Critical Thinking
78%
Importance

Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.

Complex Problem Solving
73%
Importance

Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.

Active Learning
70%
Importance

Understanding the implications of new information for both current and future problem-solving and decision-making.

Active Listening
70%
Importance

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.

Judgment and Decision Making
70%
Importance

Considering the relative costs and benefits of potential actions to choose the most appropriate one.

Reading Comprehension
70%
Importance

Understanding written sentences and paragraphs in work related documents.

Monitoring
68%
Importance

Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.

Programming
68%
Importance

Writing computer programs for various purposes.

Speaking
68%
Importance

Talking to others to convey information effectively.

Systems Analysis
68%
Importance

Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.

Top 10 Abilities
Deductive Reasoning
80%
Importance

The ability to apply general rules to specific problems to produce answers that make sense.

Information Ordering
80%
Importance

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
80%
Importance

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.

Inductive Reasoning
78%
Importance

The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).

Oral Comprehension
78%
Importance

The ability to listen to and understand information and ideas presented through spoken words and sentences.

Near Vision
73%
Importance

The ability to see details at close range (within a few feet of the observer).

Written Comprehension
73%
Importance

The ability to read and understand information and ideas presented in writing.

Flexibility of Closure
68%
Importance

The ability to identify or detect a known pattern (a figure, object, word, or sound) that is hidden in other distracting material.

Oral Expression
68%
Importance

The ability to communicate information and ideas in speaking so others will understand.

Speech Clarity
68%
Importance

The ability to speak clearly so others can understand you.

Top 10 Work Activities
Interacting With Computers
100%
Importance

Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.

Processing Information
89%
Importance

Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.

Analyzing Data or Information
87%
Importance

Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.

Making Decisions and Solving Problems
87%
Importance

Analyzing information and evaluating results to choose the best solution and solve problems.

Getting Information
85%
Importance

Observing, receiving, and otherwise obtaining information from all relevant sources.

Organizing, Planning, and Prioritizing Work
81%
Importance

Developing specific goals and plans to prioritize, organize, and accomplish your work.

Updating and Using Relevant Knowledge
80%
Importance

Keeping up-to-date technically and applying new knowledge to your job.

Documenting/Recording Information
79%
Importance

Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form.

Communicating with Supervisors, Peers, or Subordinates
78%
Importance

Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.

Identifying Objects, Actions, and Events
77%
Importance

Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.

Detailed Work Activities

Assess database performance.

Modify software programs to improve performance.

Develop computer or information security policies or procedures.

Implement security measures for computer or information systems.

Create databases to store electronic data.

Update computer database information.

Develop database parameters or specifications.

Write computer programming code.

Develop performance metrics or standards related to information technology.

Read documents to gather technical information.

Train others in computer interface or software use.

Develop detailed project plans.

Coordinate software or hardware installation.

Analyze market or customer related data.

Analyze data to identify trends or relationships among variables.

Develop models of information or communications systems.

Evaluate utility of software or hardware technologies.

Provide recommendations to others about computer hardware.

Install computer software.

Provide technical support for software maintenance or use.

Test computer system operations to ensure proper functioning.

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?

Work With Work Group or Team

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

Coordinate or Lead Others

How important is it to coordinate or lead others in accomplishing work activities in this job?

Spend Time Sitting

How much does this job require sitting?

Importance of Being Exact or Accurate

How important is being very exact or highly accurate in performing 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?

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

Education
Majors
Major
Computer and Information Sciences, General
Computer Software and Media Applications
Computer/Information Technology Administration and Management
Interests
Conventional
100%
Importance

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.

Investigative
77%
Importance

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.

Enterprising
53%
Importance

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.

Realistic
48%
Importance

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.

Artistic
34%
Importance

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.

Social
34%
Importance

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
Attention to Detail
94%
Importance

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

Analytical Thinking
92%
Importance

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

Integrity
90%
Importance

Job requires being honest and ethical.

Cooperation
88%
Importance

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

Dependability
88%
Importance

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

Persistence
84%
Importance

Job requires persistence in the face of obstacles.

Self Control
84%
Importance

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

Adaptability/Flexibility
82%
Importance

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

Independence
82%
Importance

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.

Initiative
82%
Importance

Job requires a willingness to take on responsibilities and challenges.

Work Values
Support
72%
Importance

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

Working Conditions
72%
Importance

Occupations that satisfy this work value offer job security and good working conditions. Corresponding needs are Activity, Compensation, Independence, Security, Variety and Working Conditions.

Achievement
67%
Importance

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.

Recognition
62%
Importance

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
53%
Importance

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.

Independence
48%
Importance

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