Administrator of databases

The administrator of databases designates a person responsible for the good performance of a Database so much on the level of the design, test, coordination, and charges it with the protection and the control of use. This profession is related with the analyst warehouse of data (datawarehouse), the originator database, it Manager database and Dated it Administrator Base (DBA)

Description

This worker is mainly in load of:

integrity of the data: he checks or helps to check the coherence of the data of the base so that they do not return in conflict with the principles of the real system. For that, it is in charge of the implementation of constraints of integrity.
safety: it defines or implements the access to the data by authorizing the users according to the needs to reach or to modify them it.
the performance: it ensures that the access to the data is done in a reasonable time. It must thus take care to have tables, index, statistics and requests SQL optimized by using for example tools for optimization SQL (tuning SQL).
development assistance and with the test: it must provide a support to the development teams. For example, it can retort partially of the data on a basis of test, optimize the base with the developers and modify the diagram to implement the new functions.
the covering of data: it must create and test backup solutions so that in the event of error of seizure, bug software or material problem it can give the base quickly as it was before its deterioration.

The realization of the diagram of the base of given often forms part of its functions, in spite of the fact that it falls normally on the Analyste or with the originator (sometimes with the developer).

The dBa works in close relationship with the System administrator and the developers within a DSI.

It must be able to know the systems of production well or of services existing on the field sites of the database.

General terms of exercise of the profession

This profession is exerted according to regular work hours, but can cause the service of overtime or weekend, in the event of breakdown or of engineering problems. Important intellectual efforts are sometimes necessary in order to follow the data and to include/understand the nomenclature and the structure of it. The profession is exerted mainly in front of a screen.

Formation

The access to this activity generally requires a diploma of the Higher education or academic. The interest for the mathematical models and the aptitude to be thought in a structured way also form part of the selection criteria.

Random links: