Freelancer profile translated to English.

Description

For 25 years, I have been involved in the technical aspects of databases and DWH (Postgres and Oracle).

I graduated in WO-mathematics (numerical models and meteorology).

I have particular expertise in troubleshooting, monitoring data quality,

and testing ELT and DWH.

I am also well-acquainted with database and DWH related matters, such as BI/reporting,

backend programming, scripting, coding, testing, web applications, OTAP, etc.

My strengths are quickly understanding databases and software, combined with patience and a puzzle mentality. I enjoy learning and learn quickly, am creative in devising solutions, work with good documentation, and have experience with large projects in a team setting.

analytical * structured * communicative * independent * accurate *

Languages

Dutch
Native or bilingual
German
Native or bilingual

Workplace preferences

Can work on-site

Utrecht (up to 50km)

IV
PostgreSQL - developer and DBA
ENERGY AND UTILITIES
February 2024 - Today (2 years and 4 months)
migration of 160 project databases to a new database;
scripts in PostgreSQL; setup of tables, data migration; design of views, triggers, audit logging, functions, sequences, keys, indexes, etc.; introduction of XML, Json; preparation of migration plan and documentation;
PostgreSQL
dbHeroes
Data engineer / database developer / QA
MEDICAL
December 2021 - Today (4 years and 6 months)
Arnhem, Netherlands
Monitoring data quality in the ETL flow from source to DWH (CoronIT), troubleshooting, fixing bugs; internal supervision of the ETL flow; testing new components;
Postgres SQL PostgreSQL DWH Pentaho ETL Jira Git Agile Scrum
TenneT
Data engineer / DevOp
ENERGY AND UTILITIES
October 2019 - October 2021 (2 years and 1 month)
Arnhem, Netherlands
Oracle-plsql application for automated exchange of data on the European power market;
receiving XMLs, stripping and storing data;
looking up data, packaging in XMLs and sending;
Troubleshooting;
Oracle PL/SQL SQL XML Big Data Jira Git Git-SVN Agile Scrum