Database Administrator: Job description

avatar

ByMindquest

Published05 September 2022at11:35, updated on07 September 2022at14:43

Database Administrator: Job description cover

The job of the database administrator is to design, manage and administer database management systems and to ensure the consistency, quality, security, and ongoing accessibility of information.

Data Administrator: the job

The following are the steps a database administrator takes to perform his or her job.


Also read the difference between Big Data and Business Intelligence


Design of databases

After taking into account the client’s specific requirements, particularly concerning the size of the database, the database administrator sets up standards and good practices for the development teams.
In collaboration with the various project stakeholders, he/she defines the database implementation choices. Following this, the administrator defines the database parameters, the security rules, models, and designs the tables and keys.

Administration and maintenance

Once the database has been set up, the administrator must implement the data on the technical support. In terms of administration, this means guaranteeing the availability and quality of the data, administering access authorizations, and dealing with security issues. On the other hand, in terms of maintenance, this means ensuring that the data is updated, backed up, and upgraded. It is also the Database Administrator’s responsibility to guarantee the recovery of data and the restoration of conditions following an incident, as well as the correction of any bugs.

Technological monitoring and control of the database

The role of this professional is also to monitor the evolution of database versions and to carry out tests and validation of their management. He/she will also have to anticipate technical developments with a daily technology watch.

Required skills of the Database Administrator

Technical skills

The Database Administrator is familiar with the main software (Oracle, MySQL, SyBase, SQL Server, etc.), the SQL query language, and security issues. Knowledge of Shell scripts under UNIX, Windows or MVS as well as knowledge of technical English is also essential.

Understanding the environment

For this professional, an understanding of the environment, its development, and its operation is essential. Good knowledge of the activities and of the client enables him/her to anticipate the latter’s needs and also to intervene more effectively when necessary.

Reactive and methodical

Methodical and synthetic are the keywords of the database administrator. As with all freelancers, they are also expected to be open-minded and adaptable.

Context

Since the administrator evolves on different supports: mobile databases, shared databases or datawarehouses, the functions of network architect and database administrator are often confused.

The administrator is a real link between the project managers and engineers and the users of the database in order to better define the needs of each person and the company.
The system administrator is required to work on call. Indeed, the systems operate 24 hours a day and many operations require action outside office hours.

As far as the hierarchical reporting line for the freelance database administrator is concerned, it is most often the mission director or technical director.


Also read IT infrastructure: components, job profile, and best practices


Salary

The average daily rate is between €480 and €550

Career progression

This Database Administrator position requires previous experience but will also allow you to progress. For example:

Database Architect
Expert consultant in database optimization
Storage manager or infrastructure manager

Head of a DBA team
Chief data officer

Database administrator: Training and education

To conclude, the Database Administrator has a profile with high technical added value. In other words, they may have a background in development with a specialization in databases or a generalist background in systems and networks.

Level bac + 3
License pro specializing in database administration or distributed systems…

Bac + 5 level
Master’s degree in databases and distributed applications, decisional computing…
Engineering degree with a specialization in database engineering or operation…

Share this article

By Mindquest

Mindquest Connect offers you a collection of articles and innovative content for recruiters and IT professionals.

Mindquest

Are you looking for a talent or an IT opportunity? We connect the best profiles to the best offers for a perfect match between business and IT talents.

Articles you might be interested in

Subscribe to our IT newsletter

Connect with the latest news in the IT and Tech sector

Connecting top IT talent and the best industry jobs


These companies trust us for their IT talent needs
AIR Liquide
BIOGARAN
Coyote
Imerys
La poste
Microsoft
Saint Gobain
Savencia
Suez
Vivescia
Vinci