– “What does the job of DBA consist of?”

The DataBase Administrator or DBA is responsible for the design, implementation and management of DataBase Management Systems (DBMS).
DBMS, which are system software designed to create and manage databases, make it possible to read, write, modify, sort or restore information from these databases, depending on requests made by the user.

The DBA ensures the operation, but also the maintenance of these DBMS by adapting them according to technological developments and the needs of the company.
It is thus guarantor of the accessibility, quality and security of the data.

But the DBMS are numerous and varied and most of the time, they are of different designs, hence the difficulty of the DBA’s job and the extent of his task if he has to work on several DBMS.

Our CEO, Michel Payan, who has been a DBA for 25 years, has often noted that the companies in which he worked were faced with the same problem of setting up and maintaining the operating scripts of their DBMS.
With always the same need to guarantee the homogeneity of scripts across the fleet, the quality of the code, the management of errors and return codes.
This is why he had the idea and the desire to create multi-DBMS operation and maintenance software that could make the daily life of DBAs easier.

The dbSQWare software has now existed for 17 years and it is the only software in France capable of operating and maintaining, in a completely homogeneous manner, 12 different types of database engines.

We are pleased to announce that our dbSQWare software is now part of the SCC-CANUT Multi-Publisher software catalog.

Thanks to the recently created CANUT (Centrale d’Achat du Numérique et des Télécoms), for this integration!

The adventure goes on…
 

To obtain a better yield, it is important:
– increase performance
– to focus on tasks with high added value.

In terms of database engine management, too!

Hence the interest of using dbSQWare…
=> Very flexible, the software adapts to all companies, whatever their size and activity.
=> Thanks to its multiple functionalities, adopting dbSQWare not only means choosing serenity and control, but also making the team of administrators agile and scalable.

An optimized database improves query performance, reduces processing times and reduces resource consumption (CPU, RAM, Storage, etc.). This is why it is essential to maintain an efficient organization of databases.

Hence the need for reorganization when this is not the case.
This task consists of physically reorganizing indexes and/or tables with the aim of optimizing the use of disk space and improving access to data (through their organization), recovering unused disk space, left by deleted records and/or data updates.

The operation to be carried out depends on the degree of dispersion of the index (or table) information in the database (called fragmentation):
– compaction (REORGANIZE or COMPACT) is often necessary for fragmentation between 10 and 30%
– beyond that, a reconstruction (REBUILD) must be carried out.
A “side effect” of rebuilding a table is rebuilding all of its indexes.

In any case, a successful database is a database that is monitored and maintained.