One of our first projects we took on when we started engaging with Skybound was to rebuild and migrate their existing Data Warehouse from Rackspace to AWS. Skybound’s Data Warehouse is a giant database where one single table has over 430 million rows that stores data from multiple sources and is integrated with Tableau for advanced data visualization and reporting.
The original Data Warehouse code was a mess of scripts and cron jobs scattered across a server. We had to not only manage migrating database tables with millions of rows of records from one cloud provider to another (the database was so big that the traditional AWS migration tool failed and we had to script the entire thing by hand table by table), but we also had to reverse engineer all of the existing scripts and rebuild them with best practice PHP in Laravel.
The solution was to migrate Skybound to a modern API application built with Laravel hosted on AWS
The result of this massive project is a scalable data infrastructure which we help to maintain and further scale. The previous solution required constant maintenance and management to keep all of the scripts and crons running properly. Now we have a scalable API system that we can continue to grow with new data and integrations.
We partner with Skybound, acting as an extension of their internal team to prove technical leadership for the organization’s online activities. Our team communicates using their internal communication channels, we have multiple calls per week, and their team directly contacts our engineering leads when issues arise. From system refactoring and ecommerce development to marketing support and back-office automation, we support Skybound through their ever-changing priorities and initiatives.