-
Essay / Database Administration Roles - 941
1.0 DBA Roles: DBA plays an important role in every organization, they form the core part of the technology team, depending on the organization. DBA roles vary but the majority of their role is very critical due to the impact, of the architect. , Quality Analyst, System Analyst and Developers, everyone has to work with DBA during different development life cycles. DBA skills are hard to find. The majority of organizations prefer certified DBAs, and certification for DBA is difficult to obtain. Organizational expectations of the DBA: - The DBA must have a good understanding of the database and its tools. - Knowledge and good understanding of SQL. Database backup and recovery.- Database usage management.- Database performance tuning and monitoring.- Database security management. Above are just a set of high-level skills that are expected of all DBAs, and the majority of DBA roles are derived from these skills, below. There are some important roles played by DBA. Database Maintenance/Design:-This is the main role of every database administrator, the word sounds simple but it involved a lot of things as a database administrator, from installation to patching and planning all activities that will be performed. by DBA. Apart from this, they also need to evaluate new database features, manage operating system and database changes. Database Backup/Restore:- The organization never wants to lose information and it depends on the DBAs for this, another important role of the DBA is to backup and restore the data. The majority of time scheduler features are used here to perform a database backup. Space management is also important at this stage and the archiving process is also carried out by DBA. The restore process is not used often, but it is an important part of the database administrator's role. Database Security Maintenance: -Data is very important and it is more important to keep it secure. The database administrator must ensure that the database is sufficiently secure. tracking all database access activities and denying permission to unauthorized users. It also involves creating new user roles, application role and maintaining these roles. Database Support:-Database is the heart of every application and to keep it running, 24/7 monitoring is required, the DBA team must support this monitoring and managing any problems that arise. Meanwhile, majority of the organization divides the DBA team into 3-4 teams to support different applications, all details with schedule are shared with the application and whenever necessary they contact the admin database available for this period. Database Monitoring:-DBA has to monitor the database for several reasons such as production traffic, performance, volume, traceability and security. The production environment needs a second eye to track active sessions, the DBA must keep track of all these active sessions using tools like 12C..