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.