RautioProjects.
Let's talk

02 / Project tag

Projects tagged “cloud”.

Matching projects

All projects in the catalogue using this shared topic.

  1. 04

    From Homelab Prototype to Cloud Deployment

    A secured cloud-hosted platform for running services, managing traffic, and supporting real-world workloads.

    Problem
    Needed to transition validated concepts from a local testing environment into a production-ready platform.
    Solution
    Built and secured a cloud-hosted infrastructure for running services, managing traffic, and supporting real-world workloads.
    Technologies
    Cloud Platform · Linux · Containers · DNS · Security
    Role
    Infrastructure architect & operator
    What I learned
    A well-tested foundation enables faster and more predictable production deployments.

  2. 06

    Home Assistant Data ETL Pipeline to Cloud PostgreSQL

    A Python ETL pipeline that transfers numeric Home Assistant sensor history from a self-hosted PostgreSQL database to a cloud warehouse.

    Problem
    Needed to keep Home Assistant local while making selected historical sensor data available for cloud-based reporting and analysis.
    Solution
    Built a scheduled Python pipeline that extracts new numeric sensor states incrementally, transfers them through an SSH tunnel, and loads a Bronze/Silver/Gold PostgreSQL warehouse with run and step monitoring.
    Technologies
    Python · PostgreSQL · SSH · psycopg · Medallion · Bronze/Silver/Gold · cron
    Role
    Data pipeline designer & implementer
    What I learned
    Incremental boundaries, transaction handling, monitoring, and explicit cleanup make even a small ETL job reliable and recoverable.