# SQL

> Selected work in SQL, with its engagement context and implementation review.

=> /portfolio/a-month-of-meter-readings-in-180-milliseconds/ 30 days of electricity data in 180 ms
=> /portfolio/made-a-geographical-data-pipeline-50x-faster/ Made a geographical data pipeline 50x faster
=> /portfolio/improved-gis-map-performance-10x-on-postgresql/ Improved GIS map performance 10x on PostgreSQL
=> /portfolio/resolved-1000-issues-in-geographical-data/ Resolved 1,000 issues in geographical data
=> /portfolio/designed-and-ran-6-etl-elt-pipelines/ Designed and ran 6 ETL/ELT pipelines
=> /portfolio/released-500-electricity-and-gis-data-reports/ Released 500 electricity and GIS data reports
=> /portfolio/ran-100-postgresql-ms-sql-bigquery-warehouses/ Ran 100 PostgreSQL, MS SQL, BigQuery warehouses
=> /portfolio/accelerated-postgresql-performance-by-10x/ Accelerated PostgreSQL performance by 10x
=> /portfolio/automated-gis-saas-deployment-with-github-actions/ Automated GIS SaaS deployment with GitHub Actions
=> /portfolio/led-30-gis-projects-from-build-to-support/ Led 30+ GIS projects from build to support
=> /portfolio/automated-data-processing-in-python-and-pl-pgsql/ Automated data processing in Python and PL/pgSQL
=> /portfolio/engineered-600-pl-pgsql-etl-elt-pipelines/ Engineered 600 PL/pgSQL ETL/ELT pipelines
=> /portfolio/designed-a-json-passthrough-from-postgres-to-api/ Designed a JSON passthrough from Postgres to API
=> /portfolio/designed-a-function-first-postgresql-data-layer/ Designed a function‑first PostgreSQL data layer
=> /portfolio/modeled-348-tables-across-34-postgres-schemas/ Modeled 348 tables across 34 Postgres schemas
=> /portfolio/built-first-party-analytics-inside-postgresql/ Built first‑party analytics inside PostgreSQL
=> /portfolio/built-a-loyalty-wallet-leagues-and-badges/ Built a loyalty wallet, leagues and badges
=> /portfolio/generated-495-pages-from-a-sqlite-export/ Generated 495 pages from a SQLite export
=> /portfolio/built-a-database-driven-cv-generator/ Built a database‑driven CV generator

=> https://data.engineer.company/categories/sql/ This page on the web
