Cost-effective cloud migration

Case Study: ​SQL Server to Oracle in AWS

Baltimore

Location

Research

Industry

850

Employees

Migration

RK Service

Product mix: AWS, Oracle, SQL Server

Background

A Baltimore based aerospace and astronomy research non-profit supporting NASA initiatives relied on legacy SQL Server databases hosted on-premises to manage its Deltek and Costpoint enterprise applications. As their infrastructure aged, the organization sought to modernize its data environment, improve scalability, and reduce on-premise maintenance costs by migrating to Oracle in AWS..

Challenge

The client's DBA team was highly experienced with SQL Server but had limited exposure to Oracle or AWS cloud architecture.

The planned migration introduced challenges including:

  • Understanding how to map existing SQL Server schemas and dependencies to Oracle
  • Designing a secure, cost-effective AWS environment for Oracle workloads
  • Ensuring post-migration application compatibility and performance for Deltek and Costpoint
  • Without a clear migration roadmap and architecture strategy, the risk of downtime and cost overruns was high.
Solution

I was brought in to architect, plan, and guide the full migration from SQL Server on-prem to Oracle in AWS. The engagement included:

  • AWS Architecture Design: Created a scalable and cost-efficient cloud environment optimized for Oracle workloads.
  • Migration Strategy: Developed a step-by-step migration plan including schema conversion, data validation, and rollback contingencies.
  • Implementation Support: Worked directly with the client’s DBA and application teams to migrate Deltek and Costpoint databases with minimal disruption.
  • Post-Migration Optimization: Validated performance, tuned configurations, and ensured operational readiness in the new AWS environment.

Throughout the process, I also coached the DBA team on Oracle operations and AWS best practices, empowering them to manage and maintain the environment independently after migration.

Results
  • Successfully migrated Deltek and Costpoint databases to Oracle in AWS with zero data loss
  • Reduced infrastructure costs by 40% through right-sized AWS architecture and optimized resource allocation
  • Improved system scalability and availability to support SLA's
  • DBA team gained hands-on Oracle and AWS expertise, ensuring long-term sustainability
100% Migration Success

data integrity, zero downtime

40% Reduction in Cost

via right-sized AWS resource

2.5x Performance Improvement

by query and config tuning 

RKKoranteng brings automation, agility, and practical learning into one accessible service.

D​atabase Engineering & Automation

Streamline builds, releases, and maintenance with proven DevOps tools and scripts that eliminate manual effort.

Practical Hands-On 
Learning

Train your DBAs and engineers through real-world labs and guided exercises that mirror production challenges.

Agile Transformation for Database Teams

Implement agile workflows, sprint ceremonies, and automation practices that align database work with business delivery.

Le​arn More
Modern Database Work Shouldn't Be This Hard

After years of supporting enterprise-scale databases, I saw talented teams stuck fighting the same battles - slow deployments, manual scripts, and a constant struggle to align database work with agile delivery.

So I built a service model that makes database management simpler, faster, and smarter - combining automation, training, and agile coaching into one powerful solution.

Lea​rn More

Measured Results

60%

reduction in deployment time through automation

3x

faster onboarding with hands-on learning

100%

agile adoption across database teams

Considering a move to Oracle in AWS? Let's plan it the right way
Schedule a Call