Nurix

Nurix Therapeutics discovers drugs that harness the body’s natural process to control protein levels. Nurix drugs control ubiquitin E3 ligases, the key enzymes responsible for protein breakdown in human cells, as a unique therapeutic approach to treat a broad range of cancer diseases.

Challenge

  • This migration is necessitated by Nurix’s need to decommission an on-premise Oracle database and to deploy a solution on AWS Aurora
  • PostgreSQL to support the ongoing user
  • Requirements: One of the main reason to move to the cloud is the shortage of storage space they need more disk space as each month their DB size is increasing (database size is currently around 1.2 TB). They were also looking to avoid cost for oracle license
  • They were looking for good backup and restore mechanism, currently the only way to backup was to copy the database through data pump and to restore it on other machine. It takes around 18 hours to restore the database of 1.2 Terabytes of backup

Solution Delivered to Meet Challenges

On premises Oracle database was moved to RDS Aurora PostgreSQL:

  • Restored database dump provided by NURIX in S3 to Oracle EC2 Instance on AWS.
  • SCT was then used to migrate schema from Oracle to RDS Aurora
  • DMS service was used to migrate data from Oracle to RDS Aurora

Architecture Diagram

Nurix – AWS Database Migration

AWS Services Used

  • AWS IAM
  • AWS VPC
  • AWS EC2
  • AWS RDS Aurora PostgreSql
  • AWS S3
  • AWS SCT
  • AWS DMS
  • AWS EMR
  • AWS CloudFormation

Database Workload Migration Details

  • Oracle Source Schema: DNATAG
  • No of Tables in Source: 17
  • Number of rows in largest table: More than 9 billion records

Migration Patterns Used

  • Re-platform but for heterogeneous migration i.e on-premise Oracle to RDS Aurora PostgreSQL

Migration Tools Used

  • Data Pump Import to restore backup on EC2 Oracle
  • DMS to move data from EC2 to RDS

Third-Party Tools Used

  • Custom build schema and data validation code snippets

About NorthBay

We are a fast-growing, 100% AWS focused onshore/offshore AWS Premier Consulting Partner, supporting our customers to accelerate the reinvention of their applications and data for a Cloud-native world. Our >350 AWS Certified Employees excel in developing and deploying Database & Application Migrations, Data Lakes and Analytics, Machine Learning/AI, DevOps and Application and Data Modernization/Development that drive measurable business impact.