A database administrator (DBA) manages computer
database
In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and a ...
s.
The role may include
capacity planning,
installation,
configuration,
database design,
migration, performance monitoring,
security,
troubleshooting, as well as
backup
In information technology, a backup, or data backup is a copy of computer data taken and stored elsewhere so that it may be used to restore the original after a data loss event. The verb form, referring to the process of doing so, is "wikt:back ...
and
data recovery.
Skills
Required skills for database administrators include knowledge of
SQL,
database queries,
database theory,
database design, specific databases, such as
Oracle
An oracle is a person or thing considered to provide insight, wise counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. If done through occultic means, it is a form of divination.
Descript ...
,
Microsoft SQL Server
Microsoft SQL Server is a proprietary relational database management system developed by Microsoft using Structured Query Language (SQL, often pronounced "sequel"). As a database server, it is a software product with the primary function of ...
, or
MySQL
MySQL () is an Open-source software, open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A rel ...
,
storage technologies,
distributed computing architectures,
operating system
An operating system (OS) is system software that manages computer hardware and software resources, and provides common daemon (computing), services for computer programs.
Time-sharing operating systems scheduler (computing), schedule tasks for ...
s, routine maintenance, recovery, and replication/failover.
Certification
Training for DBAs with accompanying certifications is widely available, offered by database vendors and third parties. Offerings include:
* IBM Certified Advanced Database Administrator – DB2 10.1 for Linux, Unix and Windows
* IBM Certified Database Administrator – DB2 10.1 for Linux, Unix, and Windows
* Oracle Database 12c Administrator Certified Professional
* Oracle MySQL 5.6 Database Administrator Certified Professional
* MCSA SQL Server 2012
* MCSE Data Platform Solutions Expert
See also
*
Comparison of database administration tools
*
Database administration
Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQL Server need ongoing management. As such, corporations that use D ...
*
Database management
References
{{DEFAULTSORT:Database Administrator
Computer occupations
Data management
Database management systems