MongoDB and PostgreSQL infrastructure administration and architecture @ Kapten (ex Chauffeur Privé), the number one french Private Hire company. Working to expand our platform to all Europe.Migration of the whole platform to MongoDB Atlas managed database as a service on GCP.Full infrastructure as code architecture.Technologies:- Linux, Kubernetes, Docker, MongoDB, PostgreSQL, Ansible, Terraform, Prometheus, Git, Jira, Elastic..- Platforms: GCP (Google Cloud Platform), AWS (Amazon Web Services)…Remote position

Database expert for various clients ( bank, insurance, industry, web):- Oracle database & Exadata- PostgreSQL- MySQLAmazon Web Service (AWS) consultant for cloud migrations

MS SQL server, Postgresql, MariaDB

Sparklane, a French company, is an editor of sales & marketing intelligence solutions for the European B2B market.In charge of the Data team and architecture :- Rebuild of the data architecture stack- Automation of data processing and workflows- Database model definition- Migration from on-prem (MSSQL) to AWS cloud architure (Postgresql)AWS, Postgresql, MS SQL, Talend.

In charge of the BI and Datawarehouse architecture.Expanding the on-premise capacities on the cloud using AWS Redshift and Elastic Map Reduce (EMR).

Database administrator for government specific websites & applications (Taxes, Customs, HR management & government employees' pay, GeoSpatial apps...)Oracle databases (10gR2 & 11gR2) under VMWARE & RHEL 5&6.PostreSQL 9.3 databases.Tuning & performance optimisation.Support for dev team.Oracle databases migrationsOracle 12c migration feasability study.

-Team management (in partnership with the B.I team leader) of 10 people.Recruitment of 7 people in order to strengthen the B.I skills of the team.Process definition (based on ITIL)-Architecture & technical expertise : Datawarehouse & reporting tools architecture : sizing & technical choices regarding the new B.I. platform.Data modelling & optimisations regarding new B.I projects in order to maintain optimal performances.Support for B.I. engineers & data analysts for modeling & performance optimisations.Realtime replication expertise : P.O.C of different replication solutions. Installation & architecture of Oracle Goldengate realtime replication between production databases & datawarehouse.Business Impact Analysis of the datawarehouse platform in order to choose the appropriate backup strategy. Deployment of EMC Datadomain (with source deduplication).-Project management : Entreprise reporting redefinition (global KPI, financial, billing, CRM, tracking reports)New Datawarehouse architecture migrationTechnological watch : BigData, NoSQL, Column Oriented databases, MPP, In-Memory, Cloud.

- Database administration :Oracle Databases (from 9i to 11gR2) and Mysql databases under Linux RHEL 5 & 6 .Installation, maintenance, repair & operation on RAC clusters 11gR2 with active dataguard architecture.Tuning & support for Dev teams for SQL & PL/SQL.Monitoring & alerting definition.Shell scripting & PL/SQL developments for new website functionnalities.Oracle Goldengate expertise (realtime replication).On-call DBA (level II : technical expertise & decisions making), 3mn intervention delay 24/7.-Project management : Project leader & technical expert for MEETIC website migration towards a new Oracle 11gR2 High-Availability architecure (RAC cluster) : P.O.C, install, benchmarking, optimisation & migration with limited downtime.Oracle Backup strategy definition : disk backup & EMC AVAMAR appliance

database administration of 800 Oracle databases (8i, 9i , 10g), Sql Server & MysqlHpUx & Solaris.Database creation, upgrade, patches.Database performance audit.SQL queries tuning.Support for DEV team.Backup administration.Monitoring tools development (php + shell).