Your browser is outdated!

To ensure you have the best experience and security possible, update your browser. Update now

×

Julien Vavasseur

Data & System Architect

Professional Status
Freelancer
Available
About Me
Define and implement reliable solutions and scalable infrastructures that improve productivity while minimizing exposure to risk and fulfilling objectives of the company
Numerous experience in administration, design and optimization of information systems and databases of various sizes and shapes, and therefore in processing and dealing with large data and metadata sets
Flexible and innovative problem solver with good organizational skills and proven ability to work efficiently under pressure and meet tight deadlines, to work in various sectors and to manage international projects at level in either French or English
  • Build: Implement a database infrastructure to store and retrieve critical information across 5 datacenters, handling outages, scalability and security, dealing with disparate legacy hardware and high latency network (Active Directory, Windows Failover Clusters, SQL Server multisite and distributed database Availability Groups, VMware)
  • Implement a multi-site classical SQL Server replication and failover platform
  • High Availability: Plan and lead the successful internalization of customer facing servers ; Migrate and upgrade hundreds of databases worldwide to an automatic, near-zero data loss, SQL Server 2016+ platform
  • Automation: Lead external resources in charge of fully automating and scripting servers deployment, setup and administration using PowerShell, Data-Tier Application framework and Policy-Based Management (Server Core, SQL Server, DACFx, SSDT)
    Highly focused on Idempotence: Do, Undo & Redo ; Get(), Set() & Test()
  • Security: Reduce surface by providing lightweight Windows Server (Core) without any unnecessary or deprecated features or service; Replace Group Policies by Desired State Configuration; Deny any access and replace accounts and passwords by managed accounts
  • Support: Provide high level insights to Development and Operation teams; Supply scripts and tools that enable safe and secure deployment, optimization and upgrade
Learn more

Automate SQL Server databases and Windows Servers Administration

Rothschild
March 2016 to March 2017
Freelancer
Paris
France
  • Production and UAT databases administration, maintenance and support
  • Implementation and integration of databases processes and tools to the continuous integration and deployment platform (PowerShell, DACPAC packages, SSIS, SSRS)
  • Automation and centralization of servers administration and security

SQL Server DBA, Oracle and SQL Server database administration

Banque De France
July 2015 to March 2016
Freelancer
Paris
France
  • Audit of PL/SQL packages, outline various documents (data migration, guideline for developers, production template, etc.)
    Support to the data migration and development teams (from Oracle to .Net and PostgreSQL or SQL Server)

Improve reliability and provide advices and support to Dev and Ops teams

Arkadin
May 2013 to June 2015
Freelancer
Paris / Chicago
France
  • Oversee the implementation of a multi-site Disaster Recovery Platform of SQL Server clusters (NTTC, Spain)
  • Administration of servers, clusters and load balancers, analysis and optimization of databases and queries: Billing & rating processing time is now up to 1.000 times faster, several processes now run in a matter of seconds or less
  • Monitor and validate databases security and queries executed on Production
  • Data migration from 4 billing information systems and hundreds of databases worldwide
  • Conception, automation and administration of the Audit, Migration, Dry Run platforms
  • In-depth analysis of outstanding issues; Insure efficient and scalable solutions are provided: data extraction and migration time divided by 50, data quality improved, audit time reduced by 20
