Database administrator

From Wikipedia, the free encyclopedia
  (Redirected from Database administration)
Jump to: navigation, search
Database administrator
Occupation
Names Database Administrator , Database Analyst
Activity sectors
Information technology, Information Systems
Description
Competencies Databases Design and Implementation, Programming skills, Database theory, Networking Basics, analytical skills, critical thinking
Education required
At Least Bachelor Degree in Related Field Like : Information systems , Information Technology, Computer Science , Management Information system

A database administrator (acronym DBA) is an IT Professional responsible for the installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases in an organization.[1]

The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database.[2]

Skills[edit]

List of skills required to become database administrators are:[3][4][5]

Education[edit]

Some employers require a Bachelor's Degree or higher in Computer Science, Information Technology, Engineering, or related field to perform job duties as a database administrator. In general, DBA's work with commercial databases such as SQL Server, Oracle, MongoDB and many others.

Certification[edit]

Employing organizations may require that a database administrator have a certification for the particular RDBMS being used.[2]

Examples

  • IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and Windows[6]
  • IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows[7]
  • Oracle Database 11g Administrator Certified Professional[8]
  • MCSA SQL Server 2012.[9]

Duties[edit]

A database administrator's responsibilities can include the following tasks:[10]

  • Installing and upgrading the database server and application tools
  • Allocating system storage and planning future storage requirements for the database system
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Ensuring compliance with database vendor license agreement
  • Controlling and monitoring user access to the database
  • Monitoring and optimizing the performance of the database
  • Planning for backup and recovery of database information
  • Maintaining archived data
  • Backing up and restoring databases
  • Contacting database vendor for technical support
  • Generating various reports by querying from database as per need.

Job titles[edit]

DBAs are also known[by whom?] by the titles Database Coordinator or Database Programmer, although a database programmer requires more advanced skills in SQL programming than a DBA may have, and Database Programmers may not have and do not require the skills of database administration, backing up, restoring, monitoring or tuning to do their job well.[2]

The role integrates closely with the other jobs of Database Analyst, Database Modeller, Programmer Analyst, and Systems Manager.[2]

Some organizations[clarification needed] have a hierarchical system of database administrators, generally:[11]

  • Junior DBAs
  • Mid-level DBAs
  • Senior DBAs
  • DBA consultants
  • Manager/Director of Database Administration/Information Technology

References[edit]

  1. ^ "Database Administration". SFIAPlus. British Computer Society. Retrieved 2012-02-06. 
  2. ^ a b c d "Database Administrator". ICT Careers Portal. Australian Computer Society. Retrieved 2012-02-06. 
  3. ^ Spenik, Mark; Sledge, Orryn (2001-03-20). "What is a Database Administrator? (DBA)". Developer.com. Archived from the original on 2011-06-13. Retrieved 2012-02-06. 
  4. ^ http://www.dba-oracle.com/oracle_tips_dba_job_skills.htm
  5. ^ http://www.orafaq.com/wiki/Roles_and_Responsibilities
  6. ^ "IBM Professional Certification Program". IBM. Retrieved 2014-08-10. 
  7. ^ "IBM Professional Certification Program". IBM. Retrieved 2014-08-10. 
  8. ^ "Oracle Certification Program". Oracle Corporation. Retrieved 2011-06-18. 
  9. ^ "Microsoft SQL Server Certification". Microsoft Corporation. Retrieved 2012-02-06. 
  10. ^ "Oracle DBA Responsibilities". Oracle Corporation. Retrieved 2012-02-06. 
  11. ^ "Database Administrator Job Description". Retrieved 2012-11-14. 

External links[edit]