English Swedish
profile

Vaclav Kozak

Flustrated Oracle Database Expert

Stockholm, Sweden

Contact me:


Unhappy flustrated with my current job as a Lead Data Engineer, I am looking for a change to do something around CAD/CAM.
db
From this (SQL/NOSQL)
arrow
to
cad
this (CAD/CAM)

The Story

Education

Oracle to SolidWorks self-education

Courses

Re-watching videos

Available gears

Hardware

Software

Certifications

AWS Certified Developer – Associate
MongoDB Certified Developer Associate
MongoDB Certified DBA Associate
Oracle Advanced PL/SQL Professional
Oracle 11g SQL Tuning Expert
Oracle 12c Administrator Associate
Oracle SQL Certified Expert

Experience

Year Role Company Info
current Lead Data Engineer FDJ More
Feb 2019 – Jan 2023 Senior Data Engineer Kindred Group More
Aug 2016 – Jan 2019 Oracle Developer Unibet Group More
Mar 2014 – Jun 2016 Oracle Developer Home Credit International More
Mar 2012 – Jul 2013 Oracle Developer Raiffeisenbank a.s. More
Feb 2008 – Feb 2012 Oracle Developer O2 Czech Republic More


FDJ – Lead Data Engineer (current)

Maintaining and evolving the Data Warehouse while transitioning batch processing to streaming and near real-time architectures. Investigating AWS cloud migration including Redshift, S3 and Redshift Spectrum with focus on performance and cost optimization. Evaluating ETL services (mainly AWS Glue) to process heterogeneous provider data formats such as JSON, XML and CSV and preparing the DWH architecture for cloud migration.

Kindred Group – Data Engineer (Feb 2019 – Jan 2023)

Maintaining and evolving the Data Warehouse while transitioning batch processing to streaming and near real-time architectures. Investigating AWS cloud migration including Redshift, S3 and Redshift Spectrum with focus on performance and cost optimization. Evaluating ETL services (mainly AWS Glue) to process heterogeneous provider data formats such as JSON, XML and CSV and preparing the DWH architecture for cloud migration.

Unibet Group – Oracle Developer (Aug 2016 – Jan 2019)

Data Warehouse ETL developer responsible for integrations and BI data delivery. Worked in Partnership and Communication streams handling provider integrations (financial transactions, gaming data, surveys, session data). Implemented ETL pipelines using Oracle external tables, shell scripts, XML/JSON APIs via UTL_HTTP and DB links. Participated in Oracle upgrade from 11.2 to 12.1c on RAC environment (5–10 nodes, ~65 TB database, ~650 GB SGA).

Home Credit International – Oracle Developer (Mar 2014 – Jun 2016)

PL/SQL developer for accounting platform “BOOK”. System architecture contained Loading, Stage and Accounting layers. Data ingestion implemented via materialized views and INSERT ALL from two core systems. Designed accounting transformations fully inside Oracle (11.2g → 12.1c) with Java GUI frontend (Wicket). Focus on building configurable product deployable across countries with different accounting standards. Database sizes ranged from 200 MB to 4 TB.

Raiffeisenbank a.s. – Oracle Developer (Mar 2012 – Jul 2013)

Data Migration developer for core banking migration project (Everest). Developed PL/SQL mappings and tuning for internal Data Migration Tool. Pipeline moved data from ~17 systems via Informatica into Oracle stage layers (0–3) and then into Finacle via DB links or files. Migration scope ~16 TB per run, ~600 tables, ~40,000 columns. Tables partitioned by migration run with SYS_CONTEXT-based views and subpartitioning per procedure.

O2 Czech Republic – Oracle Developer (Feb 2008 – Feb 2012)

Developed monitoring and configuration system for Oracle Streams replication between production (Siebel) and ODS. Application implemented with JSP, JavaScript and PL/SQL backend. Later built order-flow monitoring and SLA reporting system integrating ~20 source systems with automated stage refresh engine using dynamic PL/SQL, scheduler jobs, DB links and partition management.

Skills

Personal Interests

Project