Databases

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

130 days of electricity data in 180 ms	/portfolio/a-month-of-meter-readings-in-180-milliseconds/	data.engineer.company	70
1Made a geographical data pipeline 50x faster	/portfolio/made-a-geographical-data-pipeline-50x-faster/	data.engineer.company	70
1Improved GIS map performance 10x on PostgreSQL	/portfolio/improved-gis-map-performance-10x-on-postgresql/	data.engineer.company	70
1Resolved 1,000 issues in geographical data	/portfolio/resolved-1000-issues-in-geographical-data/	data.engineer.company	70
1Designed and ran 6 ETL/ELT pipelines	/portfolio/designed-and-ran-6-etl-elt-pipelines/	data.engineer.company	70
1Released 500 electricity and GIS data reports	/portfolio/released-500-electricity-and-gis-data-reports/	data.engineer.company	70
1Ran 100 PostgreSQL, MS SQL, BigQuery warehouses	/portfolio/ran-100-postgresql-ms-sql-bigquery-warehouses/	data.engineer.company	70
1Ran 10 PostgreSQL and MS SQL servers on Ubuntu	/portfolio/ran-10-postgresql-and-ms-sql-servers-on-ubuntu/	data.engineer.company	70
1Wrote 1,000 RBAC rules to secure Linux servers	/portfolio/wrote-1000-rbac-rules-to-secure-linux-servers/	data.engineer.company	70
1Accelerated PostgreSQL performance by 10x	/portfolio/accelerated-postgresql-performance-by-10x/	data.engineer.company	70
1Automated 100 critical data backups using Barman	/portfolio/automated-100-critical-data-backups-using-barman/	data.engineer.company	70
1Led 30+ GIS projects from build to support	/portfolio/led-30-gis-projects-from-build-to-support/	data.engineer.company	70
1Automated data processing in Python and PL/pgSQL	/portfolio/automated-data-processing-in-python-and-pl-pgsql/	data.engineer.company	70
1Engineered 600 PL/pgSQL ETL/ELT pipelines	/portfolio/engineered-600-pl-pgsql-etl-elt-pipelines/	data.engineer.company	70
1A maritime platform with clear system boundaries	/portfolio/a-maritime-platform-built-in-clean-layers/	data.engineer.company	70
1Designed a JSON passthrough from Postgres to API	/portfolio/designed-a-json-passthrough-from-postgres-to-api/	data.engineer.company	70
1Designed a function‑first PostgreSQL data layer	/portfolio/designed-a-function-first-postgresql-data-layer/	data.engineer.company	70
1Time‑ordered keys for a growing data model	/portfolio/quicker-answers-from-a-better-choice-of-key/	data.engineer.company	70
1Implemented a catalogue‑driven deep‑merge	/portfolio/implemented-a-catalogue-driven-deep-merge/	data.engineer.company	70
1Modeled 348 tables across 34 Postgres schemas	/portfolio/modeled-348-tables-across-34-postgres-schemas/	data.engineer.company	70
1Implemented backups and disaster recovery as code	/portfolio/implemented-backups-and-disaster-recovery-as-code/	data.engineer.company	70
1Built Stripe and in‑app purchase entitlements	/portfolio/built-stripe-and-in-app-purchase-entitlements/	data.engineer.company	70
1Moved slow work onto a River job queue	/portfolio/moved-slow-work-onto-a-river-job-queue/	data.engineer.company	70
11,022 migrations behind a schema drift gate	/portfolio/1022-migrations-behind-a-schema-drift-gate/	data.engineer.company	70
1Built first‑party analytics inside PostgreSQL	/portfolio/built-first-party-analytics-inside-postgresql/	data.engineer.company	70
1Built a loyalty wallet, leagues and badges	/portfolio/built-a-loyalty-wallet-leagues-and-badges/	data.engineer.company	70
1Built the hiring and seafarer career workspaces	/portfolio/built-the-hiring-and-seafarer-career-workspaces/	data.engineer.company	70
1Generated 495 pages from a SQLite export	/portfolio/generated-495-pages-from-a-sqlite-export/	data.engineer.company	70
1Built a database‑driven CV generator	/portfolio/built-a-database-driven-cv-generator/	data.engineer.company	70
1Wrote tests for the checkers themselves	/portfolio/wrote-tests-for-the-checkers-themselves/	data.engineer.company	70

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