CASE STUDIES

Database fine-tuning

Davivienda

challenge

The company experienced high degradation rates in the daily processes of the Data Warehouse, thereby affecting the response times of the Processing and Infrastructure areas. Additionally, there were extended periods of unavailability due to the backup process, resulting in a loss of processing time and underutilization of resources.

Objectives
With our database fine-tuning service, create a strategy to optimize daily processes, thereby achieving reduced response times and early delivery of information to the end-user.

Client

Davivienda is one of the most recognized financial institutions in Colombia. It serves over 7.9 million users through a network of 597 offices, 1,802 ATMs, and has a presence in 822 municipalities.

Country

Colombia

Industry

Insurance

Presented solutions

Data & analytics

Solution

  • We optimize queries based on various fine-tuning techniques.
  • We fine-tune database administration processes using best practices.
  • We monitor the collected databases, detecting bottlenecks at various points in the infrastructure.

IMPACT

99% increase in platform availability due to maintenance windows for backup acquisition.

More than a 50% reduction in backup storage space costs.

The implementation of a recovery environment for an Oracle database exceeding 25TB without being in archive mode.

Reduction of daily process response times to 2 hours.

We are ready to work with you!

Ready to take the first step towards a successful collaboration? Fill out our form and leave your details. Your next professional adventure begins here.

Don’t like forms?

You can always reach out to us at: info@asesoftware.com

The fields marked with * are mandatory

By filling out and submitting this form, you are accepting the use of your data according to our confidentiality and privacy policy.