Menu

Fabien LOPES

Avignon

En résumé

SQL expert, project manager, portofolio project management, DBA, DataCenter, SQL, T-SQL, middleware, audit performance & security, reliability, IAE-EDI, infrastructure, tuning, technical leader, data definition, SPOF, monitoring, diagnostic, merge replication, HA-BCP-DRP, Security, Architecture, ISMS, MIM, BizTalk, application interfaces, master data management.
#MicrosoftCertifiedTechnologySpecialist
#RedHatCertifiedSystemAdministrator

Mes compétences :
SQL
Linux
Base de données
Clustering
Enterprise Application Integration
Système d'information
Microsoft .NET
Administration de bases de données
Réseaux informatiques & sécurité
Routage IP
Gestion de projet
Microsoft Windows Server
DHCP
Administration réseaux
Windows PowerShell
ERP
Optimisation des process
VMware
Active Directory
IIS
PL/SQL
DNS
T/SQL

Entreprises

  • Naturex - Database & Disaster Recovery Manager

    Avignon 2017 - maintenant • Databases activities management (run, engineering, design, performance, BCP, DRP, HA, merge replication, team accompaniment, licencing, budget, monitoring, datas consolidation, etc)
    • Project manager for IS outsourcing on premise to datacenter
    • Disaster Recovery Plan, setting up architecture design, processes and policies
    • ISMS contributor on database, flow and DRP parts
    • Management of budget and ROI of different activities and projects
    • Identity management project manager
  • Naturex - SQL DBA & BIZTALK IAE|EDI

    Avignon 2014 - 2017 • Management of instances and databases of different environments
    • Merge replication
    • Architecture and consolidation of different infrastuctures
    • Backups policies BCP DRP
    • Security audit-optimization
    • TSQL optimization, stucture, tuning
    • HA, cluster, AlwaysOn HA/DR
    • Advise and technical support
    • Project manager and BizTalk C# realization of IAE-EDI interfacing (Microsoft CRM, NAV, Tungsten, Sage, HRIS, Carl GMAO) (15 to 800 days)
    • Reference Data Architecture Stream (RDAS)
    • Infrastucture design for prediction of data volumetrics in the short and medium term (1 to 5 years)
    • SSIS – SSRS
    • Master Data Management
    • L3 support
  • CHU Saint-Etienne - SYSTEMS ENGINEER - SQL DBA

    2013 - 2014 • Systems engineer with 8000 end users, 500 servers, 6000 computers.
    • Virtualization and desktop presentation (VMWare-Citrix)
    • Active Directory – DNS- DHCP – Cluster Microsoft – NLB - IIS
    • SQL manager (cluster, mirroring, security, BCP-DRP, VLDB)
    • IT ERP Manager « CristalNet » and « CristaLink » (1500 users)
    • L3 support (for MS technologies)
  • Chambre de Commerce et d'Industrie de la Drôme - ENGINEER SYSTEMS AND NETWORKS AND C# .NET

    ROCHEFORT 2011 - 2013 • Final thesis on the optimization of network exchanges lead by the doctor Ny Haingo Handriana
    • Virtualization (VMWare)
    • Application interfaces / C# / T-SQL
    • Network and system audit
    • Management of MS domains, servers, routers and switches
  • Chambre de Commerce et d'Industrie de le Drôme - CHARGED SYSTEM ADMINISTRATION AND NETWORK SECURITY

    2010 - 2011
  • CCI Drôme - SYSTEMS ADMINISTRATOR AND NETWORK

    2008 - 2010

Formations

  • EPSI Lyon

    Lyon 2012 - 2013 MASTER DEGREE 2•SECURITY EXPERT

    Sécurité et réseaux
  • EPSI Lyon

    Lyon 2011 - 2012 MASTER DEGREE 1•ENGINEERING COMPUTER SCIENCE
  • IUT

    Valence 2010 - 2011 LAW DEGREE•NETWORK ADMINISTRATION AND SECURITY

    ____Certifié Microsoft MCTS 70-640 : Mise en place et configuration Active Directory Windows Server 2008
    ____Certifié Linux RedHat Certified System Administration

    ____Suivi Cursus PRO : CCNA v4

Réseau

Annuaire des membres :