Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
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 a related field like information systems, information technology, computer science, management information system |
A database administrator (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]
- 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
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.
Certification[edit]
Employing organizations may require that a database administrator have a certification for the particular RDBMS being used.[2]
For example:
- 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[6]
- Oracle Database 11g Administrator Certified Professional[7]
- MCSA SQL Server 2012[8]
- MCDBA SQL Server 2000[8]
Duties[edit]
A database administrator's responsibilities can include the following tasks:[9]
- 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[edit]
References[edit]
- ^ "Database Administration". SFIAPlus. British Computer Society. Retrieved 2012-02-06.
- ^ a b "Database Administrator". ICT Careers Portal. Australian Computer Society. Retrieved 2012-02-06.
- ^ 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.
- ^ http://www.dba-oracle.com/oracle_tips_dba_job_skills.htm
- ^ http://www.orafaq.com/wiki/Roles_and_Responsibilities
- ^ a b "IBM Professional Certification Program". ibm.com. IBM. Retrieved 2014-08-10.
- ^ "Oracle Certification Program". oracle.com. Oracle Corporation. Retrieved 2011-06-18.
- ^ a b "Microsoft SQL Server Certification". microsoft.com. Microsoft. Retrieved 2012-02-06.
- ^ "Oracle DBA Responsibilities". Oracle Corporation. Retrieved 2012-02-06.
External links[edit]
"Database Administrators"
|
||||||||||||||||||||||||||||||||||
