Database administrator
Template:Short description Template:Use British English Template:Use dmy dates Template:Infobox occupation
A database administrator (DBA) manages computer databases.<ref name="BLS-DBA">{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.<ref name="techrepublic">{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>
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.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref><ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref><ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref><ref name="study.com">{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>
Certification
Training for DBAs with accompanying certifications is widely available, offered by database vendors and third parties. Offerings include:<ref name="learn.org">{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>
- IBM Certified Advanced Database Administrator – DB2 10.1 for Linux, Unix and Windows<ref name="ibm.com">{{#invoke:citation/CS1|citation
|CitationClass=web }}</ref>
- IBM Certified Database Administrator – DB2 10.1 for Linux, Unix, and Windows<ref name="ibm.com"/>
- Oracle Database 12c Administrator Certified Professional<ref>{{#invoke:citation/CS1|citation
|CitationClass=web }}</ref>
- Oracle MySQL 5.6 Database Administrator Certified Professional<ref>{{#invoke:citation/CS1|citation
|CitationClass=web }}</ref>
- MCSA SQL Server 2012<ref name=MCSASQL>{{#invoke:citation/CS1|citation
|CitationClass=web }}</ref>
- MCSE Data Platform Solutions Expert<ref name="microsoftsolutionsexpert">{{#invoke:citation/CS1|citation
|CitationClass=web }}</ref>
See also
- Comparison of database administration tools
- Database administration
- Database management