Franck JOLIMAY
Sillingy
Profil professionnel
Senior Database Administrator with 9+ years of experience in managing and optimizing SQL Server, Oracle, and mySQL databases. Proficient in SQL, PL/SQL, and T-SQL for data manipulation and analysis. Expertise in high-availability, replication, and clustering. Experienced in database migrations and implementing backup and recovery strategies. Recognized for analytical skills, problem-solving abilities, and commitment to data availability and integrity.
Vue d'ensemble
41
41
years of professional experience
1988
1988
years of post-secondary education
Expérience
Oracle DBA
Conduent
Valence
2025.01 - 2025.12
- Within the Technical Engineering department, I participate in ticketing projects (France and International (Melbourn project with 1 billion of budget on azure and OCI) as a resource for the IT Infrastructure team. I builded with oracle and external consultants the 7 different environments on OCI/azure Melbourne project.
- As an Oracle expert, I conducted interviews to define/update best practices in development (queries, providers, pool management, etc.) and support developers in their implementation. I provided support to project teams for analyzing bottlenecks and propose solutions.
- Installation and administration (10 years of experience as an Oracle database administrator, including installation, administration, operational maintenance, troubleshooting, and optimization proposals, within a high-availability, virtualized environment)
- Defining and updating best practices for Oracle database installation and sizing
- Defining and updating best practices for development (optimizing and classifying queries from the development stage, organizing objects efficiently, managing connection pools, and adapting to existing providers) and assisting developers with implementation
- Providing support to project teams for diagnosing ticketing system failures and implementing remediation solutions
- Providing support to preliminary project teams for the analysis, design, and cost estimation of the server infrastructure (database resources) supporting the ticketing system, with a focus on optimizing the ratio cost/performance.
- Conduent is a leader in ticketing for public transport and deploys complex systems worldwide.
App support & Dev & SQL Server DBA
LEM SA
Geneva
2017.09 - 2024.01
- Manage all Business DataBases of LEM Worldwide: 30 SQLSERVER 2017 DB - from 5 GB to 2TB data size, 2 Oracle 19c DB - 2GB DataSize, 65 Progress V8 DB - 100 GB DataSize
- Infrastructure Application support of following applications: Dynamics 365 – New Microsoft ERP environment to replace our WW QAD ERP, Management of 5 Dynamics Environments, MFILE – LEM Electronic Documents Management, Manage the SQL SERVER Databases of the PROD and TEST systems containing each 2 millions documents of 2 TB data size, NICELABEL – World Wide labels management, Automate label generation and printing on mainly Zebra and HP printers, Integrate NiceLabel solution into Microsoft Dynamics 365 for managing label printing.
- Esker On Demand – Electronic invoicing on external Cloud, Manage provider’s invoices on Esker Cloud from 2 windows servers interfaced with our QAD Prod system
- QAD – Linux ERP software currently used in all LEM WW. Manage our 13 Progress Prod Databases used by QAD (backup, maintenance, perf optimizations) and the QAD prod server. Manage the linux QAD rollback server and his 13 Progress databases. Manage the 4 linux tests environments (soft + databases) used by QAD. Manage the linux QAD DWH server and rollback server
- Mammut – Central e-banking platform, Manage the 2 windows servers and SQL Server Databases used by this finance application
- Sumtotal – HR application, Manage the 12 windows servers and 4 SQL SERVER Databases used by the PROD and TEST systems.
- HERMES – Developed application for Quality insurance of prod of elect devices, Design, Develop and Deploy a C# application to duplicate in realtime 50 SQLSERVER databases maximum from testers to a central regional Database (3 Regions: Asia, Europe and Switzerland), as the standard SQLSERVER duplicate solutions was not functioning right above 5 replications. Manage the 3 regional Microsoft servers with installation of SQLSERVER databases (installation, backup, archival, perf optimizations, partitioning), databases of multiple TB of production data. Installation of testers with the C# application. Installation of the main GUI of the application on regional server developed internally in PHP and using tomcat.
- Electronic badge system, Put in place an SQLSERVER database to centralized all Production area doors protect by badge access.
- LEM SA – Electrical measurement solutions – around 15 countries, 1500 people
Applications support & development
SWISS RISK & CARE
Geneva
2014.02 - 2017.05
- Level 2 support of absences & Claims UNIPRO application (20 administrators, 40 corporate clients)
- Reduce by 50% the support tasks in 1 year by automating data import processes (PowerShell, shell scripts, oracle PL/SQL)
- Installation, configuration and management of an openssh server for the exchanges with our 40 corporate clients (Linux Red Hat enterprise 7.0, openssh)
- Development of a support dynamic web application (Java7, tomcat8.0, jsp, jsf2.0, Oracle12c database).
- Level 2 and level 3 support of Asylum seekers GRA application (2 million of invoices, 30 administrators, 10 corporate clients)
- Bugs fix Maintenance developments (110 fixes developed per year)
- Evolution developments (access VB6.0, C#, .NET, 7 SQL SERVER 2008 Databases)
- Example: automate generation of all kind of dynamic letters (word templates fills automatically depending on the application context) (UI software)
- Monthly tasks (closing to generate premium) (closing software)
- Annual tasks (annual closure and generation of covers)
- Automate the flows of invoices through specialised providers (CuraX, Medidata) from Swissrisk & care to/from insurances and to/from Healthcare providers. (routing invoices software)
- SWISS RISK & CARE – Swiss Insurance broker
Oracle/SQL server DBA, Solaris Admin
THOMSON REUTERS
Geneva
2010.07 - 2013.09
- Senior Oracle DBA in the EMT I&S (European Middle Tiers Implementation and Support) team with an HA infrastructure of 800 servers for 15000 customers (financial companies). The team was composed of 10 persons with 2 DBAs:
- Manage the 24 oracle11g Enterprise Databases that were used by RT (Reuters trader), RWM (Reuters Wealth Manager) and RI (Reuters Investor) Products (100 GB databases).
- Support of Service Alert and CRM applications (120 machines) and manage their Databases (12 oracle11g Databases in Dataguard config) - (50 GB Databases)
- Installation, tuning, monitoring, reporting scripting, Incident support and solving, performance analyses, upgrades, patching, cloning, moving, backup, restore, exports, imports, documentation.
- Implementation of an Enterprise backup solution with Tivoli Storage Manager and oracle module (TDPO), EMC VMAX and RMAN in order to backup all Oracle Databases.
- Main implementer of the SQL server databases (5 replicated databases on 3 continents) for the Eikon product.
- Define and implement a new HA email solution to send alerts for Service Alert product, with virtualization (4 solaris 10 zones, Firewalls, CSS, vips, dns, and sendmail software).
- Create multiple scripts in ksh and perl for administration, monitoring and reporting.
- Manage the 5 veritas clusters (ftp and nfs) of the EMT platform (10 machines V240 sol10) Installation, configuration, upgrade, monitoring, incident support and solving, training the team for the support, documentation.
- Support of some EMT java agents (kalends, powersearch, occm, sampling, alerting) – (migration of 26 machines V240 to one T4 solaris 10).
- As Change manager of the team (for ITIL processes) using HP service manager 7, participate to the weekly change management meeting with other teams to analyze impact of changes on our team.
- As team deputy replace the team leader during his holidays in some Service Forum, Incidents meetings.
- THOMSON REUTERS – CANADIAN Financial information provider
Oracle DBA, Solaris Admin
THOMSON REUTERS
Geneva
2004.04 - 2010.07
- Manage the 24 oracle9i Enterprise Databases that were used by RT (Reuters trader), RWM (Reuters Wealth Manager) and RI (Reuters Investor) Products (100 GB databases).
- Support of Service Alert and CRM applications (120 machines) and manage their Databases (12 oracle9i Databases in Dataguard config) - (50 GB Databases)
- Installation, tuning, monitoring, reporting scripting, Incident support and solving, performance analyses, upgrades, patching, cloning, moving, backup, restore, exports, imports, documentation.
- Installation and test of an oracle10g RAC configuration to replace the ldaps of the platform.
- Create multiple scripts in ksh and perl for administration, monitoring and reporting.
- Manage the 5 veritas clusters (ftp and nfs) of the EMT platform (10 machines V240 sol8) Installation, configuration, upgrade, monitoring, incident support and solving, training the team for the support, documentation.
- Support of some EMT java agents (kalends, powersearch, occm, sampling, alerting) – (26 machines V240 solaris 8).
- As Change manager of the team (for ITIL processes) using HP service manager 7, participate to the weekly change management meeting with other teams to analyze impact of changes on our team.
- THOMSON REUTERS – CANADIAN Financial information provider
Oracle DBA, Unix admin
REALMEDIA
Lausanne
2000.09 - 2004.03
- Manage the Solaris and Linux UNIX production systems enabling the delivery of one billion of advertising banners per month.
- Manage as DBA the 4 Databases, 2 Oracle8i (600 GB DB) and 2 MySql3.22.27.
- Manage backup, performance tuning, systems installation, security of 20 linux systems.
- Define and implement the backup strategy (RAID SCSI).
- Define future Fiber SAN strategy.
- Installation of opensource products like mysql and apache.
- Maintenance and support of RealMedia products.
- REALMEDIA – USA Online Internet advertising Company
Progress DBA, Developer
LOGICA
Grenoble
1996.09 - 2000.08
- Mission for HEWLETT-PACKARD in Grenoble during 3.5 years: 1.5 year supporting after-sales of printers (DBA ProgressV6, manage Development environment, put into production, follow-up the production plan, and manage the sub-contractors contacts)
- 1 year of web software development (Site of e-business for Microsoft in Icl language)
- 1 year in software Development (EDI router in C and PRO
- C with access to an Oracle 7.3 Database to manage the delivery of PC around the world)
- Mission for SGS-THOMSON in the south during 3 months: Help to put into production the information system for the new factory of ROUSSET (20 Databases –informix, sybase, oracle - in Unix High availability environment)
- Mission for AUCHAN in Lille during 3 months: Help in organizing the level 3 international support
- LOGICA – UK Software & Computer Services Company
Tech accounts Manager – Solaris Admin
SUN MICROSYSTEMS
Lyon
1994.08 - 1996.08
- I did some custom installations for about 80 companies all around Rhône-Alpes, migration of sites from Sunos4.x to solaris2.x with jumpstart for the “Grand LYON”, installation of a web site for SGS Thomson, installation of Backup Copilot with a jukebox in Villeurbanne for a backup solution, installation of dual computers for the CEA (Atomic Study Center), account manager for the CENG (Grenoble Nuclear Study Center)…etc
- SUN MICROSYSTEMS – US manufacturer Company
Solaris admin
ALCATEL
Strasbourg
1990.07 - 1994.07
- Manage the biggest park of SUN MICROSYSTEMS working stations and servers (350 computers) in FRANCE in a team of 8 UNIX system administrators (backup, mails, news, system administration, shells tools)
- ALCATEL – International Telecommunication Group
OS400 admin, developer
UCB
Paris
1989.06 - 1990.06
- Manage the 70 AS400 of the business agencies and programming of administration applications in COBOL.
- Participate in the enterprise project during 6 months to redesign all products with a customer approach using MEURISE-MEGA method to make conceptual design and detail design.
- UCB – Union du Crédit pour le Bâtiment – Private Banking
Scientist
Army
Grenoble
1988.01 - 1989.01
- 1 year at the « direction des travaux du Génie » as Scientist to computerize of the roadworks in Basic BB3.6.12 on PC (analyze, programing, test and put into production). Get a military medal for my work.
Programmer
THOMSON-CSF
Thonon les Bains
1986.06 - 1986.09
- 3 months to program applications of administration in GAP3 on IBM36. Get an award for my work.
Developer
PME SALMODIS
Rungis - Paris
1985.06 - 1985.09
- 3 months for defining, creating and developing an interface to program screens in C on PC.
Formation
Informatic engineer -
INSA de Lyon - Institut National des Sciences Appliquées
Lyon 1983.01 - 1988.01
Bac-E - Honors Good
Compétences
- SQLServer
- Oracle
- MySQL
- Azure
- OCI
- Admin (SSMS, OEM, sqlcmd, sqlplus, psql, pl-sql, t-sql)
- Performance improvement
- Monitoring (icinga)
- High availability
- Clustering (alwaysON, disponibility groups, RAC, DataGuard)
- Security (Always Encrypt, Anonymization, SSL, TDE, Authentication, roles, permissions)
- Partitionning
- Backup and restore (RMAN)
- Data import and export
- Upgrading and Patching
- Documentation
- Ksh
- Bash
- Powershell
- Perl
- Python
- C#
- Java
- VB
Personnalisé
- Disponible: immediately
Language
French
NATIVE LANGUAGE
English
Upper-intermediate
B2
Italian
Beginner
Chronologie
Oracle DBA
Conduent
2025.01 - 2025.12
App support & Dev & SQL Server DBA
LEM SA
2017.09 - 2024.01
Applications support & development
SWISS RISK & CARE
2014.02 - 2017.05
Oracle/SQL server DBA, Solaris Admin
THOMSON REUTERS
2010.07 - 2013.09
Oracle DBA, Solaris Admin
THOMSON REUTERS
2004.04 - 2010.07
Oracle DBA, Unix admin
REALMEDIA
2000.09 - 2004.03
Progress DBA, Developer
LOGICA
1996.09 - 2000.08
Tech accounts Manager – Solaris Admin
SUN MICROSYSTEMS
1994.08 - 1996.08
Solaris admin
ALCATEL
1990.07 - 1994.07
OS400 admin, developer
UCB
1989.06 - 1990.06
Scientist
Army
1988.01 - 1989.01
Programmer
THOMSON-CSF
1986.06 - 1986.09
Developer
PME SALMODIS
1985.06 - 1985.09
Informatic engineer -
INSA de Lyon - Institut National des Sciences Appliquées
1983.01 - 1988.01