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
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
Streamline Data & System infrastructures using cloud compatible technologies
Arkadin
Since April 2017
Full-time
Paris
- 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
Company Description
Arkadin is the world’s fastest growing Collaboration Services Provider. We offer a range of Unified Communications and audio, web and video collaboration solutions, as well as virtual events. These are delivered in the Cloud for fast, scalable deployment.
Company website
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
Company Description
Arkadin is the world’s fastest growing Collaboration Services Provider. We offer a range of Unified Communications and audio, web and video collaboration solutions, as well as virtual events. These are delivered in the Cloud for fast, scalable deployment.
Company website
Contribute to the analysis, management and visualization of Scientific and Regional Data & Databases
OECD
January 2011
to November 2012
Full-time
Paris
France
- 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)
Company Description
The Organisation for Economic Co-operation and Development (OECD): The mission of the Organisation for Economic Co-operation and Development (OECD) is to promote policies that will improve the economic and social well-being of people around the world.
Company website
Led the design and implementation of an automatic, highly flexible, statistical data and metadata collection system for European data and statistics
OECD
April 2008
to December 2010
Full-time
Paris
France
- 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
Company Description
The Organisation for Economic Co-operation and Development (OECD): The mission of the Organisation for Economic Co-operation and Development (OECD) is to promote policies that will improve the economic and social well-being of people around the world.
Company website
Technical project coordinator responsible for maintaining the reliability and availability of the development and production platforms (risk analysis web applications, used worldwide)
Société Générale
July 2006
to April 2008
Paris
France
- 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
