Freelance SYBASE : Trouvez les savoir-faire dont vous avez besoin

Résumé des missions de Laurent,
freelance SYBASE habitant la Haute-Savoie (74)

• UBS – INVESTMENT BANKING ( Zürich / Switzerland )
  Jan 2009 - Jan 2009

  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,

• UNIGESTION ( Geneva / Switzerland )
  Jan 2008 - Jan 2008

  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, …

• Database senior Consultant ( SYBASE / replication server )

  JP MORGAN BANK ( Geneva / Switzerland )
  Jan 2006 - Jan 2009

  • 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

• Database senior Consultant ( SYBASE / replication server )

  JP MORGAN BANK ( Geneva / Switzerland )
  Jan 2006 - Jan 2008

  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

• Database administration ( SYBASE / replication server )

  INVESTMENT BANKING ( Zürich / Switzerland )
  Jan 2005 - Jan 2006

  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 …

• Database administration ( SYBASE / replication server )

  JP MORGAN BANK ( Geneva / Switzerland )
  Jan 2000 - Jan 2004

  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, …

• 2 - UBS Domestic (Switzerland) – EUP Project
  Jan 1998 - Jan 1999

  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

• UBS ( Basel / Switzerland )
  Jan 1996 - Jan 2000

  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

• Database Administration ( SYBASE and MS-SQL Server )

  3 - Swiss Bank Corporation (Switzerland ) – GDIP Project
  Jan 1996 - Jan 1998

  • 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

• Database administration and development ( SYBASE )

  Informatique CDC - Technical innovation department
  Jan 1994 - Jan 1994

  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