Sitemap
A browsable index of every page on engineer.company.
A human-readable index of every page on the site.
Platform and Data Engineer
- Drove brand engagement and loyalty by 100% through market trend analysis and consumer behavior insights.
- Designed a comprehensive infrastructure framework for DTU impacting 14 departments, featuring flexible modules, unified data pipelines, and structured support strategies for long‑term adoption.
- Engineered hourly electricity consumption aggregation pipeline in Python / SQL / Bash + Jq, achieving 180ms for 30‑day datasets across heterogeneous JSONL sources.
- 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.
Data Engineer
- Accelerated geographical data pipeline performance by 50x by improving SQL programming and data modeling across PostgreSQL, MS SQL, and Google Cloud BigQuery.
- Improved geographical map application performance by 10x through strategic database transition from MSSQL to PostgreSQL, optimizing processing and data security.
- Resolved 1,000 issues in geographical data and time‑series data, using GDAL, ArcGIS, PostGIS, Mapbox, QGIS, SQL (PL/pgSQL, Transact‑SQL), Bash, ensuring high‑quality big data processing.
- Designed, implemented, and administered 6 ETL/ELT pipelines, utilizing Google BigQuery, MSSQL, PostgreSQL, Shell scripting, PL/pgSQL, and Transact‑SQL, integrating data for efficient Python API processing.
Data Analyst
- Developed and launched the company's first observability dashboard, providing real‑time system performance insights and data visualization on the large office TV.
- Delivered 8 Power BI projects with comprehensive manuals, integrating Microsoft Power BI tools with NodeJS API and Python FastAPI for effective data analytics and visualization.
- Released 500 electricity and GIS data analysis reports, utilizing deep research and troubleshooting to ensure accurate geographic and time series big data insights.
- Engineered 600 PL/pgSQL‑based ETL/ELT pipelines to streamline complex data processing workflows across multiple PostgreSQL development and production environments.
Database Engineer
- 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.
- Designed, deployed, and maintained 10 PostgreSQL and MS SQL servers on Ubuntu Linux VPS, ensuring optimal server performance and reliability.
- Enhanced data security by implementing 1,000 RBAC rules for developers, application instances, PostgreSQL, MS SQL, and other Linux servers, preventing unauthorized access; documented with Ansible automation.
- Accelerated PostgreSQL performance by 10x via strategic indexing, partitioning, and query optimization, enhancing database efficiency for user, tenant, geospatial, and time‑series electrical data.
DevOps Engineer
- Automated GIS SaaS application deployment, data processing, and reporting system using GitHub Actions CI/CD, Python, Bash, and SQL.
- Automated delivery of 20 GIS data pipelines and app data ETL processes, streamlining infrastructure automation and reporting.
- Automated 100 critical data backups using Barman, Google Cloud, Bash, and Python, ensuring data integrity across databases.
GIS Software Development Team Lead
Product Owner and Project Development Manager
GIS Software Development Team Lead
Data Engineer
- Streamlined data analysis and software development processes, saving 4,000 hours by introducing GitHub, GitLab, Bash, and Python CI/CD practices.
- Developed a Data Analytics reporting system, increasing quarterly software revenue by 400% through Python‑based PDF reports.
- Automated data processing tasks using Shell scripting, PL/pgSQL, Python, and Transact‑SQL, increasing productivity and efficiency.
Platform Architect
- Architected a layered maritime platform separating a Next.js PWA frontend, a Go (Huma/Fiber) API, and a PostgreSQL function layer, keeping all business logic in the database.
- Designed a JSON passthrough architecture where PostgreSQL functions return complete JSON forwarded verbatim by the Go API, eliminating intermediate unmarshalling and decoupling the frontend from schema changes.
Data Engineer
- Built the Python vessel‑data scrapers (MarineTraffic, Maritime‑Database) and a repeatable import that seeds the platform's reference data — 184,197 rows, including 698 companies and 56,149 vessels.
- Modeled the maritime domain into 348 normalized tables across 34 PostgreSQL schemas — professionals, companies, ships, jobs, reviews and the rest — with SMALLINT lookups and UUID v7 keys.
- Built first‑party product analytics in PostgreSQL — 47 functions over partitioned event tables that prune themselves — pseudonymised behind a rotating salt and gated on the visitor's consent.
Backend Engineer
- Built the payments and entitlements layer — Stripe alongside Apple and Google in‑app purchase — gating the directory, search and export through an 11‑table access model checked on the server.
- 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.
Database Engineer
- Designed a PostgreSQL function‑first data layer — 1,275 stored functions across 34 schemas — so every read and write goes through a function the database can grant, rather than through a table.
- Adopted UUID v7 time‑ordered identifiers (PostgreSQL 18) as entity keys to reduce B‑tree index fragmentation and speed up queries.
- Implemented a catalogue‑driven deep‑merge for stored JSON preferences, preventing missing‑key crashes as the schema evolves.
- 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.
- Built the loyalty and reputation system — 67 functions over a 31‑table ledger, with leagues, badges and a redemption shop — taking a row lock on the balance to close the double‑spend window.
Site Reliability Engineer
Full Stack Engineer
Data Analyst
Process Automation Engineer
Security Engineer
Python Engineer
Build and Release Engineer
Test and Quality Engineer
- Generated 495 achievement pages across three languages from a read‑only SQLite export, with the page address authored as data so that correcting a sentence no longer moved the page and broke the link.
- Wrote tests for the checkers themselves after establishing that a checker fed only clean input will one day report clean because it read nothing — planting a misspelling to confirm the spell‑check finds it, and taking an id range from the database rather than from a number in the test.
Database Engineer
- Moved every user‑facing string out of Python into a content tree of 874 files across three languages, after finding dead translations nobody could see were dead and a check silently grading a third of the achievements.
- Built a cross‑language content check that fails when a translation drops a figure the English states, and when a language uses notation it does not use — finding two Danish descriptions missing a metric and sixteen Ukrainian spans quoting in the English style.
Digital Presence and SEO Lead
Services
- Backend & API Development
- Backup & Disaster Recovery
- Brand, Marketing & SEO
- Data Analytics & BI Dashboards
- Data Governance & Quality
- Data Pipeline Development (ETL/ELT)
- Data Warehouse Design
- Database Administration (DBA)
- Database Design & Modeling
- Database Migration & Modernization
- Database Performance Tuning
- DevOps & CI/CD Automation
- Frontend Development
- Full‑Stack Product Development
- GIS & Geospatial Solutions
- Internationalization & Localization
- Infrastructure as Code
- Platform & Solution Architecture
- Product Strategy & Requirements
- Project Management (Agile)
- Security & Access Management
- Site Reliability & Monitoring
- System Administration
- Technical Documentation
- Technical Leadership & Consulting
- Website Development & CMS
Categories
- Agile & Scrum
- APIs & Integration
- Automation & CI/CD
- Backend Engineering
- Brand & Marketing
- Cloud
- Containers (Docker/Kubernetes)
- Data Analytics
- Data Engineering
- Data Governance
- Data Pipelines (ETL/ELT)
- Data Warehousing
- Databases
- DevOps
- Documentation
- Frontend Engineering
- Full‑Stack Development
- GIS / Geospatial
- Internationalization
- Infrastructure
- Linux & Servers
- Migrations & Modernization
- Networking & VPN
- Monitoring & Observability
- Performance Tuning
- Platform Architecture
- PostgreSQL
- Product & Requirements
- Project Management
- Python
- Reliability & Backups
- Security
- Solution Architecture
- SQL
- Stakeholder & Reporting
- System Administration
- Team Leadership
- Technical Leadership
- Testing & QA
- Web Development
