Dealer.com needed specialist database assistance with their large MySQL database backend, comprising over 20 individual database servers and 3Tb of data. Working with an excellent home grown team, we are in the process of upgrading, enhancing and performance tuning this platform.
An additional pert of the project involves a complete data centre migration, both to another physical location and into the AWS cloud offering.
ParkNow embarked on a stream of work to migrate their existing data centre provision into the AWS cloud. Using HashiCorp Terraform to automate the creation of the infrastructure within AWS, including the use of RDS Aurora for database provision, EC2, ECS and Lambda for compute, and SQS, SNS and S3 to glue the components together.
Travis Perkins needed a specialist database database administrator to work on performance tuning and stabilising the high availability of a large Hybris / MySQL estate of over 100 instances in a virutalised environment. Following on from this, I worked with a skilled DevOps team to migrate the website development pipeline and production environment onto a fully automated infrastructure in AWS, focusing on using RDS to provide the MySQL backend and creating a selection of housekeeping Linux scripts.
Yodel were having performance issues with their MySQL backed Ruby website, and I was brought in to help tune and maintain that environment. Moving on from that project, I worked closely with both an internal team and a third party provider to replace the core billing function with a MS SQL backed product. Another project involved dissecting and updating an internal system using MS Excel and MS Access, in order to enhance performance and reliability.
I worked with Riplife Gaming Technologies for a short period to help them tune their MySQL backend database, and provide suggestions on how to handle their predicted huge data growth.
SG Group (Business Solutions)
SG Group (Business Solutions) is a specialist recruitment and management organisation supporting a client base throughout Europe, Asia, Africa and the USA. They required a custom built website to allow their staff to maintain a list of vacancies that they are fulfilling for their clients.
Grade 1 Management
The Grade 1 Management website was custom built to allow the team to upload quality assurance information for their clients, who can then monitor and analyse the data over time to help them improve their output.