Career Details
Career Details
Back to top

Career Details

15-1242.00 - 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.


Key Facts
Expand or Shrink Accordion
Bright Outlook
Career Details
Green Job
Career Details
Current Employment
N/A
Estimate
Forecasted Employment
N/A
Estimate
Change in Employment
N/A
Estimate
Change in Employment %
N/A
Estimate
Tasks
Expand or Shrink Accordion
Tasks
The tasks listed below can be performed to prepare you for a career in this field.
Core
  • Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.
  • Modify existing databases and database management systems or direct programmers and analysts to make changes.
  • 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.
  • Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
  • Train users and answer questions.
  • Specify users and user access levels for each segment of database.
  • Develop data model describing data elements and how they are used, following procedures and using pen, template, or computer software.
  • 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.
  • Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
  • 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.
Generic
  • Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
  • Plan and install upgrades of database management system software to enhance database performance.
  • Provide technical support to junior staff or clients.
  • Test changes to database applications or systems.
Supplemental
  • Select and enter codes to monitor database performance and to create production database.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Knowledge
Expand or Shrink Accordion
Knowledge

The items listed below are organized into sections that contain knowledge useful for pursuing a career in this field. Each section also contains a "Percentage of Importance" statistic that shows how relevant an item is to the occupation.
 Computers and Electronics
  • 89%
    Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
 English Language
  • 66%
    Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
 Telecommunications
  • 65%
    Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.
 Mathematics
  • 62%
    Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
 Clerical
  • 60%
    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%
    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%
    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%
    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%
    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%
    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.
 Psychology
  • 53%
    Knowledge of human behavior and performance; individual differences in ability, personality, and interests; learning and motivation; psychological research methods; and the assessment and treatment of behavioral and affective disorders.
 Engineering and Technology
  • 52%
    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.
 Law and Government
  • 51%
    Knowledge of laws, legal codes, court procedures, precedents, government regulations, executive orders, agency rules, and the democratic political process.
 Production and Processing
  • 50%
    Knowledge of raw materials, production processes, quality control, costs, and other techniques for maximizing the effective manufacture and distribution of goods.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Tools
