# Engineer — Database & Data Pipeline Engineering, Copenhagen

> We design, tune and migrate the databases a business runs on, and we build the pipelines that move data between them.

## We keep the data your business runs on correct, quick to access and recoverable.

Database design, administration, tuning and migration, pipelines, warehouses and dashboards — from Copenhagen.

What we do

See our work

## Databases and data pipelines that hold up

+45 50 10 61 84 · Copenhagen, Denmark

Explore our services

We design, tune and migrate the databases a business runs on, and we build the pipelines that move data between them. The work records describe the starting situation, what was done and the result.

Bring one database or data flow and the questions it must answer. We can scope a review that leaves you with a written diagnosis and a prioritised implementation plan.

Database and pipeline work · Pricing and engagement options · Discuss your project

## Photographs

Keyboard, computer, laptop

Photo: webandi / Pixabay

Keyboard, hand, typing

Photo: councilcle / Pixabay

## Start with the result you need

Tell us what your business needs to achieve. We connect software, data and infrastructure around the people who use them.

Explore our services

Get in touch

## See how we approach the work

Find a service that matches your goal and see examples of what was delivered and how.

Cases

Get in touch

## Cases

Selected projects, with their scope, key decisions and our role in the work.

### A maritime platform with clear system boundaries

The founder’s work for NextMariner separates a Next.js interface, a Go API and PostgreSQL business rules. Each layer has a defined responsibility.

2025
* Frontend request
* Go API
* PostgreSQL JSON

Implementation overview of the request path, with outcomes and measurement context kept in the case text.

Read the case study

### One infrastructure plan for 14 departments

Designed a shared framework for a research institute that 14 departments could run on together, each keeping the things that make it different.

2025

Read the case study

### 30 days of electricity data in 180 ms

Implemented Python, JQ and SQL variants for hourly electricity aggregation. In the recorded benchmark, Python processed one dataset covering 30 days in 180 ms.

2025

Read the case study

### A mapping product, carried end to end

Infrastructure, data processing and the map application itself, built and kept running for two years.

2025

Read the case study

Engineer ApS was registered in 2025. These cases include company projects and work our founder carried out in client teams and as an employee, dating back to 2003. Each case explains the role and working arrangement.

## What the work delivered

Selected results from the founder's project record. Figures describe the work and period in each linked review.
* 180 ms to aggregate a month of meter readings
* 50x faster geographical data pipelines
* 600 ETL pipelines engineered in PL/pgSQL
* 1,000 access rules written to close a security gap
* 151 stored functions behind hiring and career

## Read the work in its context — the decisions, delivery and reported outcomes.

See the whole catalogue

## One partner for 9 services from the schema to the dashboard.

Browse the catalogue

## Somewhere sensible to keep your data

Data & Databases

Database Design & Modeling

A structure that matches how the business actually works, so the questions you need answered later are still possible to ask.

### Built a database‑driven CV generator

Built a database‑driven CV, references, portfolio and cover‑letter generator in Python — 41 modules, 10,580 lines — rendering six output formats from one 23‑table SQLite source assembled by a 19‑step idempotent pipeline.

### Built the hiring and seafarer career workspaces

Built hiring and seafarer career workspaces; the recorded implementation snapshot contains 151 stored functions across 48 tables for vacancies, applications, certificates, rank progression and sea time.

### Built a loyalty wallet, leagues and badges

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.

See all 14 achievements

## How we work

### Understand first

We learn the problem before we propose a solution. The brief you arrive with is the start of that conversation, not the end of it.

### Build it to last

Durable over quick, clarity over cleverness. The system still has to be workable by the people who inherit it.

### Stand behind it

We agree any ongoing operation or support as part of the engagement. Handover makes responsibilities and the next contact route clear.

## Looking after the database

Data & Databases

Database Administration (DBA)

Somebody responsible for the thing the whole company rests on: it is up, it is backed up, and it is not quietly rotting.

### 1,022 migrations behind a schema drift gate

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.

### Implemented backups and disaster recovery as code

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.

### Engineered 600 PL/pgSQL ETL/ELT pipelines

Engineered 600 PL/pgSQL‑based ETL/ELT pipelines to streamline complex data processing workflows across multiple PostgreSQL development and production environments.

See all 9 achievements

## Making the slow parts fast

