Database Administrators

Information Technology > Network Systems

Projected Growth: Faster than average

9700+
Projected Job Openings

Considerable Preparation Needed

Job Description

Your job is to Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases.

Common job titles of Database Administrators include:
.

Experience and Education

A considerable amount of work-related skill, knowledge, or experience is needed for this occupation. For example, a person in this occupation must complete four years of college and work for several years in industry to be considered qualified.

  • 76.59% said they needed a Bachelor's Degree.

  • 10.78% said they needed a First Professional Degree.

Tasks

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

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

    Review procedures in database management system manuals for making changes to database.

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

    Train users and answer questions.

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

    Work as part of a project team to coordinate database development and determine project scope and limitations.

    Review project requests describing database user needs to estimate time and cost required to accomplish project.

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

    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.

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

    Revise company definition of data as defined in data dictionary.

    Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.

    Establish and calculate optimum values for database parameters, using manuals and calculator.

    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.

Tools

Tape libraries

Redundant array of independent disks RAID systems

Notebook computers

Mainframe computers

Hard disk drives

Desktop computers

Technologies

Ab Initio

Advanced business application programming ABAP

AJAX

Amazon Redshift

Ansible software

Apache Ant

Apache Cassandra

All Technologies

Apache Groovy

Apache Hadoop

Apache HTTP Server

Apache Kafka

Apache Solr

Apache Struts

Apache Subversion SVN

Apache Tomcat

Apple macOS

Atlassian Bamboo

Atlassian JIRA

Autodesk Revit

Bash

C#

Citrix

Common business oriented language COBOL

Confluence

Django

Drupal

Eclipse IDE

Elasticsearch

Ellucian Banner ERP

ESRI ArcGIS software

Geographic information system GIS software

Git

Google Analytics

Google AngularJS

Hypertext markup language HTML

IBM Cognos Impromptu

IBM SPSS Statistics

IBM WebSphere

Informatica Corporation PowerCenter

Integrated development environment IDE software

JavaScript

JavaScript Object Notation JSON

jQuery

JUnit

Linux

Marketo Marketing Automation

Microsoft .NET Framework

Microsoft Active Server Pages ASP

Microsoft ASP.NET

Microsoft ASP.NET Core MVC

Microsoft Azure

Microsoft Dynamics GP

Microsoft Exchange Server

Microsoft PowerShell

Microsoft SQL Server Reporting Services

Microsoft Visual Basic Scripting Edition VBScript

Microsoft Visual Studio

MongoDB

MySQL

Nagios

Node.js

Oracle Business Intelligence Enterprise Edition

Oracle Fusion Applications

Oracle JavaServer Pages JSP

Oracle JDBC

Oracle PeopleSoft Financials

Oracle PL/SQL

Oracle Solaris

Oracle Taleo

Oracle WebLogic Server

Practical extraction and reporting language Perl

Puppet

Python

Qlik Tech QlikView

Red Hat WildFly

Relational database management software

Ruby on Rails

Salesforce software

SAP Business Objects

SAP Crystal Reports

Scala

Shell script

Splunk Enterprise

Spring Boot

Spring Framework

Supervisory control and data acquisition SCADA software

Swift

Symantec

Teradata Database

Transact-SQL

Unified modeling language UML

Wireshark

Access management software

Acronis Recovery Expert

ADO.NET

Adobe Systems Adobe Dreamweaver

Adobe Systems Adobe Flash

Amazon DynamoDB

Apache Mahout

Apache Maven

Apache Sqoop

ASG Technologies ASG-Zeke

Blackbaud The Raiser’s Edge

Blackboard

BMC Software Change Manager

BMC Software Control-M

BMC Software Recovery Manager RMAN

CA Easytrieve Report Generator

CA Erwin Data Modeler

CA IDMS

Catalog navigation software

Chef

Cluster server software

Computer Associates Log Analyzer

Computer based training software

Concurrency control software

Couchbase Server

Customer information control system CICS

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 testing software

Delphi Technology

Deployment software

DOS shell script

