- the installation,
- configuration,
- upgrade,
- administration,
- monitoring and
- maintenance of databases in an organization.[1]
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.
Database administrator Skill:
- Communication skills
- Knowledge of database theory
- Knowledge of database design
- Knowledge about the RDBMS itself, e.g. Oracle Database, SAP Sybase Adaptive Server Enterprise, IBM DB2, Microsoft SQL Server, PostgreSQL
- Knowledge of Structured Query Language (SQL) and procedural extension language, e.g. PL/SQL, SQL/PSM, Transact-SQL
- General understanding of distributed computing architectures, e.g. Client/Server, Internet/Intranet, Enterprise
- General understanding of the underlying operating system, e.g. Windows, Unix, Linux
- General understanding of storage technologies, memory management, disk arrays, NAS/SAN, networking
Duties Database administrator:
A database administrator's responsibilities can include the following tasks:[8]- 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 Database administrator:
DBAs are also known by the titles Database Coordinator or Database Programmer, although a database programmer requires more advanced skills in SQL programming than a DBA may have, and a Database Programmer may not have and does not require the skills of database administration, backing up, restoring, monitoring or tuning to do their job well.[2]The role is closely related to the other jobs of Database Analyst, Database Modeller, Programmer Analyst, and Systems Manager.[2]
Some organizations[clarification needed] have a hierarchical level of database administrators, generally:[9]
- Data Analysts/Query designers
- Junior DBAs
- Midlevel DBAs
- Senior DBAs
- DBA consultants
- Manager/Director of Database Administration/Information Technology
No comments:
Post a Comment