Equifax cuts billing database trouble tickets from 20 a day to two a month
Equifax moved its global billing database to Oracle Autonomous Database running on AWS. The change ended size limits and cut maintenance tickets from up to 20 daily to just two a month.
Equifax has shifted its massive global billing system to a new setup that eliminates storage limits and cuts database maintenance. The credit reporting agency runs its billing software on Amazon Web Services. Previously, its back-end database ran on Amazon Relational Database Service for Oracle, but that service reached a capacity limit of 65 terabytes.
To solve the bottleneck, Equifax transitioned the workload to Oracle Autonomous AI Database running directly on AWS infrastructure. The change gave the company room to store petabytes of data without moving its core applications out of the AWS environment.
Zero downtime and faster processing
Equifax completed the data migrationData migrationThe process of moving digital files and information from one storage system or service to another. Open in glossary without taking its billing systems offline. Because the application stack remained hosted on AWS, engineers moved the underlying data without rewriting software code. The new system went live in April.
The migration quickly sped up operations across Equifax’s billing workloads:
- Collecting database statistics on nearly 100 terabytes of data dropped from three to four days down to three to four hours.
- Batch jobs expanded from processing 100 to 200 rows per transaction to handling 15,000 to 30,000 rows.
- Transaction rating speeds jumped by 200% to 300%, allowing the company to close its financial books much earlier.
Automated maintenance cuts tickets
The switch reduced the manual engineering work required to keep the system running. Equifax rates and invoices billions of transactions each month. Before the migration, technical teams handled 15 to 20 database tickets every day.
Thanks to automated database tuning, engineers no longer have to optimize individual database queries manually. As a result, related trouble tickets dropped to just one or two per month. The deployment is part of a broader multicloudMulticloudThe practice of using cloud computing services from two or more different providers at the same time. Open in glossary strategy at Equifax, which has shifted nearly all of its physical data centers to cloud services across AWS, Google Cloud, and Oracle Cloud Infrastructure.
How does this story land?
One tap per reader.
Quick poll
Will major cloud vendors hosting rival databases become the standard enterprise model?
One tap. No sign-up.
Ask this story
Still have a question?
Answers use only what is in this story. They are written by AI and can be wrong.