top of page

Letting Data Speak, AI Act!

Case Study

Workload migration from on-prem to AWS - MAP Assessment

A mid-size K-12 ed-tech SaaS with 20+ years’ experience builds cloud learning platforms used nationwide. Its system handles heavy concurrent traffic, making this case relevant to any content-heavy SaaS managing large unstructured data in an older co-located setup.

About the Client

A mid-size K-12 ed-tech SaaS with 20+ years’ experience builds cloud learning platforms used nationwide. Its system handles heavy concurrent traffic, making this case relevant to any content-heavy SaaS managing large unstructured data in an older co-located setup.

Untitled design - 2024-09-27T104509.589.png

Challenge

  • Move stateful PHP learning platform from co-location to AWS.

  • Migrate 15-node web tier + 4-node MariaDB cluster

  • 340 TB of unstructured data (~914 M small objects) with no defined migration path.

  • 15 Mbps bandwidth made online data transfer impractical.

  • PHP app relied on local sessions, filesystem cache, and temp files, complicating scaling.

  • Database required a near-zero downtime migration while serving live users.

Untitled design - 2024-09-27T105551.128.png

Key Results

  • Cut 340 TB data transfer from ~1+ year to ~5–6 weeks using a hybrid Snowball Edge + DataSync approach.

  • Slashed cloud storage costs ~62% with lifecycle transition to Glacier Instant Retrieval, paying back the one-time investment in ~6 months.

  • Enabled near-zero downtime DB migration with AWS DMS CDC and cross-region replica, achieving seconds-lag RPO and minute-scale RTO.

  • Saved ~20–25% in app infrastructure costs by using a fixed 15-instance EC2 setup instead of Auto Scaling, avoiding ~$800–$1,100/mo in excess S3 request fees.Cut 340 TB data transfer from ~1+ year to ~5–6 weeks using a hybrid Snowball Edge + DataSync approach.

  • Slashed cloud storage costs ~62% with lifecycle transition to Glacier Instant Retrieval, paying back the one-time investment in ~6 months.

  • Enabled near-zero downtime DB migration with AWS DMS CDC and cross-region replica, achieving seconds-lag RPO and minute-scale RTO.

  • Saved ~20–25% in app infrastructure costs by using a fixed 15-instance EC2 setup instead of Auto Scaling, avoiding ~$800–$1,100/mo in excess S3 request fees.

Solution



  • Structured Engagement: Delivered a MAP Assessment with a migration roadmap, architecture design, and TCO analysis across four workstreams.

  • Infrastructure Discovery: Documented the co-location stack (15-node web tier, 4-node Galera cluster, load balancers, network), baseline OpEx, and stateful app characteristics to inform architecture.

  • Storage Migration Plan: Designed a hybrid Seed & Sync path using Snowball Edge + DataSync to migrate ~340 TB (~914 M objects) with validation layers and rollback procedures

  • Database Migration: Used AWS DMS with Full Load + CDC to achieve near-zero downtime to RDS MariaDB (Multi-AZ + cross-region replica) with cost-saving reserved instance guidance.

  • App Architecture Evaluation: Compared fixed 15-instance EC2 (recommended) vs Auto Scaling with externalized session/cache; recommended fixed for cost efficiency given workload patterns.

  • S3 Strategy & Lifecycle: Phased Intelligent-Tiering in Year 1 and Glacier Instant Retrieval from Year 2 onward (~62% storage cost reduction), with strong security controls (encryption, bucket policies, MFA Delete).

Untitled design - 2024-09-27T104509.589.png

Technologies Used

  • AWS Snowball Edge Storage Optimized (Physical Data Transfer)

  • AWS DataSync (Enhanced Mode — Delta Sync)

  • Amazon S3 (Intelligent-Tiering, Glacier Instant Retrieval, Lifecycle Management)

  • AWS Database Migration Service (DMS) with Change Data Capture (CDC)

  • Amazon RDS for MariaDB (Multi-AZ, Cross-Region Read Replica)

  • Amazon EC2 (t3a.large) with Application Load Balancer (ALB)

  • AWS CloudWatch (Monitoring, Transfer Validation, DB Insights)

Other Case Study Items

Implementation of Cloud-Agnostic Smart Meter Billing Solution

Implementation of Cloud-Agnostic Smart Meter Billing Solution

A leading Indian smart meter provider partnered with JashDS to transform their AWS-locked system into a cloud-agnostic solution built on Kubernetes, achieving an 80% reduction in processing time for managing millions of consumer accounts. The new system revolutionized smart meter management through the implementation of FastAPI and TimescaleDB, enabling efficient charge calculations, automated connection management, and comprehensive usage tracking for 6 million consumers.

Modernizing Data Ingestion for Green Energy AI

Modernizing Data Ingestion for Green Energy AI

JashDS modernized and automated data ingestion for a green energy AI solutions provider by developing a pipeline_builder library, reducing pipeline creation time by 40%, and improving data accessibility for 40+ utility sources.

Revolutionizing Data Infrastructure for AI-Driven Green Energy Solutions

Revolutionizing Data Infrastructure for AI-Driven Green Energy Solutions

JashDS revolutionized a green energy tech company's data infrastructure by implementing a scalable Matillion-based ETL solution and automated CI/CD processes, resulting in 2-3x faster client onboarding and a 35% reduction in Google Cloud costs. The comprehensive solution included reusable components, optimized SQL queries, and efficient data aggregation techniques, enhancing the client's ability to process vast amounts of utility data from 40+ companies and support their AI-driven green energy initiatives.

bottom of page