***Welcome to ashrafedu.blogspot.com * * * This website is maintained by ASHRAF***

Posts

    Wednesday, 4 December 2019

    Role, Duties and Responsibilities of database Administrator ( DBA)

    Role, Duties and Responsibilities of database Administrator ( DBA)


    A Database Administrator is a person or a group of persons who are responsible for managing all the activities related to database system. 

    The following are the roles and responsibilities of a DBA :

    1. Deciding the hardware device

    Depending upon the cost, performance and efficiency of the hardware, it is DBA who decides which hardware devise will suit the organization requirements. 

    2. Managing Data Integrity

    Data integrity should be managed accurately because it protects the data from unauthorized use. DBA manages relationship between the data to maintain data consistency.

    3. Decides Data Recovery and Back up method

    It is the duty of database admin to regularly backup data, so that data is available even in case of failures.  It is the responsibility of  a DBA to backup database in regular time span. DBA has to decide how frequently the back up should be taken. Also the recovery of data base is done by DBA if they have lost the database.

    4. Tuning Database Performance

    Database performance plays an important role for any business. If user is not able to fetch data speedily then it may loss company business. So by tuning an modifying sql commands a DBA can improves the performance of database.

    5. Capacity Issues

    All the databases have their limits of storing data in it and the physical memory also has some limitations. DBA has to decide the limit and capacity of database and all the issues related to it.

    6. Database design

    The logical design of the database is designed by the DBA. Also a DBA is responsible for physical design, external model design, and integrity control.

    7. Database accessibility

    DBA writes sub schema to decide the accessibility of database. He decides the users of the database and also which data is to be used by which user. No user has authorization to access the entire database without the permission of DBA.

    8. Decides validation checks on data

    DBA has to decide which data should be used and what kind of data is accurate for the company. So he always puts validation checks on data to make it more accurate and consistence.

    9. Monitoring performance

    DBA has monitor the performance of the database. A DBA monitors the CPU and memory usage and takes necessary actions to tune up the performance of Database.

    10. Decides content of the database

    A database system has many kind of content information in it. DBA decides fields, types of fields, and range of values of the content in the database system. DBA decides the structure of database files.

    11. Database implementation

    Database has to be implemented before it can be used. DBA implements the database system. DBA has to supervise the database loading at the time of its implementation.

    13. Improve query processing performance

    Queries made by the users should be performed speedily. DBA improves query processing by improving their performance.



    No comments:

    Post a Comment