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 a certificate with experience. |
Database administrators (DBAs) use specialized software to store and organize data.[1]
The role may include Capacity planning, installation, configuration, design of database, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.[2]
Skills
List of skills required to become database administrators are:[3][4][5]
- Communication skills
- Knowledge of database theory
- Knowledge of database design
- Knowledge about the RDBMS itself, e.g. Microsoft SQL Server or MySQL
- Knowledge of structured query language (SQL), e.g. SQL/PSM or Transact-SQL
- General understanding of distributed computing architectures, e.g. Client–server model
- General understanding of operating system, e.g. Windows or Linux
- General understanding of storage technologies and networking
- General understanding of routine maintenance, recovery, and handling failover of a database
Database administrators benefit from a bachelor's degree or master's degree in computer science. An associate's 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. By passing a series of tests and sometimes other requirements, you can earn a database administrator certification. 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 11g Administrator Certified Professional[9]
- MCSA SQL Server 2012[10]
- MCSE Data Platform Solutions Expert [11]
Duties
A database administrator's responsibilities can include the following tasks:[12]
- 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
See also
References
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ http://www.dba-oracle.com/oracle_tips_dba_job_skills.htm
- ↑ http://www.orafaq.com/wiki/Roles_and_Responsibilities
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ 8.0 8.1 Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
External links
"Database Administrators"
| Main | |
|---|---|
| Languages | |
| Security | |
| Design |
|
| Programming | |
| Management | |
| See also | |
