SQL

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

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

hThis page on the web	URL:https://engineer.company/categories/sql/	engineer.company	70
