Technology Changes Role Of Database Administrator :: essays research papers fc

Technology Changes Role of Database Administrator The database administrator (DBA) is responsible for managing and coordinating all database activities. The DBA's job description includes database design, user coordination, backup, recovery, overall performance, and database security. The database administrator plays a crucial role in managing data for the employer. In the past the DBA job has required sharp technical skills along with management ability. (Shelly, Cashman, Waggoner 1992). However, the arrival on the scene of the relational database along with the rapidly changing technology has modified the database administrator's role. This has required organizations to vary the way of handling database management. (Mullins 1995) Traditional database design and data access were complicated. The database administrator's job was to oversee any and all database-oriented tasks. This included database design and implementation, installation, upgrade, SQL analysis and advice for application developers.. The DBA was also responsible for back-up and recovery, which required many complex utility programs that run in a specified order. This was a time-consuming energy draining task. (Fosdick 1995) Databases are currently in the process of integration. Standardizing data, once done predominately by large corporations, is now filtering down to medium- size and small companies. The meshing of the old and new database causes administrators to maintain two or three database products on a single network. (Wong 1995) Relational database management systems incorporate complex features and components to help with logic procedures. This requires organizations to expand the traditional approach to database management and administration. The modern database management systems not only share data, they implement the sharing of common data elements and code elements. (Mullins 1995) Currently, the more sought after relational database products are incorporating more and more complex features and components to simplify procedural logic. Due to the complexity of todays relational database, corporations are changing the established way of dealing with database management personnel. Traditionally, as new features were added to the database, more and more responsibility fell on the DBA. With the emergence of the relational database management system (RDBMS), we are now beginning to see a change in the database administrator's role.(Mullins 1995) The design of data access routines in relational database demands extra participation from programmers. The database administrator simply checks the system's optimization choice, because technology is responsible for building access paths to the data. Program design and standard query language (SQL) tools have become essential requirements for the database administrator to do this job. However, this technology requires additional supervision and many DBAs are not competent in SQL analysis and performance monitoring. The database administrator had to learn to master the skills of application logic and programming techniques. (Mullins 1995) The database administrator's job description and responsibilities have changed