Freelancer profile translated to English.

Description

Expert consultant in information systems, with 30 years of experience in database management, IT architecture, project management, and strategic consulting. Specialist in SQL Server, Oracle, and MySQL, with proven expertise in the administration, tuning, migration, and security of critical environments. Strong command of PowerShell, Windows Server, Linux, and Unix for automation, deployment, and monitoring of complex infrastructures.

Proven experience as an architect and project manager, with recognized skills in ITIL, change management, continuous process improvement, and change management. Ability to intervene at all levels with a results-oriented and value-added approach. Works with business and IT departments to design, manage, and optimize strategic decision-support and operational solutions.

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

Natixis/BPCE Assurance
Datacenter Migration Architect
June 2023 - Today (3 years)
Paris, France
• Implementation of the migration plan for the entire BPCEA infrastructure from On-Premise to MyCloud
• Impact analysis for successful migration
• Support for development teams throughout the acceptance testing phase
• Migration of all database engines to SQL Server 2019 before relocation
• Implementation of Polybase as a database interconnection element instead of linked servers
• Redesign of the target architecture before migration and advice on adapting developments
• Implementation of the global migration plan minimizing development and user actions
• Management of the migration project
• Implementation of the migration architecture from SAS to ALTAIR and Dataiku
• Security implementation following migration from SAS to ALTAIR and Dataiku
Technical environment: SQL Server 2012 to 2019, SQL, Powershell, GCP,
SGBD : SQL Server, SSAS, SSRS, SSIS, Oracle, Sybase, MySQL, PostGreSQL, MariaDB, Snowflake Systèmes d’exploitation : Unix, Linux, Windows (Hyper-V, Vmware, Nutanix) SQL Server expertise Développement : XML, Javascript, Python, PowerShell, Unix Shells, Transact-SQL, PLSQL Logiciel : Sharepoint, Teams, Zoom, Skype, Grafana, Zabbix, Telegraf, Chronograf, Kapacitor, Influxdb
DataOne
Senior DBA and Architect SQL Server, MariaDB, PostgreSQL and MongoDB
December 2021 - June 2023 (1 year and 6 months)
• Consulting and administration of the global database infrastructure (SQL Server, mariadb, postgreSQL and MongoDB)
• Installation and configuration of AlwaysON clusters with SQL Server
• Installation and configuration of galera clusters with mariadb
• Installation and configuration of clusters with postgreSQL (HA with repmgr and keepalived)
• Monitoring of old postgreSQL clusters (HA with pgpool)
• Correction of configurations of existing clusters under linux debian 10 or Redhat 8
• Optimization of SQL Server architecture and licensing
• Support for project and development teams
Technical environment: SQL Server 2012 to 2019, MariaDB, PostGreSQL, MongoDB, AlwaysON, PowerShell, TSQL, Zabbix, influxdb, Grafana, SQLSentry, Windows and Linuxdebian and redhat,
Natixis/BPCE
Senior DBA and Architect SQL Server and ORACLE
December 2020 - December 2021 (1 year)
• Taking over the database infrastructure previously managed by a third-party provider
• Infrastructure cleanup for better performance
• Review of data and processing models for improved performance
• Harmonization of maintenance batches
• Support for project managers in correcting processes and authorizations
• Generalization of database anonymization
• Implementation and monitoring of transfer rules for the entire BPCEA infrastructure to MyCloud (Private Cloud)
• Implementation of a batch monitoring library in an industrialized manner using Powershell/TSQL
• Implementation of a global monitoring infrastructure (Grafana, InfluxDB, Telegraf, Chronograf, Kapacitor) with automatic ticket generation for production DBAs via SNOW
• Technical control and advice for DataCenter migration processes
• Implementation and recommendation of a Big Data Cluster on a Kubernetes cluster
• Training project managers on best practices for deliverables
Technical environment: SQL Server 2005 to 2019, Oracle Exadata, AlwaysON, PowerShell, TSQL, Zabbix, influxdb, Grafana, Dynatrace, VTOM,

Check out Mathias's experience

Be the first to recommend Mathias

Help this freelancer shine by sharing your experience working together.

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

Oracle 9iRAC, Oracle 9i Real Application Clusters (5j)
2002
Oracle 9iRAC, Oracle 9i Real Application Clusters (5j)
DBA Oracle, Administration avancée ORACLE (5j)
2001
DBA Oracle, Administration avancée ORACLE (5j)