Nicolas De Revière

DBA EXPERT DB2 mainframe ( Z15 Z/os 2.4 and DB2 V12 ), DB2 for LUW linux/Windows ( V11.5 ), SQL SERVER 2004->2019 , mysql 5.7 and 8)

- Responsible for production, development, acceptance and training environments
- Initial implementation and administration of the datawarehouse server (udb 11.5 / linux)
- Administration, performance optimization, tuning, upgrade of DB2s
- Implementation of backup/archiving policies
- Creation/Maintenance of automation procedures: BASH, REXX, PERL, JCL
- Use of monitoring tools MVS, DB2, OMEGAMON, DB2 QUERY MONITOR, GLOWROOT
- Implementation of distributed DDF and WLM and native stored procedures
- Collaboration with the Release Manager for the creation of the document - Production Launch (IMAJ Project)
- Refinement of DB2 migrations performed by external personnel
- Affinities/collaboration for the pure systems part

Environment:
IBM mainframe Z15 Z/os 2.4 and DB2 Z/os V12 ), DB2 for LUW linux/Windows ( V11.5 ), SQL SERVER 2004 -> 2019 , mysql 5.7 and 8.
WINDOWS, LINUX, VMWARE, BASH, PERL, DDL , SQL, PL-SQL, REXX, JCL, OMEGAMON DB2, DB2 QUERY MONITOR, GLOWROOT, MANTIS, SERVICENOW, IBM Data Studio, DBEAVER ,

AXIALOG Benelux – IT consultant (Belgium) Common

points to the different missions:
- Risk analysis, taking into account the technical and functional particularities of the sites
- Support and knowledge transfer to the teams in place
- Comprehensive and detailed documentation delivery

03/2005 - 08/2005 - PARTNERSHIP

- Implementation of SP infrastructure under WLM
- SP development in COBOL
Environment: OS 390, MVS, DB2, COBOL, SQL, REXX (mainframe), JCL

01/2005 - 02/2005 - MOVITEX, PPR Group - Consulting / Audit DB2

Impact analysis IRIS3 integration (Vert Baudet data)
- Definition of the scope of the intervention, limitation of the analysis to critical objects
- Study of the impact of the volume increase (+50%) on performance
overall production
- Recommendation of partitioning on objects that are not already partitioned, study of the
benefit by activating parallelism
- Non-regression study of existing accesses and processing times
- DB2 tuning, system part
Environment: OS 390, MVS, DB2, COBOL, SQL, REXX (mainframe + NT), JCL, OPC, mainview, DB analyser

09/2004 - 12/2004 - AXA TECH Belgium - MVS Consultancy

Projects: MAINFRAME AUDIT, PEI project (project environment improvement),REBEL, BMC UNLOAD + replacement

- Development of new features in Magnetic Insex (JCL generator)
specific to AXA)
- Implementation of stored procedures using WLM, monitoring of RRS and WLM installation, implementation of monitoring of stored procedures
- Feasibility study, replacement of BMC UNLOAD+ by basic standard unload delivered with DB2 V7
- Impact study: regression on functionalities, takeover of the existing

Environment: OS 390, MVS, DB2, COBOL, SQL, REXX (mainframe + NT), JCL, OPC, OPC Tracker, SMTP mainframe, Insex Magnétique (AXA specific JCL generator), SUN server under UNIX (REBEL project)

05/2004 - 08/2004 - TIXIS TECHNOLOGIES ARCELOR group, DUNKIRK

DB2 V6 to V7 migration across all sites
(27 DB2 in total, 8 of which are accessed by SAP)

- SAP hook check, use of stored procedures with V7
- Verification of performance degradations, verification of functionalities and related products
- Assistance of the teams in place of TIXIS TECHNOLOGIES and TIXIS SYSTEMS in the actions to be carried out following the technical analyses carried out
Environment: OS 390, MVS, DB2, COBOL, SQL, REXX, JCL. + monitoring tools (OMEGAMON, BMC, MAINVIEW)

10/2003 - 04/2004 - AXA TECH Belgium - Projet PEI (project environment improvement)

Block 1: ISPF improvement
Block 2: Promotion Procedures (replacing the current mainframe item promotion pathway)
Environment: OS 390, MVS, DB2, COBOL, SQL, REXX (mainframe + NT), JCL, OPC, OPC Tracker, FTP mainframe, PKZIP mainframe, Insex Magnetic (AXA-specific JCL generator)

03 to 09/2003 - TIXIS TECHNOLOGIES ARCELOR group, DUNKIRK

DB2 V5 to V6 migration on the COCKERILL-SAMBRE site, development environments, infocentre and production

- Verification of non-degradation of performance
- Verification of related functionalities and products (present on the scores)
- Assistance of the teams in place of TIXIS TECHNOLOGIES and TIXIS SYSTEMS in the actions to be carried out following the technical analyses carried out
Environment: OS 390, MVS, DB2, COBOL, SQL, REXX, JCL. + monitoring tools (OMEGAMON, BMC: MAINVIEW)

04/2000 - 03/2003 - AXA Belgium - Senior DBA

- Responsibility for the DATABASE environment for Development and STAGING
- Design support for development
- DB2s administration, optimization, tuning
- Installing, updating, and managing environments
- Improvement and creation of automated procedures
- Performance optimization and application tuning (Explain, among others)
- Development of logical and physical interfaces
- Implementation of distributed DDF and stored procedures
- Implementation of CIIS DATA SERVER (IBM), batch and stored procedures
Environment: OS 390, MVS, DB2, COBOL, SQL, REXX, JCL. + monitoring tools (OMEGAMON, BMC, DB2 PM, STROBE) + AXA architecture tools

1996 – 03/2000 - Senior DBA in Production and Development

System / Operation / Design - Responsibility for the DATABASE environment of production and development
- DB2s administration, optimization, tuning
- Installation and management of environments
- Performing automated procedures
- Performance optimization and application tuning (Explain, among others)
- Development of logical and physical interfacesEnvironment: OS 390, MVS, DB2, COBOL, SQL, REXX, JCL. + monitoring tools (OMEGAMON, BMC, DB2 PM)

1994 – 1996 - Technical Architect

- Mainframe application development (static and dynamic programming)
- Application development in Client Server and Voice Server
- Management of an infocentre
Environment: OS 390, OS2, TERRADATA RDBC, FOCUS, QMF, SPUFFI, COBOL, SQL, UNIX

1991 - 1994 - Analyst – Programmer
Service Carte Vitale
- Technical Analysis and Telematics Development
- Batch and TP development in relational DBMS environment
Environment: MVS / TSO, DOS VSE / CMS, CICS, DB2, COBOL, SQL

BAC C - mathématiques physique ( france )