Missions Sybase : Postulez aux offres de mission publiées

Aperçu d'expériences de Laurent,
freelance SYBASE habitant la Haute-Savoie (74)

• UBS &#x2013 INVESTMENT BANKING ( Zürich / Switzerland )
  Jan 2009 - Jan 2009

  Database administration and development ( SYBASE / replication server )
  &#x2022 development and optimization for Forex and Money Market trading applications (primebrokerage, credit, structured products, derivatives, &#x2026)

  &#x2022 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

  &#x2022 complete audit of machines, servers and databases architecture
  &#x2022 study of processes ( maintenance, data stream, reporting, &#x2026 ), code review

  &#x2022 technical environment Windows 2003, VM-WARE, MS-SQL Server 2005, &#x2026

• Database senior Consultant ( SYBASE / replication server )

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

  &#x2022 worldwide day to day administration for production, UAT and development servers (100 servers, 4000 databases, 4 replication servers).
  &#x2022 migration Direct-connect 12.6 / 15, ASE 12.5.4 / 15

  &#x2022 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).
  &#x2022 migration RS 11.5 / 12.1 / 12.6 et ASE 11.9.2 / 12.5 / 12.5.4
  &#x2022 sybase expertise : tuning, optimization, definition of standards,
  &#x2022 shell ( ksh ) and SQL scripting, technical support for development teams (SQL, &#x2026 )

  &#x2022 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 &#x2013 INVESTMENT BANKING ( Zürich / Switzerland )
  Jan 2005 - Jan 2006

  &#x2022 global worldwide administration ( 1500 servers, 150 replication servers )
  &#x2022 installation and configuration, upgrade ( 12.5.3 ), technical support
  &#x2022 tuning and optimization, shell ( Solaris ) and SQL scripting ( T-SQL )

  &#x2022 environnement SUN/SYBASE 11.9.2/12.5.3, Replication Server, ORACLE, MS-SQL SERVER 2000, Direct Connect, SQL Backtrack, Patrol &#x2026

• 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).
  &#x2022 migration RS 11.5 / 12.1 et ASE 11.9.2 / 12.5, SQL-SERVER 7 / 2000
  &#x2022 design and implementation of the replication architecture ( RS 12.1 )
  &#x2022 sybase expertise : tuning, optimization, definition of standards
  &#x2022 shell and SQL scripting ( Sun ), technical support for development teams (SQL, &#x2026 )

  &#x2022 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, &#x2026

• 2 - UBS Domestic (Switzerland) &#x2013 EUP Project
  Jan 1998 - Jan 1999

  Database specialist : administration, design and development ( MS-SQL Server )
  &#x2022 design and development ( stored procedures, triggers, scripts ) of the End User Platform configuration database for the UBS ( 38000 users )
  &#x2022 definition and implementation of the Replication architecture
  &#x2022 definition of standards ( development and production, backups, access rights, &#x2026 )

  &#x2022 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 &#x2013 may 2000 )
  Database consultant ( SYBASE and MS-SQL SERVER )
  &#x2022 set up of the development and productive systems ( security concepts, backup and recovery plans, audit, data transfer strategy, &#x2026 ), development of automated administration procedures ( sp, shell scripts,.. ), general worldwide administration
  &#x2022 definition of standards ( production and development )
  &#x2022 database design and development, tuning and optimization, SQL technical support

  &#x2022 technical environment SUN/SYBASE 11.9.2, Windows NT/MS-SQL Server 7

• 3 - Swiss Bank Corporation (Switzerland ) &#x2013 GDIP Project
  Jan 1996 - Jan 1998

  Database Administration ( SYBASE and MS-SQL Server )
  &#x2022 migration of the bank&#x2019s computer system, UBS/SBS merge
  &#x2022 administration of the development, test and production databases for the migration
  &#x2022 definition of methods and standards, security concepts, backups and recovery, &#x2026
  &#x2022 development ( SQL and Korn Shell ), administration tools, tuning and optimization, support

  &#x2022 technical environment SUN/SYBASE 11, Windows NT/MS-SQL Server 6.5

• Database Administration ( SYBASE )

  Banque PARIBAS &#x2013 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
  &#x2022 conducted back server development and production standardisation
  &#x2022 developed administration tools ( T-SQL, Unix shell )

  &#x2022 technical environment : HP-UX, RS6000-AIX, DEC-OSF1, SYBASE, NT, POWERBUILDER, Visual C++, ACCESS, Visual Basic, ORACLE