Expand or Shrink Accordion
Tools
The tools listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.
 Media storage devices
  • Redundant array of independent disks RAID systems
  • Hard disk drives
  • Tape libraries
 Computers
  • Notebook computers
  • Desktop computers
  • Mainframe computers
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Technology
Expand or Shrink Accordion
Technology
The technologies listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.
 Business function specific software
  • Human resource management software HRMS
  • Oracle Learning Management
  • Oracle TaleoHOT
  • ConfluenceHOT
  • Microsoft ProjectHOT
  • Microsoft SharePointHOT
  • Oracle Primavera Enterprise Project Portfolio ManagementHOT
  • Ansible softwareHOT
  • Apache Mahout
  • Microsoft OfficeHOT
  • Marketo Marketing AutomationHOT
 Finance accounting and enterprise resource planning ERP software
  • Fund accounting software
  • Ab InitioHOT
  • Ellucian Banner ERPHOT
  • Informatica Corporation PowerCenterHOT
  • Microsoft DynamicsHOT
  • Microsoft Dynamics GPHOT
  • NetSuite ERPHOT
  • Oracle Fusion ApplicationsHOT
  • Oracle HyperionHOT
  • Oracle JD Edwards EnterpriseOneHOT
  • Oracle PeopleSoftHOT
  • Oracle PeopleSoft FinancialsHOT
  • SAPHOT
  • SAP Business ObjectsHOT
  • Delphi Technology
  • Oracle E-Business Suite Financials
 Content authoring and editing software
  • Adobe Systems Adobe Flash
  • Microsoft VisioHOT
  • Microsoft WordHOT
  • Microsoft PowerPointHOT
  • Adobe Systems Adobe Dreamweaver
  • Microsoft ExcelHOT
  • Microsoft Publisher
 Content management software
  • Atlassian JIRAHOT
  • Apache Subversion SVNHOT
  • GitHOT
 Data management and query software
  • Cluster server software
  • Oracle Real Application Cluster RAC
  • Blackbaud The Raiser's Edge
  • Oracle Eloqua
  • Salesforce softwareHOT
  • ADO.NET
  • Amazon DynamoDBHOT
  • Apache CassandraHOT
  • Apache HadoopHOT
  • Apache PigHOT
  • Apache SolrHOT
  • Apache Sqoop
  • BMC Software Change Manager
  • CA IDMS
  • Catalog navigation software
  • Concurrency control software
  • Couchbase Server
  • Data definition language DDL
  • Data manipulation language DML
  • Data transformation services DTS software
  • Database design software
  • ElasticsearchHOT
  • Embarcadero Technologies DBArtisan
  • Greenplum Database
  • IBM Interactive System Productivity Facility ISPF
  • Index tuning software
  • Informatica Big Data
  • MapR Converged Data Platform
  • MariaDB
  • MongoDBHOT
  • NoSQLHOT
  • Oracle Enterprise Manager
  • Oracle Enterprise Manager Cloud Control
  • Oracle Golden Gate
  • Oracle PL/SQLHOT
  • Quest Central
  • Quest SharePlex
  • Relational database management softwareHOT
  • SAP Adaptive Server Enterprise
  • SAP Replication Server
  • SentryOne SQL Sentry
  • Teradata DatabaseHOT
  • ASG Technologies ASG-Zeke
  • Microsoft SQL Server Reporting ServicesHOT
  • Oracle Reports
  • Oracle SQL Loader
  • Oracle SQL Plus
  • ReCrystallize Crystal Reports
  • SAP Crystal ReportsHOT
  • Amazon Elastic Compute Cloud EC2HOT
  • Amazon RedshiftHOT
  • Amazon Web Services AWS softwareHOT
  • Apache HiveHOT
  • Blackboard software
  • Data entry softwareHOT
  • FileMaker Pro
  • IBM DB2
  • Microsoft AccessHOT
  • Microsoft SQL ServerHOT
  • MySQLHOT
  • Oracle JDBCHOT
  • Oracle softwareHOT
  • Structured query language SQLHOT
  • Teradata Active Enterprise Data Warehouse
  • Google AnalyticsHOT
  • Data validation software
  • LexisNexis
  • CA Erwin Data Modeler
  • Data dictionary software
  • Data mapping software
  • Data modeling software
  • IBM Rational Data Architect
  • Pentaho Kettle
  • Visual Paradigm DB Visual ARCHITECT
  • Hibernate ORM
  • IBM Informix
  • Object database management system ODBMS
  • PostgreSQLHOT
  • Transact-SQLHOT
  • Apache HTTP ServerHOT
  • Customer information control system CICS
  • Apache SparkHOT
  • IBM Cognos ImpromptuHOT
  • Micosoft SQL Server Analysis Services SSAS
  • MicroStrategyHOT
  • Oracle Business Intelligence Enterprise EditionHOT
  • Qlik Tech QlikViewHOT
  • TableauHOT
 Development software
  • Chef
  • Deployment software
  • Perforce Helix software
  • PuppetHOT
  • Red Hat Ansible Engine
  • VMWareHOT
  • Apache AntHOT
  • Apache KafkaHOT
  • Apache Maven
  • C
  • Common business oriented language COBOLHOT
  • Eclipse IDEHOT
  • GoHOT
  • Integrated development environment IDE softwareHOT
  • Microsoft .NET FrameworkHOT
  • Microsoft AzureHOT
  • Microsoft PowerShellHOT
  • Microsoft Visual BasicHOT
  • Microsoft Visual Basic Scripting Edition VBScriptHOT
  • Microsoft Visual Basic for Applications VBAHOT
  • Microsoft Visual StudioHOT
  • Prolog
  • Restructured extended executor REXX
  • RubyHOT
  • Atlassian BambooHOT
  • BMC Software Control-M
  • Extensible markup language XMLHOT
  • IBM InfoSphere DataStage
  • IBM WebSphereHOT
  • Microsoft SQL Server Integration Services SSISHOT
  • Oracle Fusion MiddlewareHOT
  • Salesforce VisualforceHOT
  • Advanced business application programming ABAPHOT
  • Apache GroovyHOT
  • C#HOT
  • C++HOT
  • Jupyter Notebook
  • Microsoft ActiveX
  • Microsoft Visual Basic.NET
  • Microsoft Visual C# .NET
  • Oracle JavaHOT
  • Practical extraction and reporting language PerlHOT
  • PythonHOT
  • RHOT
  • SAP PowerBuilder
  • ScalaHOT
  • SwiftHOT
  • jQueryHOT
  • Computer Associates Log Analyzer
  • Database testing software
  • Hewlett Packard LoadRunner
  • JUnitHOT
  • SeleniumHOT
  • Database capacity planning software
  • Unified modeling language UMLHOT
  • AJAXHOT
  • Apache StrutsHOT
  • Apache TomcatHOT
  • Backbone.jsHOT
  • Cascading Style Sheets CSSHOT
  • DjangoHOT
  • DrupalHOT
  • Dynamic hypertext markup language DHTML
  • Enterprise JavaBeans
  • Ext JS
  • Extensible HyperText Markup Language XHTML
  • Google AngularJSHOT
  • Hypertext markup language HTMLHOT
  • JavaScriptHOT
  • JavaScript Object Notation JSONHOT
  • LAMP Stack
  • Microsoft ASP.NETHOT
  • Microsoft ASP.NET Core MVCHOT
  • Microsoft Active Server Pages ASPHOT
  • Node.jsHOT
  • Oracle Application Express APEX
  • Oracle Designer
  • Oracle JavaServer Pages JSPHOT
  • PHP: Hypertext PreprocessorHOT
  • Ruby on RailsHOT
  • Spring FrameworkHOT
 Educational or reference software
  • Computer based training software
  • Nearpod
 Industry specific software
  • Autodesk RevitHOT
  • Dassault Systemes CATIAHOT
  • IBM SPSS StatisticsHOT
  • MinitabHOT
  • SASHOT
  • Safe Software FME
  • StataCorp Stata
  • Test data generator software
  • The MathWorks MATLABHOT
  • Supervisory control and data acquisition SCADA softwareHOT
  • Epic SystemsHOT
  • CA Easytrieve Report Generator
 Network applications software
  • DockerHOT
  • GitHubHOT
  • Oracle WebLogic ServerHOT
  • Red Hat OpenShiftHOT
  • Red Hat WildFlyHOT
  • Spring BootHOT
  • Skype
 Network management software
  • NagiosHOT
  • WiresharkHOT
  • Zabbix
  • Redgate SQL Server
  • SolarWinds
 Networking software
  • Access management software
  • CitrixHOT
  • IBM Domino
  • Amazon Simple Storage Service S3HOT
  • Storage area network SAN software
  • Amazon Web Services AWS CloudFormationHOT
 Operating environment software
  • Apple macOSHOT
  • BashHOT
  • DOS shell script
  • Hewlett Packard HP-UX
  • Job control language JCL
  • Kornshell
  • LinuxHOT
  • Microsoft WindowsHOT
  • Microsoft Windows ServerHOT
  • Oracle SolarisHOT
  • Red Hat Enterprise LinuxHOT
  • Shell scriptHOT
  • UNIXHOT
  • UNIX ShellHOT
  • Ubuntu
 Security and protection software
  • Database security software
  • Virtual private networking VPN softwareHOT
  • Encryption software
  • McAfee
  • SymantecHOT
 Utility and device driver software
  • Acronis Recovery Expert
  • BMC Software Recovery Manager RMAN
  • Database cloning software
  • EMC NetWorker
  • HP DataProtector
  • IBM ADSTAR
  • Oracle Data Guard
  • Storage management software
  • Systems and data disaster recovery software
  • VERITAS NetBackup
 Information exchange software
  • IBM NotesHOT
  • Microsoft ExchangeHOT
  • Microsoft OutlookHOT
  • Cisco Systems Webex
  • Google Meet
  • LogMeIn GoToMeeting
  • LogMeIn GoToWebinar
  • ESRI ArcGIS softwareHOT
  • Geographic information system GIS softwareHOT
 System management software
  • IBM Power Systems software
  • Splunk EnterpriseHOT
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Certifications
Expand or Shrink Accordion
Certifications
The certifications listed below are useful to pursue if you are interested in a career in this field.
No specific certifications are listed for this career
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Licensing
Expand or Shrink Accordion
Licensing
The licensing information below is organized into sections and is useful for pursuing if you are interested in a career in this field.
No specific licensing information is listed for this occupation in the area you have selected.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Related Programs
Expand or Shrink Accordion
Programs related to this career, offered by participating institution(s), are listed below.

Clicking on the Degree programs in the list below will take you away from the Careers page.
INSTITUTION
PROGRAMS
Peirce College
Jobs
Expand or Shrink Accordion
Jobs related to this career may be found on Indeed.com or on the Google Job Search page.