Expert SQL Server : Premiers consultants dispos et missions récentes déposées

Exemple de missions de Balenkin,
Expert SQL Server habitant les Yvelines (78)

• Leaders Technical Architect Infra

  Neurones IT Nanterre
  Jan 2022 - aujourd'hui

  • 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

• Expert SQL Server/ OCED

  OCED Boulogne Billancourt (Freelance)
  Jan 2021 - aujourd'hui

  • 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

• Expert SQL Server/Security

  Bouygues Immobilier Issy-les-moulinaux (Freelance)
  Jan 2020 - aujourd'hui

  • 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

• Expert SQL Server/Ingénieur Security

  Bouygues Télécom Vélizy (Freelance)
  Jan 2019 - aujourd'hui

  • 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

• Consultant Expert

  Groupes Ayme Carpentras (Freelance)
  Jan 2018 - aujourd'hui

  • 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

• SQL Server 2012 Consultant Expert

  Optis Toulon (Freelance)
  Jan 2018 - aujourd'hui

  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

• SQL Server 2012 Consultant Expert

  Easiware Marseille (Freelance)
  Jan 2018 - aujourd'hui

  • 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

• Consultant Expert

  Ministry of immigration Namibia (Freelance)
  Jan 2018 - aujourd'hui

  • 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

• Team Manager SQL Server

  L’Oréal (Freelance)
  Jan 2018 - aujourd'hui

  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

• Certified Systems Administrator India (Freelance)

  RED HAT 7
  Jan 2016 - Jan 2017

  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….