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 databases.{{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}} The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.{{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}}
Skills
Required skills for database administrators include knowledge of SQL, database queries, database theory, database design, specific databases, such as Oracle, Microsoft SQL Server, or MySQL, storage technologies, distributed computing architectures, operating systems, routine maintenance, recovery, and replication/failover.{{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}}{{cite web|url=http://www.dba-oracle.com/oracle_tips_dba_job_skills.htm|title=Oracle DBA job skills|website=Burleson Consulting}}{{Cite web|url=http://www.orafaq.com/wiki/Roles_and_Responsibilities|title=Roles and Responsibilities - Oracle FAQ|website=www.orafaq.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}}
Certification
Training for DBAs with accompanying certifications is widely available, offered by database vendors and third parties. Offerings include:{{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}}
- IBM Certified Advanced Database Administrator – DB2 10.1 for Linux, Unix and Windows{{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}}
- IBM Certified Database Administrator – DB2 10.1 for Linux, Unix, and Windows
- Oracle Database 12c Administrator Certified Professional{{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 }}
- Oracle MySQL 5.6 Database Administrator Certified Professional{{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}}
- MCSA SQL Server 2012{{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}}
- MCSE Data Platform Solutions Expert{{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}}
See also
References
{{Reflist}}
{{Database}}
{{Databases}}
{{DEFAULTSORT:Database Administrator}}