Data & Databases

Database Performance Tuning

Finding the queries and the missing indexes behind a system that has got heavier every year, and fixing the ones that matter.

### Time‑ordered keys for a growing data model

Adopted UUID v7 time‑ordered identifiers (PostgreSQL 18) as entity keys to reduce B‑tree index fragmentation and speed up queries.

### Accelerated PostgreSQL performance by 10x

Accelerated PostgreSQL performance by 10x via strategic indexing, partitioning, and query optimization, enhancing database efficiency for user, tenant, geospatial, and time‑series electrical data.

### Ran 100 PostgreSQL, MS SQL, BigQuery warehouses

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.

See all 6 achievements

## Getting off the old system

Data & Databases

Database Migration & Modernization

Data taken out of something ageing and into something supported, with the business still running while it happens.

### Moved every string into a content tree

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.

### 1,022 migrations behind a schema drift gate

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.

### Improved GIS map performance 10x on PostgreSQL

Improved geographical map application performance by 10x through strategic database transition from MSSQL to PostgreSQL, including the data cutover, optimizing processing and data security.

## Getting your data from A to B on its own

Data & Databases

Data Pipeline Development (ETL/ELT)

Numbers arriving where they are needed, on a schedule, without anyone copying a spreadsheet at the end of the month.

### Generated 495 pages from a SQLite export

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.

### Built first‑party analytics inside PostgreSQL

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.

### A mapping product, carried end to end

Architected, developed and supported infrastructure, data processing and a map application over 2 years, covering both software delivery and operational maintenance.

See all 14 achievements

## One place where all the numbers agree

Data & Databases

Data Warehouse Design

Sales, operations and finance figures brought together, so two departments stop bringing two answers to the same meeting.

### Ran 100 PostgreSQL, MS SQL, BigQuery warehouses

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 and ran 6 ETL/ELT pipelines

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.

### Made a geographical data pipeline 50x faster

Recorded a 50x geographical data‑pipeline improvement in the founder’s Utiligize work through SQL and data‑model changes across PostgreSQL, MS SQL and Google Cloud BigQuery.

## Seeing what is going on

Data & Databases

Data Analytics & BI Dashboards

Dashboards and reports showing the handful of figures a decision actually turns on, refreshed without being asked.

### Built first‑party analytics inside PostgreSQL

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.

### Designed a time‑management and reporting system

Designed a time‑management and reporting system that remained in production use for years without significant modification.

### Delivered analysis and regular progress reports

Delivered analysis and regular progress reports to the CEO, translating engineering KPIs and delivery status into decisions.

See all 11 achievements

## Trusting the numbers

Data & Databases

Data Governance & Quality

Rules and checks that catch bad data on the way in, and a clear answer to who owns which figure and where it came from.

### Measured 13 addresses with no tracking

Measured thirteen addresses from the web server's own access log alone — no cookie, no tracker and no third‑party service — masking the client network as each line is written, and folding the result into a permanent archive of 21 daily counts and 20 monthly facets.

### Know the licence of everything you ship

Audited 644 Rust crates for licence compatibility on every build, and proved the check fires by rewriting one crate's licence and by moving the pinned core revision without regenerating.

### Built a cross‑language figure check

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.

See all 16 achievements

## Data an AI can actually use

Data & Databases

AI Data Readiness

Your records where AI agents can reach them, one version of each customer, nobody shown more than they should, and every answer traced to its source.

### Replaced 963 metadata blocks with one graph

Replaced 963 anonymous structured‑data blocks that restated the company 1,671 times with one linked graph of 16 types minted from stable origin identifiers.

### Generated 495 pages from a SQLite export

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.

### 1,022 migrations behind a schema drift gate

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.

See all 6 achievements

## We work with the platforms your business already runs on.

Apple · Microsoft · DigitalOcean · AWS · Google

See the whole stack

## Company data your AI agents can answer from

### Gathered

Your CRM, ERP, shared drives and mail archives brought into one database an agent reaches through one described door.

### Cleaned

Agreed identifiers and quality checks connect the selected data sources, with duplicate handling and validation rules documented.

### Permissioned

Access checks and audit logging follow the permissions and data boundaries agreed for the integration.

See the data work

Ask about your data

## Tell us what you are building.

