Use our template to create a compelling and comprehensive Database Administrator job description to attract top talent.
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…
You can also read : Why and how to make a technological watch? and 10 Top Database Certifications
