Contact us
Home
/
Case Studies
/

AWS-Based Data Lake and PostgreSQL Migration for Analytics Modernization in Pharma

Case study

AWS-Based Data Lake and PostgreSQL Migration for Analytics Modernization in Pharma

To reduce total cost of ownership (TCO), improve scalability and performance, and modernize the analytics environment by migrating from Oracle EDW to a cloud-based PostgreSQL platform with enterprise-grade open-source tools and AWS infrastructure.

Discuss a similar challenge
Read the study

Industry

Pharma & Life Sciences

Capability

Modernization & Migration Factory

Technology

AWS Database Migration Service (DMS)

AWS-Based Data Lake and PostgreSQL Migration for Analytics Modernization in Pharma
Significant
Cost Savings on Licensing
24x7
Streamlined 24x7 Support and Automation
3.2 TB
Data and Complex Schema Migration
High-Performance
Storage Strategy

Table of contents

Business objectiveSolutions & implementationTechnologies usedBusiness outcomes
Download PDFDownload PDF

Business objective

To reduce total cost of ownership (TCO), improve scalability and performance, and modernize the analytics environment by migrating from Oracle EDW to a cloud-based PostgreSQL platform with enterprise-grade open-source tools and AWS infrastructure.

Solutions & implementation

Assessed legacy Oracle architecture, user base, and application workflows to prepare migration scope.

Designed cloud-native data lake architecture using AWS infrastructure and open-source tools.

Used Ora2Pg, AWS SCT, and AWS DMS for automated schema and data migration; manually converted complex procedures.

Conducted detailed functional and performance testing to ensure parity and resolve any differences between Oracle and PostgreSQL environments.

Migrated full dataset in two phases—snapshot-based and incremental—and enabled AWS-based backups and recovery processes.

Major technologies used

AWS Platform

Cloud infrastructure foundation

PostgreSQL

Target open-source database

Oracle

Legacy source system

AWS DMS, AWS Schema Conversion Tool (SCT)

For database migration

Ora2Pg

Schema conversion

Aptus Data Accelerators

For automation and performance tuning

Business outcomes

Significant Cost Savings on Licensing

Migrated 9000+ Oracle users to PostgreSQL, eliminating license fees and reducing TCO.

Streamlined 24x7 Support and Automation

Reduced support overhead and enabled alert-driven, automated platform operations.

3.2 TB Data and Complex Schema Migration

Successfully migrated 900+ tables, 600+ procedures, and 200+ daily job scripts with minimal downtime.

High-Performance Storage Strategy

Implemented hot, warm, and cold data storage tiers for optimized processing and recovery.

Have a similar problem?

Tell us the workflow you want to move first and we’ll map it against what we have already shipped in your industry.

Discuss a similar challenge
Browse all results

Download the Case Studies