Database administrators (DBAs) use specialized software to store and organize data. The role may include capacity planning, installation,

configuration Configuration or configurations may refer to: Computing * Computer configuration or system configuration * Configuration file, a software file used to configure the initial settings for a computer program * Configurator, also known as choice bo ...

database design Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model.Teorey, T ...

migration Migration, migratory, or migrate may refer to: Human migration * Human migration, physical movement by humans from one region to another ** International migration, when peoples cross state boundaries and stay in the host state for some minimum le ...

, performance monitoring,

security" \n\n\nsecurity.txt is a proposed standard for websites' security information that is meant to allow security researchers to easily report security vulnerabilities. The standard prescribes a text file called \"security.txt\" in the well known locat ...

troubleshooting Troubleshooting is a form of problem solving, often applied to repair failed products or processes on a machine or a system. It is a logical, systematic search for the source of a problem in order to solve it, and make the product or process ope ...

, 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 "back up", ...

and data recovery.

Skills

Some common and useful skills for database administrators are: * Knowledge of database queries * Knowledge of database theory * Knowledge of

* Knowledge about the

RDBMS A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relatio ...

itself, e.g.

Microsoft SQL Server Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which ...

MySQL MySQL () is an 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 relational database ...

* Knowledge of structured query language (SQL), e.g. SQL/PSM or Transact-SQL * General

understanding Understanding is a psychological process related to an abstract or physical object, such as a person, situation, or message whereby one is able to use concepts to model that object. Understanding is a relation between the knower and an object ...

of distributed computing architectures, e.g.

Client–server model The client–server model is a distributed application structure that partitions tasks or workloads between the providers of a resource or service, called servers, and service requesters, called clients. Often clients and servers communicate ov ...

* General understanding of

operating system An operating system (OS) is system software that manages computer hardware, software resources, and provides common daemon (computing), services for computer programs. Time-sharing operating systems scheduler (computing), schedule tasks for ef ...

, e.g.

Windows Windows is a group of several proprietary graphical operating system families developed and marketed by Microsoft. Each family caters to a certain sector of the computing industry. For example, Windows NT for consumers, Windows Server for se ...

Linux Linux ( or ) is a family of open-source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991, by Linus Torvalds. Linux is typically packaged as a Linux distribution, whi ...

* General understanding of storage technologies and

networking Network, networking and networked may refer to: Science and technology * Network theory, the study of graphs as a representation of relations between discrete objects * Network science, an academic field that studies complex networks Mathematic ...

* General understanding of routine maintenance, recovery, and handling failover of a database * Database Management Systems – Managing your data landscap
Database management System
Database administrators benefit from a

bachelor's degree A bachelor's degree (from Middle Latin ''baccalaureus'') or baccalaureate (from Modern Latin ''baccalaureatus'') is an undergraduate academic degree awarded by colleges and universities upon completion of a course of study lasting three to si ...

master's degree A master's degree (from Latin ) is an academic degree awarded by universities or colleges upon completion of a course of study demonstrating mastery or a high-order overview of a specific field of study or area of professional practice.

computer science Computer science is the study of computation, automation, and information. Computer science spans theoretical disciplines (such as algorithms, theory of computation, information theory, and automation) to Applied science, practical discipli ...

. An

associate degree An associate degree is an undergraduate degree awarded after a course of post-secondary study lasting two to three years. It is a level of qualification above a high school diploma, GED, or matriculation, and below a bachelor's degree. Th ...

or a

certificate Certificate may refer to: * Birth certificate * Marriage certificate * Death certificate * Gift certificate * Certificate of authenticity, a document or seal certifying the authenticity of something * Certificate of deposit, or CD, a financial pr ...

may be sufficient with work experience.

Certification

There are many certifications available for becoming a certified database administrator. Many of these certifications are offered by database vendors themselves. Database administrator certifications may be earned by passing a series of tests and sometimes other requirements. Schools offering Database Administration degrees can also be found. For example: * 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

References

{{DEFAULTSORT:Database Administrator Computer occupations Data management

Skills

Certification

See also

References