Resume

Skills Overview________________________________________________________

Functional

  • Developers management in cultural diversity (offshore) – up to 16 persons
  • Project management (plannings, costs, resources, deliveries)
    Project direction (management of several projects in the same time for different clients)
  • Structural and functional audits of SME / SMI
  • Extrem programming implementation
  • Human management (management of crisis, emergencies, team psychology and consistency)

Expertise

  • SQL Server all versions management
  • Data securization – indexing – tuning –  normalization and denormalization of databases
  • Networking (Installation – maintenance) Microsoft – Linux
  • Interfacing with Oracle (data import via ETL, SSIS, Queries)
  • Microsoft n/3 architectures
  • Securization and integration in Active Directory
  • Tuning and optimization (Execution plans, hints, locks, deadlocks, guideplans…)
  • Databases management and housekeeping

Development

  • Development of end user interfaces (VB / ASP / Dot Net)
  • Building and managing of Data warehouses.
  • Building reports (Crystal Report / BusinessObjects / SSRS)
  • Database administration (2000 / 2005 / 2008R2 / 2012)
  • Installation / Deployment and maintenance of business applications
  • SQL Server DTSx packages – Management of rights and permissions – securization via Active Directory
  • SQL server all version – SSIS – SSRS
  • Interfacing with the most known databases (Oracle, Sybase, DB2, Postgres, mySQL)

Office skills___________________________________________________________

  • Software: Pack Office – MS Project – Access
  • System: Linux, Windows all versions

Professional Experience_________________________________________________

From 04/2010 – present // SNCF – (Leader High Speed Train company in the world) (3600 databases / 460 instances)

  • Tuning and problems resolutions on production SQL server databases and applications
  • Management of crisis – failure of exploitation on the critical databases – Conference calls with clients and providers
  • Merge replication (Tuning on e-Ticket project in order to solve, locks replications problems, response time about a merge between SQL servers and thousands of PDAs)
  • SQL Server 2008R2 implementation (Best practices, integration of the product within the company, Advice about databases migration) –  Documentation
  • Management of backups with Symantec Netbackup
  • Management / implementation of monitoring with Tivoli (analysis /      checking of the consistency of alerts / creation of script for features non covered by Tivoli)
  • Clustering deployment an use in productions systems – MSCS – version 2000 – 2005 –  2008R2 (5 nodes clusters)
  • Mirroring high performance / high availability mode (Principal, recovering, witness) in SQL Server 2008R2
  • Analysis / code and design review of e-ticket project (merge replication / C# / assemblies / Broker)
  • Interface with Microsoft premier support on the overall projects
  • Documentation on installation, deployment, best practices, for packaging and deployment

Technologies: SSIS / SSRS / Dot net / SQL Server 2008R2 / 2000 / 2005 / Clusters / Merge Replication / Mirroring / SAN / Nexus / Tivoli / Netbackup / Broker

11/2009 – 03/2010 // Direct Group France – France Loisirs (MultiMedia Distribution)

  • Transactional metrology development on production servers (using DataCollector)
  • Development of transverse Surveillance tools in order to follow the product flows consistency (sales, storage,…
  • Tuning and empowering of user response time. Indexing, queries tuning, stored procedures tuning.
  • Deployment and instance creation on production servers (48 cores).

Technologies: SSIS / SSRS / Dot net / SQL Server 2008 / DataCollector