Database data processing and space usage optimization

Project goals:

  • Remediate space shortage for a 120+ TB database
  • Optimize data processing in the database, tune the system performance
  • Develop DB backup solution

Accomplishments:

  • The database size has been reduced by 60% by reclaiming unusable space
  • The data processing approach has been changed, implementing External Tables, to avoid unnecessary DB operations. This allowed to speed up data ingestion processes by 40%
  • A logical backup solution has been developed to suit the company’s target KPIs

Technologies:

  • Oracle Database
  • Oracle Linux
  • Oracle PL/SQL

Workload:

  • 50 hours

Project team:

  • Senior Oracle DBA

 

Peter Thomas
CTO, Blue Lance

Alex is one of the best Oracle DBA’s I have worked with. Excellent communication skills, it was great to work with Upgrade Consulting.

Michael Schmidt
Managing Director, XR Systems

We can recommend Upgrade Consulting without any restrictions. They are, without any question, a shining star among the Oracle DBAs on the market.

Kashif Ahmed
CEO, MediaLink

Wonderful and dedicated guys. They fixed all our system problems in a smart and proffesional way. Will definitely hire them for our future projects. Thanks for provding a great solution!

Adrienne Daly
Managing Director, Amos

Upgrade consulting has designed the whole database solution for us and has led the project to the successful implementation. It’s a pleasure working with this team.

Deepak Gupta
COO, Balluun

Competent and confident at what they do. They go the extra mile to research and find the best solution to any problem. A great resource for specific projects or continious support.

Get a quote in 24 hrs

    Required field
    Required field