# Reliability & Backups

> Selected Engineer ApS work demonstrating Reliability & Backups — the achievements that prove it.

- [Developed and launched the company's first observability dashboard, providing real‑time system performance insights and data visualization on the large office TV.](https://data.engineer.company/portfolio/developed-and-launched-the-company-s-first-observability-9/)
- [Architected, created, and managed 100 PostgreSQL, MS SQL, and Google BigQuery data warehouse databases with primarily GIS and time‑series data, optimizing performance and scalability.](https://data.engineer.company/portfolio/architected-created-and-managed-100-postgresql-ms-sql-12/)
- [Designed, deployed, and maintained 10 PostgreSQL and MS SQL servers on Ubuntu Linux VPS, ensuring optimal server performance and reliability.](https://data.engineer.company/portfolio/designed-deployed-and-maintained-10-postgresql-and-ms-13/)
- [Automated GIS SaaS application deployment, data processing, and reporting system using GitHub Actions CI/CD, Python, Bash, and SQL.](https://data.engineer.company/portfolio/automated-gis-saas-application-deployment-data-processing-and-16/)
- [Automated delivery of 20 GIS data pipelines and app data ETL processes, streamlining infrastructure automation and reporting.](https://data.engineer.company/portfolio/automated-delivery-of-20-gis-data-pipelines-and-17/)
- [Automated 100 critical data backups using Barman, Google Cloud, Bash, and Python, ensuring data integrity across databases.](https://data.engineer.company/portfolio/automated-100-critical-data-backups-using-barman-google-18/)
- [Led the development, deployment, and support of over 30 GIS projects, demonstrating expertise in PostgreSQL, Bash, Python, JavaScript, GDAL, ArcGIS, PostGIS, and Mapbox technologies.](https://data.engineer.company/portfolio/led-the-development-deployment-and-support-of-over-35/)
- [Architected, developed, implemented, supported infrastructure, data processing, and the map application for 2 years non‑stop without any weekends, holidays, or vacations, 10–14 hours a day.](https://data.engineer.company/portfolio/architected-developed-implemented-supported-infrastructure-data-processing-and-55/)
- [Configured database backup retention as infrastructure‑as‑code, then audited the recovery position and documented the restore procedure — naming the remaining gaps rather than leaving them to be found during an incident.](https://data.engineer.company/portfolio/configured-database-backup-retention-as-infrastructure-as-code-72/)
- [Moved slow work off the request path onto a River job queue — 15 worker modules, 8 scheduled tasks and 20 pg_cron jobs — so a request returns while the work behind it carries on.](https://data.engineer.company/portfolio/moved-slow-work-onto-a-river-job-queue-97/)
- [Kept the schema honest across 1,022 migrations with a CI gate that builds the database both ways — a fresh install, and an install plus every migration — and fails when the two disagree.](https://data.engineer.company/portfolio/kept-the-schema-honest-across-1022-migrations-99/)

<https://data.engineer.company/categories/reliability/>
