Editing Database administrator

{{Short description|Software profession}}
{{Use British English|date=June 2012}}
{{Use dmy dates|date=February 2022}}
{{Infobox occupation
| name = Database Administrator
| synonyms = 
| pronounce =
| image =
| imagesize =
| alt =
| caption =
| official_names =
| type =
| activity_sector = Information Technology
| competencies = Databases, RDBMS, SQL, distributed computing, operating systems, storage technologies, networking, maintenance, recovery
| formation = BS or MS in comp sci; associate degree or certificate with work experience
| employment_field =
| related_occupation =
}}

A '''database administrator''' ('''DBA''') manages computer [[database]]s.<ref name="BLS-DBA">{{cite web | url=http://www.bls.gov/ooh/computer-and-information-technology/database-administrators.htm | title=Database Administrators | publisher=Bureau of Labor Statistics | work=11/04/2015 | access-date=4 November 2015}}</ref> The role may include [[capacity planning]], [[Installation (computer programs)|installation]], [[Computer configuration|configuration]], [[database design]], [[Data migration|migration]], performance monitoring, [[Database security|security]], [[troubleshooting]], as well as [[backup]] and [[data recovery]].<ref name="techrepublic">{{cite web | url=http://www.techrepublic.com/blog/the-enterprise-cloud/what-does-a-dba-do-all-day/ | title=What does a DBA do all day? | publisher=techrepublic.com | work=11/04/2015 | access-date=19 April 2021}}</ref>

==Skills==
Required skills for database administrators include knowledge of [[SQL]], [[database queries]], [[database theory]], [[database design]], specific databases, such as [[Oracle Database|Oracle]], [[Microsoft SQL Server]], or [[MySQL]], [[Computer data storage|storage technologies]], [[Distributed computing|distributed computing architectures]], [[operating system]]s, routine maintenance, recovery, and replication/failover.<ref>{{cite web|last1=Spenik|first1=Mark|last2=Sledge|first2=Orryn|date=2001-03-20|url=http://www.developer.com/db/article.php/718491/What-Is-a-Database-Administrator.htm|title=What is a Database Administrator? (DBA)|publisher=Developer.com|access-date=2012-02-06|archive-url=https://web.archive.org/web/20110613101702/http://www.developer.com/db/article.php/718491/What-Is-a-Database-Administrator.htm|archive-date=2011-06-13}}</ref><ref>{{cite web|url=http://www.dba-oracle.com/oracle_tips_dba_job_skills.htm|title=Oracle DBA job skills|website=Burleson Consulting}}</ref><ref>{{Cite web|url=http://www.orafaq.com/wiki/Roles_and_Responsibilities|title=Roles and Responsibilities - Oracle FAQ|website=www.orafaq.com}}</ref><ref name="study.com">{{cite web | url=http://study.com/articles/Database_Administrator_Job_Description_and_Requirements.html | title=Database Administrator: Job Description and Requirements | publisher=study.com | work=11/4/2015 | access-date=4 November 2015}}</ref>

== Certification ==
Training for DBAs with accompanying certifications is widely available, offered by database vendors and third parties. Offerings include:<ref name="learn.org">{{cite web | url=http://learn.org/articles/How_Do_I_Become_a_Certified_Database_Administrator.html | title=How Do I Become a Certified Database Administrator? | work=learn.org | access-date=4 November 2015}}</ref>
* IBM Certified Advanced Database Administrator – DB2 10.1 for Linux, Unix and Windows<ref name="ibm.com">{{cite web |url=http://www-03.ibm.com/certify/index.shtml |archive-url=https://web.archive.org/web/20041029112309/http://www-03.ibm.com/certify/index.shtml |url-status=dead |archive-date=29 October 2004 |title=IBM Professional Certification Program |work=ibm.com |publisher=[[IBM]] |access-date=2014-08-10}}</ref>
* IBM Certified Database Administrator – DB2 10.1 for Linux, Unix, and Windows<ref name="ibm.com"/>
* Oracle Database 12c Administrator Certified Professional<ref>{{cite web |url=http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=143&p_org_id=1001&lang=US |title=Oracle Certification Program |work=oracle.com |publisher=[[Oracle Corporation]] |access-date=2011-06-18 |archive-date=4 October 2011 |archive-url=https://web.archive.org/web/20111004234424/http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=143&p_org_id=1001&lang=US |url-status=dead }}</ref>
* Oracle MySQL 5.6 Database Administrator Certified Professional<ref>{{cite web |url=https://education.oracle.com/pls/web_prod-plq-dad/ou_product_category.getPage?p_cat_id=159&p_org_id=15941&lang=US#tabs-3 |title=Oracle Certified Professional, MySQL 5.6 Database Administrator |work=oracle.com |publisher=[[Oracle Corporation]] |access-date=2016-09-18}}</ref>
* MCSA SQL Server 2012<ref name=MCSASQL>{{cite web |url=https://www.microsoft.com/en-us/learning/mcsa-sql-certification.aspx |title=MCSA: SQL Server |work=microsoft.com |publisher=[[Microsoft]] |access-date=2015-11-03}}</ref>
* MCSE Data Platform Solutions Expert<ref name="microsoftsolutionsexpert">{{cite web | url=https://www.microsoft.com/en-us/learning/mcse-sql-data-platform.aspx | title=MCSE: Data Platform | publisher=microsoft.com | work=11/4/2015 | access-date=4 November 2015}}</ref>

==See also==
* [[Comparison of database administration tools]]
* [[Database administration]]
* [[Database management]]

==References==
{{Reflist}}

{{Database}}
{{Databases}}

{{DEFAULTSORT:Database Administrator}}
[[Category:Computer occupations]]
[[Category:Data management]]
[[Category:Database specialists| ]]
[[Category:Database management systems]]