Adatabase administrator(DBA) manages computerdatabases.[1]The role may includecapacity planning,installation,configuration,database design,migration,performance monitoring,security,troubleshooting,as well asbackupanddata recovery.[2]
| Occupation | |
|---|---|
Activity sectors | Information Technology |
| Description | |
| Competencies | Databases, RDBMS, SQL, distributed computing, operating systems, storage technologies, networking, maintenance, recovery |
Education required | BS or MS in comp sci; associate degree or certificate with work experience |
Skills
editRequired skills for database administrators include knowledge ofSQL,database queries,database theory,database design,specific databases, such asOracle,Microsoft SQL Server,orMySQL,storage technologies,distributed computing architectures,operating systems,routine maintenance, recovery, and replication/failover.[3][4][5][6]
Certification
editTraining 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
editReferences
edit- ^"Database Administrators".11/04/2015.Bureau of Labor Statistics.Retrieved4 November2015.
- ^"What does a DBA do all day?".11/04/2015.techrepublic.com.Retrieved19 April2021.
- ^Spenik, Mark; Sledge, Orryn (20 March 2001)."What is a Database Administrator? (DBA)".Developer.com. Archived fromthe originalon 13 June 2011.Retrieved6 February2012.
- ^"Oracle DBA job skills".Burleson Consulting.
- ^"Roles and Responsibilities - Oracle FAQ".www.orafaq.com.
- ^"Database Administrator: Job Description and Requirements".11/4/2015.study.com.Retrieved4 November2015.
- ^"How Do I Become a Certified Database Administrator?".learn.org.Retrieved4 November2015.
- ^ab"IBM Professional Certification Program".ibm.com.IBM.Archived fromthe originalon 29 October 2004.Retrieved10 August2014.
- ^"Oracle Certification Program".oracle.com.Oracle Corporation.Archived fromthe originalon 4 October 2011.Retrieved18 June2011.
- ^"Oracle Certified Professional, MySQL 5.6 Database Administrator".oracle.com.Oracle Corporation.Retrieved18 September2016.
- ^"MCSA: SQL Server".microsoft.com.Microsoft.Retrieved3 November2015.
- ^"MCSE: Data Platform".11/4/2015.microsoft.com.Retrieved4 November2015.