Oct 2019 - Feb 2021
The energy performance of buildings register is a government register of energy certificates, and the assessors qualified to create them. The certificates rate the energy performance of building stock in the UK, both domestic and commercial.
This project involved creating a new web application and associated infrastructure to host the energy performance of buildings register and migrating the existing 24 million certificates, and 84 thousand assessors.
My role covered the migration of certificates, and assessors into the new register application. This involved interfacing with an Oracle 12 database with a custom-built ETL pipeline leveraging AWS Lambda (Ruby), SQS and SNS. The ETL pipeline created certificates and assessors via an HTTP API service exposed by the new web application.
Stack
- Team Practises: Trunk based, 100% pairing, User-centered design
- Application: Sinatra, ActiveRecord, Postgres
- Deployment: CI/CD via AWS Codepipeline
- Infrastructure: A shared infrastructure between AWS managed with Terraform and GOV.UK PaaS (cloud foundry)
- Migrations: ETL using AWS SNS / Lambda / SQS