Database administrator

From Wikipedia, the free encyclopedia
(Redirected from Database administrators)
Jump to navigation Jump to search

Database Administrator
Occupation
Activity sectors
Information Technology
Specialty{{#statements:P1995}}
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

[edit | edit source]

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

[edit | edit source]

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

[edit | edit source]

References

[edit | edit source]
  1. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  2. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  3. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  4. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  5. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  6. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  7. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  8. ^ a b Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  9. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  10. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  11. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  12. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).