Alain - DBA DB2

EXPERIENCE

Database Business Partners
Software company : click4DB
2016-present
Co-Founder
Analysis, design and conception of a DB2 managing Tool Click4db in 2016 .
Using DB2 V10, V11, V12 for tools development.

2019 Study of a new JAVA web architecture to replace a COBOL/CICS architecture in a Luxembourg
Bank.
Review migration and maintenance DB2 Process at a Mainframe Hosting Company.
2018 SQL Training at AXA tech France
- DB2 Datasharing concept
2017 SQL Training at Delen BANK Luxembourg
- DB2 SQL Workshop
- DB2 SQL Workshop for Experienced Users

BELFIUS BANK
Since June 2020
25 DB2 with and without Datasharing.
Audit ZPARM Values
Evaluate Ziip configuration.
Implement DB2 V12 new features

NRB
Since May 2019 :
Management of 21 DB2 .
 Smp Management
 Migration process
 Maintenance Activation.
Performance Follow-up
V12 migration process

ETNIC
Governmental organization, DB2 for z/OS expert (part time)
2012 - August 2020
Migration DB2 z/OS v9 => DB2 z/OS V10
Mgration DB2 z/OS V10 => DB2 z/OS V11
Migration DB2 z/OS V11 => DB2 z/OS V12 LEVEL 100 done
Activation of DB2 V12 LEVEL500 since June 2019.
System management
Sql Tuning (since 2012 no MSU increase despite 50 % of SQL increase)
Omegamon report generation

Database Business Partners
Software company : click4DB
2016-present
Co-Founder
Analysis, design and conception of a DB2 managing Tool Click4db in 2016 and start sale process in 2017.

SQL Training at Delen BANK Luxembourg
- DB2 SQL Workshop
- DB2 SQL Workshop for Experienced Users


ETNIC
Governmental organization, DB2 for z/OS expert (part time)
2012 - present

Migration DB2 z/OS v9 => DB2 z/OS V10
Migration DB2 z/OS V10 => DB2 z/OS V11
System management
Sql Tuning (since 2012 no MSU increase despite 50 % of SQL increase)

IS4F (ex-Dexia)
Bank & insurance sector, DB2 Architect – System Engineer – DBA
1986 – 2015
Db2 Architect.
Infrastructure project.
Environment normalization between customers
DB2 System engineer
Migration of subsystem (from db2 V6 to v11)
Db2 tools management (IBM, CA, Cares, OMEGAMON, TMON)
Datasharing implementation.
New utility management implementation( java SP on z/OS)
35 subsystems (6 X 3 ways datasharing group)
Duty 24/7 management.
DB2 DBA
Performance specialist.
Database management ( ddl , deployement)
Bank and assurance application