The DBA or system administrator of the BD a company is always regarded as the most experienced person in the area of \u200b\u200bdatabases. Therefore, it should be clear about the expectations generated around their work and what are the main roles to be resolved within the corporate framework or project.
Ensure system securityThe DBA should always monitor and manage system security. This involves adding and removing users, managing disk space (quota), audits and periodic review to identify likely problems of security.
risk prevention
Another task of the DBA is to schedule maintenance on the database (logical files) or to cooperate in maintaining machine system administrator. The DBA should strengthen its efforts in order to eliminate problems or hazardous situations.
Installing new software components
One of the main tasks of the DBA is the periodic installation of new Oracle software updates, both in terms of application programs as management tools . It is also recommended that the DBA own and other users of Oracle installation and test new configurations before migrating to production environments.
Interaction Managersystem In most cases the programs can only be installed or accessed by the system administrator. In this case, the DBA should always work very well coordinated with him to ensure that both the installation and configuration of software and hardware provides adequate performance database engine and application. Monitoring
The DBA must continually monitor system performance and be prepared to make adjustments to tuning it. On occasion this involves changing only a few parameters and sometimes rebuild or restructure rates tables. Backups
Because the most important task of DBA is to protect the integrity of the data, we must develop an effective strategy for data backup and recovery to maintain the stability of the stored information. The frequency of these backups should be decided depending on the number of processes that alter the data over time.
Other important tasks under often made to a DBA are:
- support the design and optimization data models.
- Analyze data and make recommendations regarding improving the performance and efficiency in handling data that are stored.
- Assist developers with knowledge of SQL and construction stored procedures and triggers , among others.
- Document and keep records of periodic maintenance, hardware and software upgrades, application changes and, in general, all events related to changes in the use of a database.
- Support the definition of design standards and classification of objects.
More Oracle
Mas Oracle