Database administrator

From HandWiki
Revision as of 17:42, 6 February 2024 by StanislovAI (talk | contribs) (update)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

Database administrators (DBAs) use specialized software to store and organize data.[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

Some common and useful skills for database administrators are:[3][4][5]

Database administrators benefit from a bachelor's degree or master's degree in computer science. An associate degree or a certificate may be sufficient with work experience.[6]

Certification

There are many certifications available for becoming a certified database administrator. Many of these certifications are offered by database vendors themselves. Database administrator certifications may be earned by passing a series of tests and sometimes other requirements. Schools offering Database Administration degrees can also be found.[7]

For example:

  • 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. http://www.bls.gov/ooh/computer-and-information-technology/database-administrators.htm. 
  2. ↑ "What does a DBA do all day?". 11/04/2015. techrepublic.com. http://www.techrepublic.com/blog/the-enterprise-cloud/what-does-a-dba-do-all-day/. 
  3. ↑ Spenik, Mark; Sledge, Orryn (2001-03-20). "What is a Database Administrator? (DBA)". Developer.com. http://www.developer.com/db/article.php/718491/What-Is-a-Database-Administrator.htm. 
  4. ↑ "Oracle DBA job skills". http://www.dba-oracle.com/oracle_tips_dba_job_skills.htm. 
  5. ↑ "Roles and Responsibilities – Oracle FAQ". http://www.orafaq.com/wiki/Roles_and_Responsibilities. 
  6. ↑ "Database Administrator: Job Description and Requirements". 11/4/2015. study.com. http://study.com/articles/Database_Administrator_Job_Description_and_Requirements.html. 
  7. ↑ "How Do I Become a Certified Database Administrator?". learn.org. learn.org. http://learn.org/articles/How_Do_I_Become_a_Certified_Database_Administrator.html. 
  8. ↑ 8.0 8.1 "IBM Professional Certification Program". ibm.com. IBM. http://www-03.ibm.com/certify/index.shtml. 
  9. ↑ "Oracle Certification Program". oracle.com. Oracle Corporation. http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=143&p_org_id=1001&lang=US. 
  10. ↑ "Oracle Certified Professional, MySQL 5.6 Database Administrator". oracle.com. Oracle Corporation. 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. 
  11. ↑ "MCSA: SQL Server". microsoft.com. Microsoft. https://www.microsoft.com/en-us/learning/mcsa-sql-certification.aspx. 
  12. ↑ "MCSE: Data Platform". 11/4/2015. microsoft.com. https://www.microsoft.com/en-us/learning/mcse-sql-data-platform.aspx. 



Retrieved from "https://handwiki.org/wiki/index.php?title=Database_administrator&oldid=3366874"