Database administrator explained
Database Administrator |
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 |
A database administrator (DBA) manages computer databases.[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
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.[3] [4] [5] [6]
Certification
Training for DBAs with accompanying certifications is widely available, offered by database vendors and third parties. Offerings include:[7]
- 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]
See also
Notes and References
- Web site: Database Administrators . Bureau of Labor Statistics . 11/04/2015 . 4 November 2015.
- Web site: What does a DBA do all day? . techrepublic.com . 11/04/2015 . 19 April 2021.
- Web site: Spenik. Mark. Sledge. Orryn. 2001-03-20. What is a Database Administrator? (DBA). Developer.com. 2012-02-06. https://web.archive.org/web/20110613101702/http://www.developer.com/db/article.php/718491/What-Is-a-Database-Administrator.htm. 2011-06-13.
- Web site: Oracle DBA job skills. Burleson Consulting.
- Web site: Roles and Responsibilities - Oracle FAQ. www.orafaq.com.
- Web site: Database Administrator: Job Description and Requirements . study.com . 11/4/2015 . 4 November 2015.
- Web site: How Do I Become a Certified Database Administrator? . learn.org . 4 November 2015.
- Web site: IBM Professional Certification Program . ibm.com . . 2014-08-10.
- Web site: Oracle Certification Program . oracle.com . . 2011-06-18 . 4 October 2011 . 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 . dead .
- Web site: Oracle Certified Professional, MySQL 5.6 Database Administrator . oracle.com . . 2016-09-18.
- Web site: MCSA: SQL Server . microsoft.com . . 2015-11-03.
- Web site: MCSE: Data Platform . microsoft.com . 11/4/2015 . 4 November 2015.