Learn more
  • Implemented a data collection system and database with an automatic and integrated formula calculator
  • Assisted with the data layout of the paper version of “Regions at a Glance”, managed the implementation and integration of the web version developed in Sweden (http://rag.oecd.org) and played an active role in making Regional Data more visible and accessible through OECD eXplorer tools
  • Administration of databases and queries used to ease data analysis and updates (SQL Server, .Net)
  • Provide advices and support to the expansion of the “STI’s Micro-data lab” infrastructure
    Defined an internal version of the SCOPUS bibliographic database, sped up the upload of 55 millions of articles by 10, implemented procedures for easier and faster statistical analysis of string data (SQL Server, .Net, XML)
  • Sped up the administration, analysis and combination of voluminous collections of data (Big Data), in particular data covering: patents and trademarks (USPTO, EPO, etc.), firm-level data (ORBIS), scientific papers (SCOPUS)
  • Coordinated consultants (Idener, Spain) engaged to develop databases string-matching algorithms (.Net, Java)
  • Technological awareness: assessment of Amazon Elastic Compute Cloud for the parallelization of text matching and analysis; considered how recent web technologies may improve geospatial data visualization (HTML5 & SVG); Entered online visualization challenge « Visualize the Return on Education » (http://datarise.net/edu)
Learn more
  • This system significantly improves the Eurostat data collection process accuracy and efficiency: millions of up-to-date statistical time series are now collected daily and are used internally by several directorates (2 developers, .NET, SQL Server)
  • Provided support and assistance to statistical data collection teams (SQL Server, .Net)
  • Administration and design of databases and tools used to optimize the collection and the accuracy of data
Learn more
  • Outlined a multi-site disaster recovery plan and procedures using VMware ESX servers
  • Planned and coordinated applications and databases rollout with project managers and operations teams
  • Improved efficiency, performance and security and ease the administration of the infrastructure and provided support to customers and Development teams (SQL Server, Tomcat, Weblogic, Java, .Net, Perl)
  • Coordinated the migration of applications and web services from Tomcat to Weblogic
    Designed the architecture and organize the project plan with Operations managers

Management of development and production platforms, management of trainees

Euris
March 2006 to July 2006
Full-time
Paris
France
  • Implemented an Active Directory forest, integrated with Open Directory (4 domains)
  • Planned and implemented virtualization and monitoring platform (ESX, Nagios)
  • Planned, coordinated and implemented systems to automate web applications and databases rollout, improve efficiency, performance and security of the web servers infrastructure and ease systems administration, provided support to the development teams (4 SQL Server clusters, 80 databases, 40 Windows/Unix Freebsd)

Project management, design, implementation and development in Beijing and Shanghai

Freelance
December 2003 to December 2005
Freelancer
Beijing / Shanghai
China
  • Management of a team of 3 Chinese developers (communication in English)
  • System and databases administration; Designed, implemented and developed web; Supplied support to customers on procedures and documents including project plans or specifications (Windows, Unix FreeBSD, Linux, MySQL, PostgreSQL, ASP/PHP, PostgreSQL, Unix FreeBSD and Linux)

Merged dozens of databases and data files into one main information system

Bouygues Telecom
April 2003 to October 2003
Temporary Work
Paris
France
  • Management of millions of mobile devices, reduction of response time by 35% and billing of millions of Euros

Production’s infrastructure administration and monitoring (2 datacenters, over 150 servers)

Cable & Wireless
June 2000 to April 2003
Temporary Work
Paris
France
  • Implementation of an ASP.NET shared web hosting platform; Development of an information system used for the management of products & services in over 20 datacenters worldwide (SQL Server, ASP, ASP.NET)
  • Implementation and development of a QOS server for ISDN Internet connections: This platform reduced denial-of-service by 85% and avoids major failures.
  • Design and implement a high availability email ticketing platform for the customer support system (SMTP, Exchange and SQL Server replicated with the main cluster): This platform reduced hardware and operational costs by over 60%
  • Technological awareness: assessment of a prototype ASP.NET shared web-hosting architecture in partnership with HP and Microsoft (Windows, SQL Server, ISA Server)

Developer in the financial accounting and reporting team

AS Groupe
November 1999 to June 2000
Full-time
Paris
France

Developer in the “Research & Development” unit

Bosch
April 1999 to August 1999
Internship
Caen
France

Developer in the “Research & Development” unit

Bosch
April 1998 to August 1998
Internship
Caen
France
  • SQL Server 2000-2017+ (Transact SQL, SSIS, SSRS)
    Transact SQL, SSIS, SSRS, SSDT, DacPac, DacFX, Cluster, Data Collector, Policy-Based Management
    Expert
  • SSDT, DacPac, DacFX
    Advanced
  • SQL Server Data Collector
    Expert
  • SQL Server Policy-Based Management
    Advanced
  • MySQL
    Good
  • PostgreSQL
    Intermediate
  • Oracle
    Notions
  • AlwaysOn Failover Clustering
    Expert
  • AlwaysOn Availability Groups
    Expert
  • Log Shipping
    Expert
  • Replication with Failover Clustering
    Expert
  • Distributed Availability Groups
    Good
  • Replication with Availability Groups
    Good
  • Windows Server 2016+
    Failover Clustering, Active Directory, DNS, DSC, GPO, IIS, ...
    Expert
  • Mac OS X
    Advanced
  • Unix (FreeBSD)
    Intermediate
  • Linux
    Intermediate
  • .Net, ASP.Net, Visual Studio
    Advanced
  • PHP
    Intermediate
  • SQL/Transact SQL
    Expert
  • Objective C
    Intermediate
  • PowerShell
    Advanced
  • PowerShell
    Expert
  • Shell
    Good
  • Javascript
    Advanced
  • VB Script / VBa
    Expert
  • WMI
    Good
  • Perl
    Good
  • DSC
    Advanced
  • Chef
    Good
  • SaltStack
    Intermediate
  • Puppet
    Intermediate
  • IIS
    Expert
  • Apache
    Advanced
  • Tomcat
    Good
  • Team Foundation Server
    Good
  • Exchange
    Good
  • VMware
    Advanced
  • Hyper-V
    Good
  • Zabbix
    Good
  • OpManager
    Intermediate
  • HP Sitescope
    Intermediate
  • Nagios
    Intermediate
  • Active Directory
    Advanced
  • Open Directory
    Good
  • DNS
    Expert
  • Firewall
    Advanced
  • NSX, loadbalancer, F5 big/ip, Foundry, ...
    Intermediate
  • French (native)
  • English (fluent)
  • Chinese (some notions)

Certification

Microsoft

Since 2015
MCSE Data Management and Analytics
MCSE Data Platform
MCSA Windows Server
MCSA SQL Server

Baccalauréat S

Caen

1995