Description: There were consistent requests within the Government of Canada (GoC) and the Public Health Agency of Canada for there to be a highly scalable and highly available Google Cloud Platform (GCP) Cloud SQL instance that would also be able to have a GraphQL API.
Roles and Responsibilities: Full-stack and Cloud Developer
- Designed the system landscape and infrastructure diagrams that would allow for such an ask.
- Led a small team of developers to explore existing options, gather user requirements, and deploy the infrastructure in an automated fashion.
- Deployed and tested the infrastructure as code (IaC) solution with the appropriate security and use cases.
- Planned the strategic approach that would enable other teams to onboard to this process and have them create their instances.
Project Duration: 1 year
Environment:
- Git Bash
- Python
- git
- GCP Cloud SQL
- GCP Container Registry
- GCP Kubernetes Engine
- GCP IAM
- GCP Internal Networking
- Hasura
- PostgreSQL
- YML
- Kubectl