Some database administrator duties generally include:
1. Installing New Software
Of course that means is software related to DBMS administration, for example a new version of the DBMS or application supporters.
Before actively used in the production phase, a database administrator or other IT staff need to perform tests on the new software is installed.
2. Hardware and Software Configuration
In this case a database administrator may need to work closely with system administrators to configure hardware and software in order to function optimally with the DBMS.
3. Security Administration
One of the most important task is to monitor the database administrators and security administration of the DBMS. For example add or delete users, set the quota, audit or examine the database security problems.
4. Data Analysis
Work often involves data analysis features that can be used to improve database performance. Often a database administrator must analyze and use effective ways to use the index, parallel query execution, or other DBMS features.
5. Database Design
Database administrators are often involved and the stages involved in the design database. With the knowledge of DBMS system, a database administrator can help the team in improving the performance of database developers.
6. Data Modeling and Optimization
Data modeling is the process of creating a data model by applying the theory of a data model, where you do structuration and organization of data
0 comments