Database administrator
A database administrator (short form DBA) is a person responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization.
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.Contents
• 1 Skills
o 1.1 Certification
• 2 Duties
• 3 Job titlesSkills
List of skills required to become database administrators are
• Knowledge of Structured Query Language (SQL)
• Some database design
• General understanding of distributed computing architectures (for example, Client/Server, Internet/Intranet, Enterprise)
• A good understanding of the underlying operating system e.g. Windows Server 2008, Solaris, Linux, AIX, etc.
• Knowledge about the RDBMS itself e.g. Microsoft SQL Server, Oracle Database, etc.Certification
Employing organizations may require that a database administrator have a certification for the particular RDBMS being used.
Examples are Oracle Database 11g Administrator Certified Professional[4] and MCITP Database Administrator 2008Duties
A database administrator's responsibilities can include the following tasks:
• 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
DBAs are also known by the titles Database Coordinator or Database Programmer.
The role is closely related to the other jobs of Database Analyst, Database Modeller, Programmer Analyst, and Systems Manager
Some organizations[clarification needed] have a hierarchical level of database administrators, generally
• Data Analysts/Query designers
• Junior DBAs
• Midlevel DBAs
• Senior DBAs
• DBA consultants
• Manager/Director of Database Administration/Information Advanced-Technology Industrial
A database administrator (short form DBA) is a person responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization.
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.Contents
• 1 Skills
o 1.1 Certification
• 2 Duties
• 3 Job titlesSkills
List of skills required to become database administrators are
• Knowledge of Structured Query Language (SQL)
• Some database design
• General understanding of distributed computing architectures (for example, Client/Server, Internet/Intranet, Enterprise)
• A good understanding of the underlying operating system e.g. Windows Server 2008, Solaris, Linux, AIX, etc.
• Knowledge about the RDBMS itself e.g. Microsoft SQL Server, Oracle Database, etc.Certification
Employing organizations may require that a database administrator have a certification for the particular RDBMS being used.
Examples are Oracle Database 11g Administrator Certified Professional[4] and MCITP Database Administrator 2008Duties
A database administrator's responsibilities can include the following tasks:
• 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
DBAs are also known by the titles Database Coordinator or Database Programmer.
The role is closely related to the other jobs of Database Analyst, Database Modeller, Programmer Analyst, and Systems Manager
Some organizations[clarification needed] have a hierarchical level of database administrators, generally
• Data Analysts/Query designers
• Junior DBAs
• Midlevel DBAs
• Senior DBAs
• DBA consultants
• Manager/Director of Database Administration/Information Advanced-Technology Industrial
