Occupation

Database Administrators

Human Advantage 66%

Significant human skills needed

AI Automation Risk Moderate Risk
3.5 / 10

Some tasks in this role may be augmented by AI, but human oversight and interpersonal skills remain important.

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.

Also Known As: Administrator (Admin), Automatic Data Processing Planner (ADP Planner), Cyber Database Administrator (Cyber DBA), Data Administrator (Data Admin), Data Management Associate, Data Management IT Specialist (Data Management Information Technology Specialist), Data Miner, Data Recovery Planner +31 more

Video

Core Tasks

  1. Modify existing databases and database management systems or direct programmers and analysts to make changes.
  2. Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
  3. Plan and install upgrades of database management system software to enhance database performance.
  4. Specify users and user access levels for each segment of database.
  5. Test changes to database applications or systems.
  6. Test programs or databases, correct errors, and make necessary modifications.
  7. Train users and answer questions.
  8. Provide technical support to junior staff or clients.
  9. Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
  10. Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.
  11. Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
  12. Develop data models describing data elements and how they are used, following procedures and using pen, template, or computer software.
  13. Select and enter codes to monitor database performance and to create production databases.
  14. Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
  15. Review procedures in database management system manuals to make changes to database.

Supplemental Tasks (3)

  1. Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
  2. Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
  3. Revise company definition of data as defined in data dictionary.

Education & Training

Job Zone 4 Job Zone Four: Considerable Preparation Needed
Education: Most of these occupations require a four-year bachelor's degree, but some do not.
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.
On-the-Job Training: Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.

Education Level Distribution

Percentage of workers in this occupation with each education level.

Bachelor's Degree
89%
Post-Baccalaureate Certificate - awarded for completion of an organized program of study; designed for people who have completed a Baccalaureate degree but do not meet the requirements of academic degrees carrying the title of Master.
4%
Associate's Degree (or other 2-year degree)
3%
Some College Courses
2%
Master's Degree
1%
Post-Secondary Certificate - awarded for training completed after high school (for example, in agriculture or natural resources, computer services, personal or culinary services, engineering technologies, healthcare, construction trades, mechanic and repair technologies, or precision production)
0%

Technology & Tools

Hot Technologies

  • AJAX
  • Amazon DynamoDB
  • Amazon Elastic Compute Cloud EC2
  • Amazon Redshift
  • Amazon Simple Storage Service S3
  • Amazon Web Services AWS CloudFormation
  • Amazon Web Services AWS software
  • Ansible software
  • Apache Cassandra
  • Apache Hadoop
  • Apache Hive
  • Apache Kafka
  • Apache Maven
  • Apache Spark
  • Apache Subversion SVN
  • Apache Tomcat
  • Apple macOS
  • Atlassian Bamboo
  • Atlassian Confluence
  • Atlassian JIRA
  • Autodesk Revit
  • Bash
  • C
  • C#
  • C++
  • Cascading style sheets CSS
  • Chef
  • Cisco Webex
  • Django
  • Docker
  • Drupal
  • ESRI ArcGIS software
  • Eclipse IDE
  • Elasticsearch
  • Epic Systems
  • Extensible markup language XML
  • Git
  • GitHub
  • Go
  • Google Analytics
  • Google Angular
  • Hibernate ORM
  • Hypertext markup language HTML
  • IBM DB2
  • IBM SPSS Statistics
  • Informatica software
  • JUnit
  • JavaScript
  • JavaScript Object Notation JSON
  • Linux
  • Marketo Marketing Automation
  • Microsoft .NET Framework
  • Microsoft ASP.NET
  • Microsoft Access
  • Microsoft Active Server Pages ASP
  • Microsoft Azure software
  • Microsoft Dynamics
  • Microsoft Excel
  • Microsoft Office software
  • Microsoft Outlook
  • Microsoft Power BI
  • Microsoft PowerPoint
  • Microsoft PowerShell
  • Microsoft Project
  • Microsoft SQL Server
  • Microsoft SQL Server Integration Services SSIS
  • Microsoft SQL Server Reporting Services SSRS
  • Microsoft SharePoint
  • Microsoft Visio
  • Microsoft Visual Basic
  • Microsoft Visual Basic for Applications VBA
  • Microsoft Visual Studio
  • Microsoft Windows
  • Microsoft Windows Server
  • Microsoft Word
  • MongoDB
  • MySQL
  • NoSQL
  • Node.js
  • Oracle Database
  • Oracle Java
  • Oracle JavaServer Pages JSP
  • Oracle PL/SQL
  • Oracle PeopleSoft
  • Oracle Primavera Enterprise Project Portfolio Management
  • Oracle SQL Developer
  • PHP
  • Perl
  • PostgreSQL
  • Puppet
  • Python
  • R
  • Red Hat Enterprise Linux
  • Red Hat OpenShift
  • Ruby
  • Ruby on Rails
  • SAP software
  • SAS
  • Salesforce software
  • Scala
  • Selenium
  • Shell script
  • Splunk Enterprise
  • Spring Boot
  • Spring Framework
  • Structured query language SQL
  • Swift
  • Tableau
  • Teradata Database
  • The MathWorks MATLAB
  • Transact-SQL
  • UNIX
  • UNIX Shell
  • jQuery

