All posts
Case Studies

How Amazon's Consumer Business Turned Off Its Last Oracle Database: 7,500 Databases, 75 PB, 100 Teams

By

October 25, 2026

6 min read

In October 2019 Amazon's consumer business finished moving about 7,500 Oracle databases and 75 PB of data to DynamoDB, Aurora, RDS and Redshift, with little or no downtime. It cut costs by more than 60% and consumer-facing latency by 40%. How the work was split, why each workload went where it did, and what applies to a company with ten databases.

Case Study
Oracle
Database Migration
DynamoDB
Aurora
Amazon

What they did

  • Moved about 75 PB from nearly 7,500 Oracle databases, across more than 100 teams including Alexa, Prime, Prime Video, Kindle, Audible, Twitch and Zappos, finishing in October 2019.

  • Chose a target per workload instead of one standard: DynamoDB and ElastiCache for low-latency, high-scale key-value work; Aurora and RDS for transactional relational work; Redshift for analytics.

  • Covered every proprietary system, including purchasing, catalog, fulfillment, accounting and video streaming, with little or no downtime.

  • Retrained Oracle DBAs as migration specialists and cloud advisors rather than replacing them.

Want a second opinion on this for your system?

Book a free 30-minute call. You'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.

Outcomes AWS reported

Measure

Result

Database costs

Down more than 60%, on top of a heavily discounted Oracle rate

Consumer-facing latency

Down 40%

Administrative overhead

Down 70%

Advertising

Doubled database capacity in minutes instead of months

Buyer fraud

40 TB migrated with one hour of downtime; costs halved

Wallet

More than 10 billion records to DynamoDB; 90% lower cost, 50% lower latency

Our read

  • The biggest decision was not to replace Oracle with one thing. Workloads that were key-value in disguise went to DynamoDB and got faster; genuinely relational ones went to Aurora and RDS. A like-for-like database swap would have kept the old shape.

  • People were part of the plan. Retraining the DBAs kept the knowledge of what each database actually did, which is the part no tool converts.

  • For a company with a handful of Oracle databases, the same logic applies at smaller scale: classify each by access pattern, move the simple ones first, and leave the hardest PL/SQL estate on RDS for Oracle or Oracle Database@AWS if conversion does not pay.

hoolco Monthly Review

Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.

As of October 25, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.