Backend Software Engineer
- Developed multithreaded microservices for an oceanographic data platform using FastAPI, Pydantic, SQLAlchemy, and Pandas, reducing data processing times and research workloads
- Implemented REST APIs and integrated poorly documented external data sources, simplifying research data collection by providing access to 1M+ datasets through a single interface
- Decomposed a monolithic data integration system into 3 microservices and owned them end-to-end, allowing independent service scaling and improving maintainability
- Provisioned GCP infrastructure containing databases and serverless components, and automated deployment using Terraform, GitLab CI/CD, and Docker
- Denormalized PostgreSQL database tables and embedded simple foreign tables into JSON array columns, eliminating complex joins and improving the overall data integration performance
- Converted OWL ontologies into Neo4j graphs and SPARQL queries into Cypher, accelerating node retrieval and ontology load times, and enhancing the ontology visualization interface
- Replaced custom user authorization and authentication with an OAuth2 and OIDC compliant solution using Firebase and Identity Platform, enabling SSO and simplifying user onboarding