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.
Sample of reported job titles:
Database Administration Manager, Database Administrator (DBA), Database Analyst, Database Coordinator, Database Engineer, Database Manager, Development and Database Administration Manager, IS Admin (Information Systems Administrator), Systems Administrator (Systems Admin)
You will be leaving O*NET OnLine to visit our sister site My Next Move. You can return by using the Back button in your browser, or by choosing “O*NET OnLine” from the O*NET Sites menu at the bottom of any page in My Next Move.
You will be leaving O*NET OnLine to visit our sister site My Next Move for Veterans. You can return by using the Back button in your browser, or by choosing “O*NET OnLine” from the O*NET Sites menu at the bottom of any page in My Next Move for Veterans.
Saldrá de O*NET OnLine para visitar nuestro sitio afiliado Mi Próximo Paso. Puede regresar usando el botón Atrás en su navegador, o eligiendo “O*NET OnLine” en el menú Sitios O*NET en la parte inferior de cualquier página en Mi Próximo Paso.
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.
-
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 standards and guidelines for the use and acquisition of software and to protect vulnerable information.
-
Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
-
Develop data models describing data elements and how they are used, following procedures and using pen, template, or computer software.
-
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.
back to top
Technology Skills
-
Access software — Access management software; Citrix cloud computing software
-
Accounting software — Fund accounting software
-
Administration software — Redgate SQL Server
-
Analytical or scientific software — IBM SPSS Statistics
; Minitab; SAS
; The MathWorks MATLAB
; 3 more
-
Application server software — Docker
; GitHub
; Red Hat OpenShift
; Spring Boot
; 2 more
-
Backup or archival software — Acronis Recovery Expert; EMC NetWorker; HP DataProtector; Veritas NetBackup
; 6 more
-
Business intelligence and data analysis software — Apache Spark
; IBM Cognos Impromptu; Microsoft Power BI
; Tableau
; 4 more
-
Cloud-based data access and sharing software — Microsoft SharePoint
-
Cloud-based management software — Amazon Web Services AWS CloudFormation
; IBM WebSphere; Splunk Enterprise
-
Cloud-based protection or security software — SolarWinds
-
Clustering software — Cluster server software; Oracle Real Application Cluster RAC; VMware
-
Communications server software — IBM Domino
-
Computer aided design CAD software — Autodesk Revit
; Dassault Systemes CATIA
-
Computer based training software
-
Configuration management software — Chef
; Perforce Helix software; Puppet
; Red Hat Ansible Engine
; 1 more
-
Content workflow software — Atlassian JIRA
-
Customer relationship management CRM software — Blackbaud The Raiser's Edge; Oracle Eloqua; Salesforce software
-
Data base management system software — Amazon DynamoDB
; Elasticsearch
; MongoDB
; Oracle PL/SQL
; 35 more
-
Data base reporting software — Microsoft SQL Server Reporting Services SSRS
; Oracle Reports; Oracle SQL Plus; SAP Crystal Reports
; 3 more
-
Data base user interface and query software — Apache Hive
; Blackboard software; IBM DB2
; MySQL
; 11 more
-
Data mining software — Google Analytics
-
Desktop communications software — Skype
-
Desktop publishing software — Microsoft Publisher
-
Development environment software — Apache Kafka
; Apache Maven
; Go
; Oracle SQL Developer
; 15 more
-
Electronic mail software — IBM Notes; Microsoft Exchange; Microsoft Outlook
-
Enterprise application integration software — Atlassian Bamboo
; Extensible markup language XML
; IBM InfoSphere DataStage; Microsoft SQL Server Integration Services SSIS
; 2 more
-
Enterprise resource planning ERP software — Microsoft Dynamics
; Oracle JD Edwards EnterpriseOne; Oracle PeopleSoft
; SAP software
; 9 more
-
Enterprise system management software — IBM Power Systems software
-
Expert system software — Ansible software
; Apache Mahout
-
File versioning software — Apache Subversion SVN
; Git
-
Financial analysis software — Delphi Technology; Oracle E-Business Suite Financials
-
Geographic information system — ESRI ArcGIS software
; Geographic information system GIS software
-
Graphical user interface development software — Salesforce Visualforce
-
Human resources software — Human resource management software HRMS; Oracle Learning Management; Oracle Taleo
-
Industrial control software — Supervisory control and data acquisition SCADA software
-
Information retrieval or search software — Data validation software; LexisNexis
-
Manufacturing execution system MES software — CA Easytrieve Report Generator
-
Medical software — Epic Systems
-
Metadata management software — IBM Rational Data Architect; Informatica software
; Pentaho Kettle; Quest Erwin Data Modeler
; 3 more
-
Multi-media educational software — Nearpod
-
Network conferencing software — LogMeIn GoToWebinar
-
Network monitoring software — Nagios; Wireshark; Zabbix
-
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 — C#
; jQuery
; Scala
; Swift
; 12 more
-
Object oriented data base management software — Hibernate ORM
; IBM Informix; PostgreSQL
; Transact-SQL
; 1 more
-
Office suite software — Microsoft Office software
-
Operating system software — Bash
; Microsoft Windows Server
; Red Hat Enterprise Linux
; UNIX Shell
; 11 more
-
Portal server software — Apache HTTP Server
-
Presentation software — Microsoft PowerPoint
-
Procedure management software — Apache Airflow
-
Process mapping and design software — Microsoft Visio
; Visual Paradigm DB Visual ARCHITECT
-
Program testing software — Database testing software; Hewlett Packard LoadRunner; JUnit
; Selenium
; 1 more
-
Project management software — Atlassian Confluence
; Microsoft Project
; Oracle Primavera Enterprise Project Portfolio Management
-
Requirements analysis and system architecture software — Database capacity planning software; Unified modeling language UML
-
Sales and marketing software — Marketo Marketing Automation
-
Spreadsheet software — Microsoft Excel
-
Storage networking software — Amazon Simple Storage Service S3
; Storage area network SAN software
-
Transaction security and virus protection software — Encryption software; McAfee; NortonLifeLock cybersecurity software
-
Transaction server software — Customer information control system CICS
-
Video conferencing software — Cisco Webex
; Google Meet; LogMeIn GoToMeeting
-
Web page creation and editing software — Adobe Dreamweaver
-
Web platform development software — Django
; Google Angular
; Microsoft ASP.NET
; Spring Framework
; 22 more
-
Word processing software — Microsoft Word
Hot Technologies are requirements most frequently included across all employer job postings.
In Demand skills are frequently included in employer job postings for this occupation.
back to top
Work Activities
-
Working with Computers — Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
-
Making Decisions and Solving Problems — Analyzing information and evaluating results to choose the best solution and solve problems.
-
Getting Information — Observing, receiving, and otherwise obtaining information from all relevant sources.
-
Identifying Objects, Actions, and Events — Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
-
Analyzing Data or Information — Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
-
Processing Information — Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
-
Establishing and Maintaining Interpersonal Relationships — Developing constructive and cooperative working relationships with others, and maintaining them over time.
-
Communicating with Supervisors, Peers, or Subordinates — Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
-
Evaluating Information to Determine Compliance with Standards — Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.
-
Thinking Creatively — Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
-
Updating and Using Relevant Knowledge — Keeping up-to-date technically and applying new knowledge to your job.
-
Organizing, Planning, and Prioritizing Work — Developing specific goals and plans to prioritize, organize, and accomplish your work.
-
Documenting/Recording Information — Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form.
-
Interpreting the Meaning of Information for Others — Translating or explaining what information means and how it can be used.
-
Monitoring Processes, Materials, or Surroundings — Monitoring and reviewing information from materials, events, or the environment, to detect or assess problems.
-
Resolving Conflicts and Negotiating with Others — Handling complaints, settling disputes, and resolving grievances and conflicts, or otherwise negotiating with others.
-
Scheduling Work and Activities — Scheduling events, programs, and activities, as well as the work of others.
-
Developing Objectives and Strategies — Establishing long-range objectives and specifying the strategies and actions to achieve them.
-
Coordinating the Work and Activities of Others — Getting members of a group to work together to accomplish tasks.
-
Estimating the Quantifiable Characteristics of Products, Events, or Information — Estimating sizes, distances, and quantities; or determining time, costs, resources, or materials needed to perform a work activity.
-
Training and Teaching Others — Identifying the educational needs of others, developing formal educational or training programs or classes, and teaching or instructing others.
back to top
Detailed Work Activities
-
Create databases to store electronic data.
-
Update computer database information.
-
Implement security measures for computer or information systems.
-
Develop computer or information security policies or procedures.
-
Install computer software.
-
Assess database performance.
-
Test computer system operations to ensure proper functioning.
-
Modify software programs to improve performance.
-
Train others in computer interface or software use.
-
Provide technical support for software maintenance or use.
-
Coordinate software or hardware installation.
-
Develop detailed project plans.
-
Develop performance metrics or standards related to information technology.
-
Develop database parameters or specifications.
-
Develop models of information or communications systems.
-
Write computer programming code.
-
Read documents to gather technical information.
-
Evaluate utility of software or hardware technologies.
-
Provide recommendations to others about computer hardware.
-
Analyze data to identify trends or relationships among variables.
-
Analyze market or customer related data.
back to top
Work Context
-
Electronic Mail — 92% responded “Every day.”
-
Indoors, Environmentally Controlled — 90% responded “Every day.”
-
-
Work With Work Group or Team
-
Freedom to Make Decisions — 56% responded “A lot of freedom.”
-
Importance of Being Exact or Accurate
-
Spend Time Sitting — 24% responded “More than half the time.”
-
Structured versus Unstructured Work
-
Contact With Others — 71% responded “Contact with others most of the time.”
-
Frequency of Decision Making — 70% responded “Once a week or more but not every day.”
-
-
Spend Time Making Repetitive Motions — 18% responded “About half the time.”
-
Coordinate or Lead Others
-
Responsibility for Outcomes and Results — 13% responded “Limited responsibility.”
-
Importance of Repeating Same Tasks — 25% responded “Important.”
-
Impact of Decisions on Co-workers or Company Results — 16% responded “Very important results.”
-
Face-to-Face Discussions — 16% responded “Once a week or more but not every day.”
-
Duration of Typical Work Week — 68% responded “40 hours.”
-
Letters and Memos — 20% responded “Once a year or more but not every month.”
-
Spend Time Standing — 26% responded “Less than half the time.”
-
Time Pressure — 22% responded “Once a week or more but not every day.”
back to top
Job Zone
- Title
- Job Zone Four: Considerable Preparation Needed
- Education
- Most of these occupations require a four-year bachelor's degree, but some do not.
- Related 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.
- Job Training
- Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.
- Job Zone Examples
- Many of these occupations involve coordinating, supervising, managing, or training others. Examples include real estate brokers, sales managers, database administrators, graphic designers, conservation scientists, art directors, and cost estimators.
- SVP Range
- (7.0 to < 8.0)
back to top
Training & Credentials
- State training
-
- Local training
-
- Certifications
-
back to top
Apprenticeship Opportunities
Example apprenticeship titles for this occupation:
Specific title(s) listed above are vetted by industry and approved by the U.S. Department of Labor for use in a Registered Apprenticeship Program.
back to top
Skills
-
Complex Problem Solving — Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
-
Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
-
Active Listening — 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 — Considering the relative costs and benefits of potential actions to choose the most appropriate one.
-
Reading Comprehension — Understanding written sentences and paragraphs in work-related documents.
-
Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making.
-
Programming — Writing computer programs for various purposes.
-
Speaking — Talking to others to convey information effectively.
-
Monitoring — Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
-
Writing — Communicating effectively in writing as appropriate for the needs of the audience.
-
Operations Analysis — Analyzing needs and product requirements to create a design.
-
Systems Analysis — Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
-
Systems Evaluation — Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
-
Coordination — Adjusting actions in relation to others' actions.
-
Instructing — Teaching others how to do something.
-
Learning Strategies — Selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new things.
-
Mathematics — Using mathematics to solve problems.
back to top
Knowledge
-
Computers and Electronics — Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
-
English Language — Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
-
Customer and Personal Service — 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.
-
Mathematics — Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
-
Telecommunications — Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.
-
Engineering and Technology — 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.
-
Administration and Management — 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 — Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.
back to top
Education
How much education does a new hire need to perform a job in this occupation? Respondents said:
back to top
Abilities
-
Deductive Reasoning — The ability to apply general rules to specific problems to produce answers that make sense.
-
Inductive Reasoning — The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
-
Information Ordering — 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).
-
Oral Comprehension — The ability to listen to and understand information and ideas presented through spoken words and sentences.
-
Problem Sensitivity — The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing that there is a problem.
-
Written Comprehension — The ability to read and understand information and ideas presented in writing.
-
Near Vision — The ability to see details at close range (within a few feet of the observer).
-
Oral Expression — The ability to communicate information and ideas in speaking so others will understand.
-
Category Flexibility — The ability to generate or use different sets of rules for combining or grouping things in different ways.
-
Written Expression — The ability to communicate information and ideas in writing so others will understand.
-
Flexibility of Closure — The ability to identify or detect a known pattern (a figure, object, word, or sound) that is hidden in other distracting material.
-
Speech Recognition — The ability to identify and understand the speech of another person.
-
Fluency of Ideas — The ability to come up with a number of ideas about a topic (the number of ideas is important, not their quality, correctness, or creativity).
-
Mathematical Reasoning — The ability to choose the right mathematical methods or formulas to solve a problem.
-
Speech Clarity — The ability to speak clearly so others can understand you.
-
Number Facility — The ability to add, subtract, multiply, or divide quickly and correctly.
-
Originality — The ability to come up with unusual or clever ideas about a given topic or situation, or to develop creative ways to solve a problem.
-
Perceptual Speed — The ability to quickly and accurately compare similarities and differences among sets of letters, numbers, objects, pictures, or patterns. The things to be compared may be presented at the same time or one after the other. This ability also includes comparing a presented object with a remembered object.
-
Selective Attention — The ability to concentrate on a task over a period of time without being distracted.
-
Visualization — The ability to imagine how something will look after it is moved around or when its parts are moved or rearranged.
back to top
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 human resources.
-
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 fields of humanities, mathematics/statistics, information technology, or health care service.
back to top
Work Values
-
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.
-
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.
-
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.
back to top
Work Styles
-
Attention to Detail — Job requires being careful about detail and thorough in completing work tasks.
-
Integrity — Job requires being honest and ethical.
-
Persistence — Job requires persistence in the face of obstacles.
-
Cooperation — Job requires being pleasant with others on the job and displaying a good-natured, cooperative attitude.
-
Dependability — Job requires being reliable, responsible, and dependable, and fulfilling obligations.
-
Analytical Thinking — Job requires analyzing information and using logic to address work-related issues and problems.
-
Initiative — Job requires a willingness to take on responsibilities and challenges.
-
Adaptability/Flexibility — Job requires being open to change (positive or negative) and to considerable variety in the workplace.
-
Achievement/Effort — Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.
-
Stress Tolerance — Job requires accepting criticism and dealing calmly and effectively with high-stress situations.
-
Self-Control — Job requires maintaining composure, keeping emotions in check, controlling anger, and avoiding aggressive behavior, even in very difficult situations.
-
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.
-
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.
-
Leadership — Job requires a willingness to lead, take charge, and offer opinions and direction.
back to top
Wages & Employment Trends
- Median wages (2023)
- $48.80 hourly, $101,510 annual
- State wages
-
- Local wages
-
- Employment (2023)
- 80,500 employees
- Projected growth (2023-2033)
-
Faster than average (6% to 8%)
- Projected job openings (2023-2033)
- 5,300
- State trends
-
- Top industries (2023)
-
Source: Bureau of Labor Statistics 2023 wage data
external site and 2023-2033 employment projections
external site.
“Projected growth” represents the estimated change in total employment over the projections period (2023-2033). “Projected job openings” represent openings due to growth and replacement.
back to top
Job Openings on the Web
- State job openings
-
- Local job openings
-
back to top
back to top
Professional Associations
Disclaimer:
Sources are listed to provide additional information on related jobs, specialties, and/or industries.
Links to non-DOL Internet sites are provided for your convenience and do not constitute an endorsement.
Actively assisted with the O*NET data collection, helping to identify occupational experts who can be surveyed about their work in the occupation.
View the list of Allies
National Associations
Accreditation, Certification, & Unions
back to top