No form, no funnel, no sales sequence — just one e-mail to a person who will read it.

Start the conversation

This address shows the data work only. The company also builds software, runs infrastructure and advises teams — that side of it is at engineer.company.

See everything Engineer ApS does

## Begin with a focused improvement

A workflow, a data flow or a system that needs improvement can be a useful first task. We can agree its scope together.

See what it costs

Get in touch

## Plan the first conversation

Tell us the result you need, what is already in place and when you need it. We can use that to discuss the next step.

Explore our services

welcome@engineer.company

+45 50 10 61 84

Copenhagen, Denmark

## Photographs

Apple, macbook, keyboard

Photo: JaimePLopes / Pixabay

Hands using a laptop keyboard

Photo: StartupStockPhotos / Pixabay

## On the server, we work with open-source Linux — no licences to pay for, and nothing hidden.

Ubuntu · Debian

How we run servers

Carefully Crafted With Love by D.

=> /#home-focus-heading What we do
=> /portfolio/ See our work
=> tel:+4550106184 +45 50 10 61 84
=> https://maps.apple.com/?address=Copenhagen,%20Denmark&auid=14740132918557855751&ll=55.662352,12.615932&lsp=6489&q=Copenhagen&t=m Copenhagen, Denmark
=> /services/ Explore our services
=> /portfolio/ Database and pipeline work
=> /what-it-costs/ Pricing and engagement options
=> /contact/ Discuss your project
=> https://data.engineer.company/images/photo/pages/6105750.3d66b0c0cfdfd2905f41591d62b1f67a054917ab9cf4c05c578ae45e5fa7dc51.webp Keyboard, computer, laptop
=> https://data.engineer.company/images/photo/pages/4571732.28264031e0b0424a562dafd4d95a379c409530ef8fe3e283ce12da397f2842f4.webp Keyboard, hand, typing
=> /services/ Explore our services
=> /contact/ Get in touch
=> /cases/ Cases
=> /contact/ Get in touch
=> /portfolio/a-maritime-platform-built-in-clean-layers/ Read the case study
=> /portfolio/one-infrastructure-plan-for-14-departments/ Read the case study
=> /portfolio/a-month-of-meter-readings-in-180-milliseconds/ Read the case study
=> /portfolio/a-mapping-product-carried-end-to-end/ Read the case study
=> /portfolio/a-month-of-meter-readings-in-180-milliseconds/ 180 ms to aggregate a month of meter readings
=> /portfolio/made-a-geographical-data-pipeline-50x-faster/ 50x faster geographical data pipelines
=> /portfolio/engineered-600-pl-pgsql-etl-elt-pipelines/ 600 ETL pipelines engineered in PL/pgSQL
=> /portfolio/wrote-1000-rbac-rules-to-secure-linux-servers/ 1,000 access rules written to close a security gap
=> /portfolio/built-the-hiring-and-seafarer-career-workspaces/ 151 stored functions behind hiring and career
=> /portfolio/ See the whole catalogue
=> /services/ Browse the catalogue
=> /portfolio/built-a-database-driven-cv-generator/ Built a database‑driven CV generator
=> /portfolio/built-the-hiring-and-seafarer-career-workspaces/ Built the hiring and seafarer career workspaces
=> /portfolio/built-a-loyalty-wallet-leagues-and-badges/ Built a loyalty wallet, leagues and badges
=> /services/database-design/ See all 14 achievements
=> /portfolio/1022-migrations-behind-a-schema-drift-gate/ 1,022 migrations behind a schema drift gate
=> /portfolio/implemented-backups-and-disaster-recovery-as-code/ Implemented backups and disaster recovery as code
=> /portfolio/engineered-600-pl-pgsql-etl-elt-pipelines/ Engineered 600 PL/pgSQL ETL/ELT pipelines
=> /services/database-administration/ See all 9 achievements
=> /portfolio/quicker-answers-from-a-better-choice-of-key/ Time‑ordered keys for a growing data model
=> /portfolio/accelerated-postgresql-performance-by-10x/ Accelerated PostgreSQL performance by 10x
=> /portfolio/ran-100-postgresql-ms-sql-bigquery-warehouses/ Ran 100 PostgreSQL, MS SQL, BigQuery warehouses
=> /services/database-performance/ See all 6 achievements
=> /portfolio/moved-every-string-into-a-content-tree/ Moved every string into a content tree
=> /portfolio/1022-migrations-behind-a-schema-drift-gate/ 1,022 migrations behind a schema drift gate
=> /portfolio/improved-gis-map-performance-10x-on-postgresql/ Improved GIS map performance 10x on PostgreSQL
=> /portfolio/generated-495-pages-from-a-sqlite-export/ Generated 495 pages from a SQLite export
=> /portfolio/built-first-party-analytics-inside-postgresql/ Built first‑party analytics inside PostgreSQL
=> /portfolio/a-mapping-product-carried-end-to-end/ A mapping product, carried end to end
=> /services/data-pipeline-development/ See all 14 achievements
=> /portfolio/ran-100-postgresql-ms-sql-bigquery-warehouses/ Ran 100 PostgreSQL, MS SQL, BigQuery warehouses
=> /portfolio/designed-and-ran-6-etl-elt-pipelines/ Designed and ran 6 ETL/ELT pipelines
=> /portfolio/made-a-geographical-data-pipeline-50x-faster/ Made a geographical data pipeline 50x faster
=> /portfolio/built-first-party-analytics-inside-postgresql/ Built first‑party analytics inside PostgreSQL
=> /portfolio/designed-a-time-management-and-reporting-system/ Designed a time‑management and reporting system
=> /portfolio/delivered-analysis-and-regular-progress-reports/ Delivered analysis and regular progress reports
=> /services/data-analytics-bi/ See all 11 achievements
=> /portfolio/measured-13-addresses-with-no-tracking/ Measured 13 addresses with no tracking
=> /portfolio/know-the-licence-of-everything-you-ship/ Know the licence of everything you ship
=> /portfolio/built-a-cross-language-figure-check/ Built a cross‑language figure check
=> /services/data-governance/ See all 16 achievements
=> /portfolio/replaced-963-metadata-blocks-with-one-graph/ Replaced 963 metadata blocks with one graph
=> /portfolio/generated-495-pages-from-a-sqlite-export/ Generated 495 pages from a SQLite export
=> /portfolio/1022-migrations-behind-a-schema-drift-gate/ 1,022 migrations behind a schema drift gate
=> /services/ai-data/ See all 6 achievements
=> /tech-stack/ See the whole stack
=> /ai-data/ See the data work
=> /contact/ Ask about your data
=> /contact/ Start the conversation
=> https://engineer.company/ See everything Engineer ApS does
=> /what-it-costs/ See what it costs
=> /contact/ Get in touch
=> /services/ Explore our services
=> mailto:welcome@engineer.company welcome@engineer.company
=> tel:+4550106184 +45 50 10 61 84
=> https://maps.apple.com/?address=Copenhagen,%20Denmark&auid=14740132918557855751&ll=55.662352,12.615932&lsp=6489&q=Copenhagen&t=m Copenhagen, Denmark
=> https://data.engineer.company/images/photo/pages/4168369.b2415c199ead8f82889e8aab9fa6bfc87118c5cc99d6aaeed02b71f70f71e545.webp Apple, macbook, keyboard
=> https://data.engineer.company/images/photo/pages/849828.bcdb02c7e642962d6e14b002fc9ea33e818629a2912681f6329c9ab4793dff98.webp Hands using a laptop keyboard
=> /services/system-administration/ How we run servers

## Menu

=> /services/ Services
=> /cases/ Cases
=> /what-it-costs/ What it costs
=> /contact/ Contact
=> /why-choose-us/ Why choose us
=> /portfolio/ Portfolio
=> /tech-stack/ Tech stack
=> /terms/ Terms
=> /service-levels/ Service levels
=> /ai-ready/ Agent-ready site
=> /ai-data/ Company data
=> /ai-agents/ Custom agents
=> /ai-security/ Agent security
=> /ai-tools/ Software as tools
=> /notes/ Blog
=> /testimonials/ Testimonials
=> /about/ About us
=> /legal/ Company details
=> /ethics/ Ethics
=> /security/ Security
=> /data-processing/ Data processing
=> /careers/ Careers
=> /categories/ Categories
=> /sitemap/ Sitemap

=> /llms.txt llms.txt
=> /sitemap.xml sitemap.xml
=> https://data.engineer.company/ This page on the web
