Management of existing instances while maintaining their configuration and/or optimizing it if necessary to reach the best performance. Definition of security schemes and access of resources from the Database Instance to each particular database. Manage the physical resources from where the Database engine executes to run, such as the hard drive, memory and CPU.
The constant monitoring of the instances and Database to make adjustments in configuration before they can cause any problem and address the most common problems that are exposed to a database instance such as locks, hardware failures, recovery of errors in database files, etc.
We locate the most expensive queries of the applications and/or reports, make proposals for correction, we find the indexes needed and those that are useless.