Open to opportunities

Frederic KAPP

@frederickapp

Message

I migrate and optimize critical banking databases across SQL Server, PostgreSQL, DB2, and Oracle.

Switzerland

Message

What I'm looking for

I'm looking to contribute to critical database migration, data integration, and production environments, particularly in French-speaking Switzerland around Lausanne and Geneva. I'm available at short notice and willing to provide on-call support.

I've supported critical banking and finance data platforms at Azqore, Centrale de Compensation, HSBC Switzerland, and Société Générale, improving database performance, migration reliability, and operational visibility.

At Azqore, I implemented automated performance reporting, optimized SQL Server and DB2 processing, developed automation scripts, and strengthened monitoring, operational indicators, and process standardisation. At Centrale de Compensation, I contributed to a strategic DB2-to-PostgreSQL migration, automating data flows and controls while improving data quality, traceability, and platform security.

Across production, BI, and client-reporting environments, I've administered and supported DB2, PostgreSQL, SQL Server, Oracle, and other databases; delivered L2/L3 support; managed backup, restore, patching, HA/DR, and cutovers; and built Bash, PowerShell, Perl, and SQL automation.

With 20 years of experience, I bring rigorous, practical support to complex data environments and work closely with data, development, and operations teams.

Experience

Work history, roles, and key accomplishments

Senior Database & Data Integration Engineer

Azqore

Jan 2022 - Jan 2025 (3 years)

Implemented automated performance reports and optimized SQL Server and DB2 databases. Developed automation scripts and contributed to operational process structuring.

SQL Server PostgreSQL PowerShell BASH Ansible Automation Performance Optimization Monitoring

Database Migration & Data Integration Engineer

Centrale de Compensation

Jan 2019 - Jan 2022 (3 years)

Contributed to a strategic DB2 to PostgreSQL migration project, building a reliable and industrialised data environment. Automated data flows and control processes.

PostgreSQL Data Migration Data Integration Automation Performance Optimization Documentation

Database & Data Integration Engineer

GEODIS

Jan 2016 - Jan 2018 (2 years)

Administered and optimized application platforms and databases in production for multiple projects. Delivered L2/L3 support, SQL performance analysis, and incident resolution.

SQL Server Oracle PostgreSQL BASH SQL Incident Management

Database Engineer / Technical Consultant

IBM

Jan 2015 - Dec 2015 (11 months)

Audited DB and SQL performance on DB2, SQL Server, and Oracle databases. Managed outsourced databases for multiple clients and automated backups and monitoring.

SQL Server Oracle Perl PowerShell Automation ITIL

Database Engineer

Canton de Vaud

Jan 2014 - Dec 2014 (11 months)

Consultant and database administrator for a BI project, automating backups and environment synchronization. Drafted operating documentation and provided support.

SQL Pl SQL Unix Linux Automation Documentation

SQL Server / BI Data Operations Engineer

BVA

Jan 2014 - Dec 2014 (11 months)

Integrated and consolidated survey data from heterogeneous sources, developing financial and statistical analysis processing. Handled data loading and automation.

SQL Server SSIS Data Integration ETL Automation Data Analysis

BI Data Operations Engineer

TCS

Jan 2013 - Dec 2013 (11 months)

Senior IT and database specialist automating SQL Server / SSIS environments. Provided DW/BI support to development and SAP teams.

SQL Server SSIS BIツール Automation Documentation

Data Integration & Reporting Engineer

BVA

Jan 2012 - Jan 2013 (1 year)

Integrated survey data from multiple sources and developed processing for financial and statistical purposes. Transformed heterogeneous data into analysis-ready datasets.

Data Integration ETL SQL Data Analysis Reporting

Database & Datawarehouse Engineer

HSBC

Jan 2010 - Jan 2012 (2 years)

Contributed to the implementation of a 5 TB data warehouse for Client Reporting and Liquidity Management. Administered and operated more than 50 databases.

SQL Server SSIS Informatica DataStage Data Warehouse Automation

Database Consultant

DELTA DB

Jan 2002 - Jan 2010 (8 years)

Implemented, automated, and supported development, integration, and production teams on OLTP and BI environments. Delivered DB2 training and expert audits.

SQL Server Oracle Data Integration Automation Training

Database Developer / Data Integration Consultant

INFOSPHERE

Jan 2000 - Jan 2002 (2 years)

Installed and created Oracle environments for Michelin, developing in Visual Basic and SQL Server. Optimized processing performance and SQL queries.

Oracle SQL Server Visual Basic Shell Scripting

Database Administrator and Developer

SATIS

Jan 2000 - Dec 2000 (11 months)

Built shell scripts and automated Windows environments, managing client-server connectivity. Developed in Java and Visual Basic, administering SQL Server and Oracle.

SQL Server Oracle Java Visual Basic Shell Scripting Automation