Database administrator

From HandWiki
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.