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
Want to make a successful project?
Need to save costs and consolidate your data assets? Tweak the database performance or execute 0% downtime database migration? Our creative approach unlocks business potential and focus on creating newer possibilities