Database administrator

Database administrators (DBAs) use specialized software to store and organize data.^[1] The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.^[2]

Skills

List of skills required to become database administrators are:^[3]^[4]^[5]

Knowledge of database queries
Knowledge of database theory
Knowledge of database design
Knowledge about the RDBMS itself, e.g. Microsoft SQL Server or MySQL
Knowledge of structured query language (SQL), e.g. SQL/PSM or Transact-SQL
General understanding of distributed computing architectures, e.g. Client–server model
General understanding of operating system, e.g. Windows or Linux
General understanding of storage technologies and networking
General understanding of routine maintenance, recovery, and handling failover of a database

Database administrators benefit from a bachelor's degree or master's degree in computer science. An associate degree or a certificate may be sufficient with work experience.^[6]

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.^[7]

For example:

IBM Certified Advanced Database Administrator - DB2 10.1 for Linux, Unix and Windows^[8]
IBM Certified Database Administrator - DB2 10.1 for Linux, Unix, and Windows^[8]
Oracle Database 12c Administrator Certified Professional^[9]
Oracle MySQL 5.6 Database Administrator Certified Professional^[10]
MCSA SQL Server 2012^[11]
MCSE Data Platform Solutions Expert ^[12]

Duties

A database administrator's responsibilities can include the following tasks:^[13]

An editor has launched a copyright investigation involving this section. The text under investigation is currently hidden from public view, but is accessible in the page history. Please do not remove this notice or restore blanked content until the issue is resolved by an administrator, copyright clerk, or volunteer response agent.

The purported copyright violation copies text from (Copyvios report); as such, this page has been listed on the copyright problems page.

Unless the copyright status of the text of this page or section is clarified and determined to be compatible with Wikipedia's content license, the problematic text and revisions or the entire page may be deleted one week after the time of its listing (i.e. after 18:17, 23 September 2021 (UTC)).

What can I do to resolve the issue?

If you hold the copyright to this text, you can license it in a manner that allows its use on Wikipedia.
1. You must permit the use of your material under the terms of the Creative Commons Attribution-Sharealike 4.0 International License (CC BY-SA 4.0) and the GNU Free Documentation License (GFDL) (unversioned, with no invariant sections, front-cover texts, or back-cover texts).
2. Explain your intent to license the content on this article's discussion page.
3. To confirm your permission, you can either display a notice to this effect at the site of original publication or send an e-mail from an address associated with the original publication to permissions-enwikimedia.org or a postal letter to the Wikimedia Foundation. These messages must explicitly permit use under CC BY-SA and the GFDL. See Wikipedia:Donating copyrighted materials.
4. Note that articles on Wikipedia must be written from a neutral point of view and must be verifiable in published third-party sources; consider whether, copyright issues aside, your text is appropriate for inclusion in Wikipedia.
You can demonstrate that this text is in the public domain or is already under a license suitable for Wikipedia. Explain this on this article's discussion page, with reference to evidence. Wikipedia:Public domain and Wikipedia:Compatibly licensed may assist in determining the status.
Otherwise, you may rewrite this page without copyright-infringing material. Your rewrite should be placed on this page, where it will be available for an administrator or clerk to review it at the end of the listing period. Follow this link to create the temporary subpage. Please mention the rewrite upon completion on this article's discussion page.
- Simply modifying copyrighted text is not sufficient to avoid copyright infringement—if the original copyright violation cannot be cleanly removed or the article reverted to a prior version, it is best to write the article from scratch. (See Wikipedia:Close paraphrasing.)
- For license compliance, any content used from the original article must be properly attributed; if you use content from the original, please leave a note at the top of your rewrite saying as much. You may duplicate non-infringing text that you had contributed yourself.
- It is always a good idea, if rewriting, to identify the point where the copyrighted content was imported to Wikipedia and to check to make sure that the contributor did not add content imported from other sources. When closing investigations, clerks and administrators may find other copyright problems than the one identified. If this material is in the proposed rewrite and cannot be easily removed, the rewrite may not be usable.

Steps to list an article at Wikipedia:Copyright problems:

Add the following to the bottom of Wikipedia:Copyright problems/2021 September 16: * {{subst:article-cv|Database administrator}} from . ~~~~
Add the following template to the talk page of the contributor of the material: {{subst:Nothanks-web|pg=Database administrator|url=}} ~~~~
Place {{copyvio/bottom}} at the end of the portion you want to blank. If nominating the entire page, please place this template at the top of the page, set the "fullpage" parameter to "yes", and place {{copyvio/bottom}} at the very end of the article.

References

^ "Database Administrators". 11/04/2015. Bureau Of Labor Statistics. Retrieved 4 November 2015.
^ "What does a DBA do all day?". 11/04/2015. techrepublic.com. Retrieved 19 April 2021.
^ Spenik, Mark; Sledge, Orryn (20 March 2001). "What is a Database Administrator? (DBA)". Developer.com. Archived from the original on 13 June 2011. Retrieved 6 February 2012.
^ "Oracle DBA job skills". Burleson Consulting.
^ "Roles and Responsibilities - Oracle FAQ".
^ "Database Administrator: Job Description and Requirements". 11/4/2015. study.com. Retrieved 4 November 2015.
^ "How Do I Become a Certified Database Administrator?". learn.org. learn.org. Retrieved 4 November 2015.
^ ^a ^b "IBM Professional Certification Program". ibm.com. IBM. Retrieved 10 August 2014.
^ "Oracle Certification Program". oracle.com. Oracle Corporation. Retrieved 18 June 2011.
^ "Oracle Certified Professional, MySQL 5.6 Database Administrator". oracle.com. Oracle Corporation. Retrieved 18 September 2016.
^ "MCSA: SQL Server". microsoft.com. Microsoft. Retrieved 3 November 2015.
^ "MCSE: Data Platform". 11/4/2015. microsoft.com. Retrieved 4 November 2015.
^ "Oracle DBA Responsibilities". Oracle Corporation. Retrieved 6 February 2012.

v t e Database
Main	Requirements Theory Database object Models Database management system Machine Engine Server Application Connection datasource DSN Administrator Synonym Lock Types Tools
Languages	Data definition Data manipulation Query information retrieval
Security	Activity monitoring Audit Forensics Negative database
Design	Entities and relationships (and Enhanced notation) Normalization Schema Refactoring Cardinality
Programming	Abstraction layer Object–relational mapping
Management	Virtualization Tuning caching Migration Preservation Integrity
Lists of	Academic Biological Biodiversity Facial expression Online Online music Online real estate
See also	Database-centric architecture Intelligent database Two-phase locking Locks with ordered sharing Load file Publishing Halloween Problem Log shipping
WikiProject Category

v t e Database management systems
Types	Object-oriented comparison Relational list comparison Key–value Column-oriented list Document-oriented Wide-column store Graph NoSQL NewSQL In-memory list Multi-model comparison Cloud Blockchain-based database
Concepts	Database ACID Armstrong's axioms Codd's 12 rules CAP theorem CRUD Null Candidate key Foreign key PACELC design principle Superkey Surrogate key Unique key
Objects	Relation table column row View Transaction Transaction log Trigger Index Stored procedure Cursor Partition
Components	Concurrency control Data dictionary JDBC XQJ ODBC Query language Query optimizer Query rewriting system Query plan
Functions	Administration Query optimization Replication Sharding
Related topics	Database models Database normalization Database storage Distributed database Federated database system Referential integrity Relational algebra Relational calculus Relational model Object–relational database Transaction processing
Category Outline

Skills

Certification

Duties

See also

References