Laurent - DBA SYBASE

mar 2009 –aug 2009 UBS – INVESTMENT BANKING ( Zürich / Switzerland )
Database administration and development ( SYBASE / replication server )
• development and optimization for Forex and Money Market trading applications (primebrokerage, credit, structured products, derivatives, …)
• technical environment SUN/SYBASE 12.5.4/15.0.2/Replication server, MS-SQL Server 2005,

aug 2006 – dec 2009 JP MORGAN BANK ( Geneva / Switzerland )
Database senior Consultant ( SYBASE / replication server )
• worldwide day to day administration for production, UAT and development servers (100 servers, 4000 databases, 4 replication servers).
• migration Direct-connect 12.6 / 15, ASE 12.5.4 / 15
• technical environment SUN/SYBASE 12.5.4/Replication server 12.6, MS-SQL Server 2000, Murex, Orion, Direct Connect

jun 2008 –jul 2008 UNIGESTION ( Geneva / Switzerland )
Database architecture audit ( MS-SQL Server 2005 fully virtualized )
• complete audit of machines, servers and databases architecture
• study of processes ( maintenance, data stream, reporting, … ), code review
• technical environment Windows 2003, VM-WARE, MS-SQL Server 2005, …

jul 2006 – feb 2008 JP MORGAN BANK ( Geneva / Switzerland )
Database senior Consultant ( SYBASE / replication server )
• worldwide day to day administration for production, UAT and development servers (100 servers, 4000 databases, 4 replication servers).
• migration RS 11.5 / 12.1 / 12.6 et ASE 11.9.2 / 12.5 / 12.5.4
• sybase expertise : tuning, optimization, definition of standards,
• shell ( ksh ) and SQL scripting, technical support for development teams (SQL, … )
• technical environment SUN/SYBASE 12.5.4/Replication server 12.6, MS-SQL Server 2000, Murex, Orion, Direct Connect

apr 05 -jun 06 UBS – INVESTMENT BANKING ( Zürich / Switzerland )
Database administration ( SYBASE / replication server )
• global worldwide administration ( 1500 servers, 150 replication servers )
• installation and configuration, upgrade ( 12.5.3 ), technical support
• tuning and optimization, shell ( Solaris ) and SQL scripting ( T-SQL )
• environnement SUN/SYBASE 11.9.2/12.5.3, Replication Server, ORACLE, MS-SQL SERVER 2000, Direct Connect, SQL Backtrack, Patrol …

may 2000 – dec 2004 JP MORGAN BANK ( Geneva / Switzerland )
Database administration ( SYBASE / replication server )
• worldwide day to day administration for production, UAT and development servers (90 servers, 4000 databases, 4 replication servers).
• migration RS 11.5 / 12.1 et ASE 11.9.2 / 12.5, SQL-SERVER 7 / 2000
• design and implementation of the replication architecture ( RS 12.1 )
• sybase expertise : tuning, optimization, definition of standards
• shell and SQL scripting ( Sun ), technical support for development teams (SQL, … )
• technical environment SUN/SYBASE 11.9.2/12.5/Replication server 11.5/12.1, MS-SQL Server 2000, ORACLE 8i, murex, Symbiator, Direct Connect, …

aug 96 – may 2000 UBS ( Basel / Switzerland )
1 - UBS Private Banking (Switzerland ) – GPP Project ( may 99 – may 2000 )
Database consultant ( SYBASE and MS-SQL SERVER )
• set up of the development and productive systems ( security concepts, backup and recovery plans, audit, data transfer strategy, … ), development of automated administration procedures ( sp, shell scripts,.. ), general worldwide administration
• definition of standards ( production and development )
• database design and development, tuning and optimization, SQL technical support
• technical environment SUN/SYBASE 11.9.2, Windows NT/MS-SQL Server 7

2 - UBS Domestic (Switzerland) – EUP Project ( june 98 -may 99 )
Database specialist : administration, design and development ( MS-SQL Server )
• design and development ( stored procedures, triggers, scripts ) of the End User Platform configuration database for the UBS ( 38000 users )
• definition and implementation of the Replication architecture
• definition of standards ( development and production, backups, access rights, … )
• technical environment Windows NT/MS-SQL Server 6.5, Replication, Visual C++, ASP

3 - Swiss Bank Corporation (Switzerland ) – GDIP Project ( aug 96 - may 98 )
Database Administration ( SYBASE and MS-SQL Server )
• migration of the bank’s computer system, UBS/SBS merge
• administration of the development, test and production databases for the migration
• definition of methods and standards, security concepts, backups and recovery, …
• development ( SQL and Korn Shell ), administration tools, tuning and optimization, support
• technical environment SUN/SYBASE 11, Windows NT/MS-SQL Server 6.5

sept 94 to jul 96 Banque PARIBAS – Database central administration
Database Administration ( SYBASE )
• conducted SYBASE implantation study ( general organisation based on Client/Server architecture ), in charge of production and development databases administration
• conducted back server development and production standardisation
• developed administration tools ( T-SQL, Unix shell )
• technical environment : HP-UX, RS6000-AIX, DEC-OSF1, SYBASE, NT, POWERBUILDER, Visual C++, ACCESS, Visual Basic, ORACLE

apr 94 - sept 94 Informatique CDC - Technical innovation department
Database administration and development ( SYBASE )
• responsible for the administration of databases
• developed stored procedures ( SQL ) and administration tools
• performed functional design and technical studies
• technical environment : SUN/SYBASE, SQL, SQL WINDOWS

oct 93 - march 94 RENAULT – OPTIMA project
SYBASE audit
• technical audit of both back server and front end platforms
• technical environment : ORACLE, IBM AIX, Object view

apr 93 - aug 93 SOCIETE GENERALE - Capital Market
Front office software audit
• conducted technical audit of several front-office software packages
• completed study of relational data modelling and database organisation
• technical environment : SUN/SYBASE, OS2/MS-SQL Server, C, SQL

oct 92 - march 93 EDF - Financial Management
Audit and application development (Automated financial data acquisition software )
• performed the audit of the software
• conducted the rebuilding of the whole project ( database design and application’s programs )
• technical environment : MS-SQL Server, SQL, Object View

oct 91 – sep 92 Groupe ELIS – Downsizing project
Database Administration ( SYBASE )
• administration of production and development environments
• technical environment : SUN/SYBASE, Db Lib C, Apple 4D

feb 88 –sep 91 Project Manager
• IDG Communication ( Le monde informatique ) : sales management project
• DYRION : Financial market trading management project ( back-office )
• Brussels stock exchange : documentation management software
• CEP : accounting management software, building acoustics analysis software
• project management ( project and staff planning, client/server normalisation, database design, software specifications, ... )
• technical environment : local network, PC, RDBMS ( SYBASE, SQL Server, Dbase, btrieve ), pascal, C