Database administrator

Database Administrator
Occupation
Activity sectors
Information Technology
Description
CompetenciesDatabases, 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

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

References

  1. ^ "Database Administrators". 11/04/2015. Bureau of Labor Statistics. Retrieved 4 November 2015.
  2. ^ "What does a DBA do all day?". 11/04/2015. techrepublic.com. Retrieved 19 April 2021.
  3. ^ 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.
  4. ^ "Oracle DBA job skills". Burleson Consulting.
  5. ^ "Roles and Responsibilities - Oracle FAQ". www.orafaq.com.
  6. ^ "Database Administrator: Job Description and Requirements". 11/4/2015. study.com. Retrieved 4 November 2015.
  7. ^ "How Do I Become a Certified Database Administrator?". learn.org. Retrieved 4 November 2015.
  8. ^ a b "IBM Professional Certification Program". ibm.com. IBM. Archived from the original on 29 October 2004. Retrieved 10 August 2014.
  9. ^ "Oracle Certification Program". oracle.com. Oracle Corporation. Archived from the original on 4 October 2011. Retrieved 18 June 2011.
  10. ^ "Oracle Certified Professional, MySQL 5.6 Database Administrator". oracle.com. Oracle Corporation. Retrieved 18 September 2016.
  11. ^ "MCSA: SQL Server". microsoft.com. Microsoft. Retrieved 3 November 2015.
  12. ^ "MCSE: Data Platform". 11/4/2015. microsoft.com. Retrieved 4 November 2015.

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.