&bull Database teams&rsquo management
&bull Risk analysis
&bull Infrastructure and Cloud management
&bull Recruitment of profiles
&bull Help for Certification iso27001, PSSI.
&bull Build process, governance to implement change.
&bull System design and best practice
&bull Copil, Cotech, Coproj
&bull Onboarding new customer
&bull SQL Server SQL 2019\2022
&bull Oracle Rac, MongoDB
&bull High Availability (Cluster, Always On) Disaster Recovery
&bull Audit
&bull SQL Server Migration 2008/2012 to SQL 2019
&bull Build SQL machine, Indexes reviews
&bull Management of 3000 SQL BDD
&bull Architecture definition
&bull (MOA, MOE, SI, manager)
&bull ITIL
&bull Risk analysis
&bull ZERO TRUST
&bull SQL Server security reviews
&bull High Availability (Cluster, Always On) Disaster Recovery
&bull Project Management
&bull Audit SQL, Performance system window
&bull Troubleshooting Performance
&bull Identity Access Management
&bull Audit SQL server, Performance system windows
&bull Clarification of the strategy for backup restores.
&bull Analyze of all task ETL (SSIS)
&bull Control flows Troubleshooting SSIS
&bull Migration SQL 2014 to 2019
&bull RACI, KPI
&bull Aways-on implementation
&bull Troubleshooting Database corruptions
&bull Database System Resources consumption
&bull (Test définition, implémentation, reporting)
&bull Project Management
&bull Identity Access Management
&bull Administration tools (CA IM 12.6.8, Brainwave iGRC)
&bull IAM Evolution, LDAP
&bull Architecture definition
&bull (MOA, MOE, SI, manager)
&bull Workshop session
&bull RACI, KPI
&bull (Conception, modélisation, fonctionnel OpenLdap)
&bull Risk analysis
&bull Tools Linux CentOS and Windows (Databases SQL, script perl, java).
&bull Support MOE installation of new connectors IAM (CA IM 12.6.8 with web portal)
&bull Open Ldap, Storage model (attributs, classes objet, Format LDIF, Provisioning LDAP, ACL
&bull (Test définition, implémentation, reporting)
&bull Project Reporting
&bull Cluster windows Configuration with SQL server 2012
&bull Implementation of Always-On DR on OVH with physical servers Cluster SQL
&bull Backups Strategy
&bull Cluster Always-On Configuration
&bull Drafting installation documentation
&bull Documentation Toggle Test and BACKSPACE
&bull Backups/Restore
&bull Database Tuning Performances Analysis
&bull Identification of slow query and query consumption
&bull SQL Trace profiler
&bull Index creations Analysis of execution plan
&bull Creation of maintenance plan, Backups Strategy
&bull Disk configuration, Tuning DB
&bull Rebuild indexes, Update statistics
&bull Parameter Modification to optimize SQL instances
&bull Database System Resources consumption
&bull Database Tuning
&bull Database System Resources consumption
&bull Configuration of Database disks in HQ and LS
&bull Checking of Database logs and generations of the report of transaction logs
&bull Selection of software accessing to the database
&bull Databases mirroring for Disaster Recovery
&bull Clarification of the strategy for backup restores.
&bull Identification of slow query and query consumption
&bull SQL Trace profiler
&bull Execution plan Analysis with index creations
&bull Maintenance plan, Backups Strategy
&bull Disk configuration, Tuning DB
&bull Rebuild indexes, Update statistics
Application Management and 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&hellip.
- Administration of the shared platform MS-BI 2014
- Resource Management and rights-related projects
- Management and Time Incident
- Planning and distribution of sites
- Monitoring the progress of activities
- Monitoring of requests from operators
- Interface between projects
- Ensuring the Safety of security and data / platform
- Construction and publication of reports
- Communication Management
- Writing technical documentation