Software (285)

  • ADO.NET
  • ASG Technologies ASG-Zeke
  • Ab Initio
  • Access management software
  • Acronis Recovery Expert
  • Adobe Dreamweaver
  • Advanced business application programming ABAP
  • Amazon Data Pipeline
  • Apache Airflow
  • Apache Ant
  • Apache Groovy
  • Apache HTTP Server
  • Apache Mahout
  • Apache Pig
  • Apache Solr
  • Apache Sqoop
  • Apache Struts
  • BMC Software Change Manager
  • BMC Software Control-M
  • BMC Software Recovery Manager RMAN
  • Backbone.js
  • Blackbaud The Raiser's Edge
  • Blackboard software
  • CA Easytrieve Report Generator
  • CA IDMS
  • Catalog navigation software
  • Citrix cloud computing software
  • Cluster server software
  • Common business oriented language COBOL
  • Computer Associates Log Analyzer
  • Computer based training software
  • Concurrency control software
  • Couchbase Server
  • Customer information control system CICS
  • DOS shell script
  • Dassault Systemes CATIA
  • Data definition language DDL
  • Data dictionary software
  • Data manipulation language DML
  • Data mapping software
  • Data modeling software
  • Data transformation services DTS software
  • Data validation software
  • Database capacity planning software
  • Database cloning software
  • Database design software
  • Database security software
  • Database software
  • Database testing software
  • Delphi Technology
  • Deployment software
  • Dynamic hypertext markup language DHTML
  • EMC NetWorker
  • Ellucian Banner ERP
  • Embarcadero Technologies DBArtisan
  • Encryption software
  • Enterprise JavaBeans
  • Ext JS
  • Extensible hypertext markup language XHTML
  • FileMaker Pro
  • Fund accounting software
  • Geographic information system GIS software
  • Google Meet
  • Greenplum Database
  • HP DataProtector
  • Hewlett Packard HP-UX
  • Hewlett Packard LoadRunner
  • Human resource management software HRMS
  • IBM ADSTAR
  • IBM Cognos Impromptu
  • IBM Domino
  • IBM InfoSphere DataStage
  • IBM Informix
  • IBM Interactive System Productivity Facility ISPF
  • IBM Notes
  • IBM Power Systems software
  • IBM Rational Data Architect
  • IBM WebSphere
  • Index tuning software
  • Informatica Big Data
  • Informatica Corporation PowerCenter
  • Integrated development environment IDE software
  • Job control language JCL
  • Jupyter Notebook
  • KornShell
  • LAMP Stack
  • LexisNexis
  • LogMeIn GoToMeeting
  • LogMeIn GoToWebinar
  • MapR Converged Data Platform
  • MariaDB
  • McAfee
  • Micosoft SQL Server Analysis Services SSAS
  • MicroStrategy
  • Microsoft ASP.NET Core MVC
  • Microsoft ActiveX
  • Microsoft Dynamics GP
  • Microsoft Exchange
  • Microsoft Publisher
  • Microsoft Visual Basic Scripting Edition VBScript
  • Microsoft Visual Basic.NET
  • Microsoft Visual C# .NET
  • Minitab
  • Nagios
  • Nearpod
  • NetSuite ERP
  • NortonLifeLock cybersecurity software
  • Object database management system ODBMS
  • Operating system software
  • Oracle Application Express APEX
  • Oracle Business Intelligence Enterprise Edition
  • Oracle Data Guard
  • Oracle Designer
  • Oracle E-Business Suite Financials
  • Oracle Eloqua
  • Oracle Enterprise Manager
  • Oracle Enterprise Manager Cloud Control
  • Oracle Fusion Applications
  • Oracle Fusion Middleware
  • Oracle Golden Gate
  • Oracle Hyperion
  • Oracle JD Edwards EnterpriseOne
  • Oracle JDBC
  • Oracle Learning Management
  • Oracle PeopleSoft Financials
  • Oracle Real Application Cluster RAC
  • Oracle Reports
  • Oracle SQL Loader
  • Oracle SQL Plus
  • Oracle Solaris
  • Oracle Taleo
  • Oracle WebLogic Server
  • Pentaho Kettle
  • Perforce Helix software
  • Prolog
  • Qlik Tech QlikView
  • Quest Central
  • Quest Erwin Data Modeler
  • Quest SharePlex
  • ReCrystallize Crystal Reports
  • Red Hat Ansible Engine
  • Red Hat WildFly
  • Redgate SQL Server
  • Relational database management software
  • Relational database management system software
  • Restructured extended executor REXX
  • SAP Adaptive Server Enterprise
  • SAP Business Objects
  • SAP Crystal Reports
  • SAP PowerBuilder
  • SAP Replication Server
  • Safe Software FME
  • Salesforce Visualforce
  • SentryOne SQL Sentry
  • Skype
  • SolarWinds
  • StataCorp Stata
  • Storage area network SAN software
  • Storage management software
  • Supervisory control and data acquisition SCADA software
  • Systems and data disaster recovery software
  • Teradata Active Enterprise Data Warehouse
  • Test data generator software
  • Ubuntu
  • Unified modeling language UML
  • VMware
  • Veritas NetBackup
  • Virtual private networking VPN software
  • Visual Paradigm DB Visual ARCHITECT
  • Wireshark
  • Zabbix

Tools & Equipment (6)

  • Desktop computers
  • Hard disk drives
  • Mainframe computers
  • Notebook computers
  • Redundant array of independent disks RAID systems
  • Tape libraries

Resume Builder

Select key tasks to generate action-oriented resume bullets for Database Administrators positions.

Related Occupations

Show all 20 related occupations

Real Talk

Hear from real Database Administratorss about their work: