Missions Sybase : Une multitude d'offres mises en ligne quotidiennement

Aperçu d'expériences 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,

• Database architecture audit ( MS-SQL Server 2005 fully virtualized )

  UNIGESTION ( Geneva / Switzerland )
  Jan 2008 - Jan 2008

  • 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 )

  UBS – 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 ) 1 - UBS Private Banking (Switzerland
  Jan 1996 - Jan 2000

  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

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

  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

• Database Administration ( SYBASE )

  Banque PARIBAS – Database central administration
  Jan 1994 - Jan 1996

  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