• Database teams’ management
• Risk analysis
• Infrastructure and Cloud management
• Recruitment of profiles
• Help for Certification iso27001, PSSI.
• Build process, governance to implement change.
• System design and best practice
• Copil, Cotech, Coproj
• Onboarding new customer
• SQL Server SQL 2019\2022
• Oracle Rac, MongoDB
• High Availability (Cluster, Always On) Disaster Recovery
• Audit
• SQL Server Migration 2008/2012 to SQL 2019
• Build SQL machine, Indexes reviews
• Management of 3000 SQL BDD
• Architecture definition
• (MOA, MOE, SI, manager)
• ITIL
• Risk analysis
• ZERO TRUST
• SQL Server security reviews
• High Availability (Cluster, Always On) Disaster Recovery
• Project Management
• Audit SQL, Performance system window
• Troubleshooting Performance
• Identity Access Management
• Audit SQL server, Performance system windows
• Clarification of the strategy for backup restores.
• Analyze of all task ETL (SSIS)
• Control flows Troubleshooting SSIS
• Migration SQL 2014 to 2019
• RACI, KPI
• Aways-on implementation
• Troubleshooting Database corruptions
• Database System Resources consumption
• (Test définition, implémentation, reporting)
• Project Management
• Identity Access Management
• Administration tools (CA IM 12.6.8, Brainwave iGRC)
• IAM Evolution, LDAP
• Architecture definition
• (MOA, MOE, SI, manager)
• Workshop session
• RACI, KPI
• (Conception, modélisation, fonctionnel OpenLdap)
• Risk analysis
• Tools Linux CentOS and Windows (Databases SQL, script perl, java).
• Support MOE installation of new connectors IAM (CA IM 12.6.8 with web portal)
• Open Ldap, Storage model (attributs, classes objet, Format LDIF, Provisioning LDAP, ACL
• (Test définition, implémentation, reporting)
• Project Reporting
• Cluster windows Configuration with SQL server 2012
• Implementation of Always-On DR on OVH with physical servers Cluster SQL
• Backups Strategy
• Cluster Always-On Configuration
• Drafting installation documentation
• Documentation Toggle Test and BACKSPACE
• Backups/Restore
Audit SQL, Performance system windows
• Clarification of the strategy for backup restores.
• Analyze of all task ETL (SSIS)
• Control flows Troubleshooting SSIS
• Migration SQL 2008 to 2014
• Disk Configuration
• Database System Resources consumption
• Database Tuning Performances Analysis
• Identification of slow query and query consumption
• SQL Trace profiler
• Index creations Analysis of execution plan
• Creation of maintenance plan, Backups Strategy
• Disk configuration, Tuning DB
• Rebuild indexes, Update statistics
• Parameter Modification to optimize SQL instances
• Database System Resources consumption
• Database Tuning
• Database System Resources consumption
• Configuration of Database disks in HQ and LS
• Checking of Database logs and generations of the report of transaction logs
• Selection of software accessing to the database
• Databases mirroring for Disaster Recovery
• Clarification of the strategy for backup restores.
• Identification of slow query and query consumption
• SQL Trace profiler
• Execution plan Analysis with index creations
• Maintenance plan, Backups Strategy
• Disk configuration, Tuning DB
• Rebuild indexes, Update statistics
Administration IBM Cognos BI 11.0.9, Planning Analytics Workspace, Docker, TM1, SQL Server 2016
- Management of dev- teams, implementation and deployment of processes, etc ...
- Writing technical specifications, managing SQL Server maintenance plans
- Environment creation Test, DEV, INT, UAT, PPROD, PROD
- Monitoring implementation management, level 2/3 support
- AD group management, user creation, rights management on servers, Application of server patches, SSO for the portal
Users Management and groups, Control file access, Monitoring (process &services)
-Configuration OpenSSH, network management, archives, copy of files, packages, filesystem, Vim, ACL
-Tracking Security update, Creations of file systems, management of permission
-SE Linux Security, Partition, LVM, storage network, troubleshooting, firewalls, DNS
Hardening server RED HAT: central Authentication, Audit, Gestion du PAM….