Dynamic hypertext markup language DHTML

Embarcadero Technologies DBArtisan

EMC NetWorker

Enterprise JavaBeans

Extensible HyperText Markup Language XHTML

FileMaker Pro

Greenplum Database

Hewlett Packard HP-UX

Hewlett Packard LoadRunner

Hibernate ORM

HP DataProtector

IBM ADSTAR

IBM DB2

IBM Informix

IBM InfoSphere DataStage

IBM Interactive System Productivity Facility ISPF

IBM Power Systems software

IBM Rational Data Architect

Index tuning software

Informatica Big Data

Job control language JCL

Jupyter Notebook

KornShell

LAMP Stack

LexisNexis

MapR Converged Data Platform

MariaDB

McAfee

Micosoft SQL Server Analysis Services SSAS

Microsoft ActiveX

Microsoft SQL Server Integration Services SSIS

Microsoft Visual Basic.NET

Microsoft Visual C# .NET

Object database management system ODBMS

Oracle Application Express APEX

Oracle Data Guard

Oracle Designer

Oracle Eloqua

Oracle Enterprise Manager

Oracle Enterprise Manager Cloud Control

Oracle Golden Gate

Oracle Learning Management

Oracle Real Application Cluster RAC

Oracle Reports

Oracle SQL Loader

Oracle SQL Plus

Pentaho Kettle

Quest Central

Quest SharePlex

ReCrystallize Crystal Reports

Red Hat Ansible Engine

Redgate SQL Server

Restructured extended executor REXX

Safe Software FME

SAP Adaptive Server Enterprise

SAP PowerBuilder

SAP Replication Server

SentryOne SQL Sentry

SolarWinds

Storage area network SAN software

Storage management software

Systems and data disaster recovery software

Teradata Active Enterprise Data Warehouse

Test data generator software

Ubuntu

Veritas NetBackup

Visual Paradigm DB Visual ARCHITECT

VMWare

Zabbix

Skills

Critical Thinking

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

Complex Problem Solving

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

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.

Active Learning

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

Reading Comprehension

Understanding written sentences and paragraphs in work related documents.

Judgment and Decision Making

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

Writing

Communicating effectively in writing as appropriate for the needs of the audience.

Speaking

Talking to others to convey information effectively.

Programming

Writing computer programs for various purposes.

Systems Analysis

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

Monitoring

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

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.

Mathematics

Using mathematics to solve problems.

Coordination

Adjusting actions in relation to others' actions.

Operations Analysis

Analyzing needs and product requirements to create a design.

Operation Monitoring

Watching gauges, dials, or other indicators to make sure a machine is working properly.

Learning Strategies

Selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new things.

Instructing

Teaching others how to do something.

Quality Control Analysis

Conducting tests and inspections of products, services, or processes to evaluate quality or performance.

Time Management

Managing one's own time and the time of others.

Abilities

Tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.

Cognitive Abilities › Idea Generation and Reasoning Abilities › Problem Sensitivity

Apply general rules to specific problems to produce answers that make sense.

Cognitive Abilities › Idea Generation and Reasoning Abilities › Deductive Reasoning

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

Cognitive Abilities › Idea Generation and Reasoning Abilities › Information Ordering

Listen to and understand information and ideas presented through spoken words and sentences.

Cognitive Abilities › Verbal Abilities › Oral Comprehension

Read and understand information and ideas presented in writing.

Cognitive Abilities › Verbal Abilities › Written Comprehension

Communicate information and ideas in speaking so others will understand.

Cognitive Abilities › Verbal Abilities › Oral Expression

Communicate information and ideas in writing so others will understand.

Cognitive Abilities › Verbal Abilities › Written Expression

TEST Your output This field is empty or does not exist This field is empty or does not exist

Occupation Sections

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.

Telecommunications

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

Mathematics

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

Real People, Real Stories


Would you look at that! Unfortunately, we don't seem to have any real life stories related to Database Administrators.

Perhaps you'd like to be the first? If so, let's talk about featuring your story!