SW

Sigmund Westerwick

verfügbar

Letztes Update: 16.03.2024

Sybase Expert and DBA, ORACLE, MS SQL

Firma: DBConsulting
Abschluss: Master Datentechnik
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Muttersprache) | englisch (gut)

Dateianlagen

CV_westerwick_2020_ENG.doc

Skills

Unix, Programming, sql, 2020 x, PL/SQL 2020 x, Shellscripts 2020 x, Perl 2018 x, MS SQL Server 2008 2011 x, MS SQL Server 2012 2012 x, MS SQL Server 2016 2018 x, Sybase ASE 2020 x, Sybase ASAnywhere 2020 x, Sybaser IQ 2020 x, Clearcase, Powerdesigner, 2019 x, SQL Developer 2019 x, MS ManagementStudio 2019 x, SqlPowershell 2013 x, Subversion 2010 x, Jira 2019 x, Mercurial 2019 x, Git 2020 x, Continuous Integration 2019 x, Sybase Anywhere applications, Sybase SQL Anywhere, Sybase, static data, ETL, Sybase ASE Sybase 16.0, Solaris, Sybase Application Optimization, Sybase Sybase 15.7, x86, SPARC, Sybase 12.5, Sybase 15.7, Sybase IQ 15.4, Sybase IQ, Informatica, RedHat Linux, MS SQL 2012, database, MS SQL, data warehouse, database model, stored procedures, Sun Solaris 8, Solaris 10, Sybase replication server, SUN Solaris, Sybase DBA, TSQL, T-SQL, SQL Server, SUN, Solaris 9, SYBASE 12.0, SQLServer, Windows, Database tuning, databases, Sun Solaris 2.6, Sun Solaris 2.6 and 2.8, MS SQL Server 2000 / 2003, Sybase applications, Sybase 11, Sun Solaris 2.5, CA Unicenter, MS SQL database Modeller, database administration, MS SQL Server 6.5, NT 3.5.1, Sybase SQL Server, Replication Server, IQ, Sybase ASE

Projekthistorie

01/2015 - 12/2015
Sybase Engineer
Commerzbank

Job description:
Project Sybase Application Optimization
* rightsize various standard and inhouse application to use sybase 15.7 properly and to reduce
the need of sybase licences
* develop sybase_support tools to be sybase 15.7 ready
The goal is to optimize daily processing to a higher level of automatisation and use sybase
15.7 features.


Environment: Sybase Sybase 15.7 and 16.0 on solaris x86 and SPARC T5.

01/2014 - 12/2014
Sybase DBA
Commerzbank

Job description:
Project Sybase Licence Optimization
* rightsize various standard and inhouse application to use sybase 15.7 properly and to reduce
the need of sybase licences
* identify performance problems in configuration, application or architecture based on
performance measurement.
* adjust configuration on application needs
* Make suggestions and prototypes to verify application and archtitecture problems
* make application quality checks to make sure they perform best on given and new build sybase
server


Environment: Sybase 12.5 to Sybase 15.7 on solaris x86 and SPARC T5.
Sybase IQ 15.4

07/2013 - 08/2013
Sybase IQ tuning
HRS

Job description: Sybase IQ,consultant in a new BI project using Informatica and sybase IQ
* tune the confiuguration, benchmark the virtualized system .
* Define and benchmark guidelines for developers


Environment: Sybase IQ 15.4 on RedHat Linux.

12/2001 - 05/2013
Sybase DBA
Commerzbank

Job description:
Sybase DBA , upgrading sybase 12.5 Sparc to 15.7 x86
* upgrade applications using sybase to latest level of ASE.
* Supporting application developers and dbo to use new features of sybase, specially tuning the
application.


Environment: Sybase 12.5.02 on Sun Sparc.
Sybase 15.7 on x86.

07/2006 - 10/2012
DBA, developer and 3rd level Support
UBS AG

Job description:
DBA, developer and 3rd level Support of a complex production environment
* Developer for an existing huge database on sybase ASE 15, used as data warehouse for
reporting, database size 1 tb
* extended / redesigned a market rate database from a historical database to a market data
engine, database model having around 100 tables
* Designed and developed a new application for market data and deal database to deliver risk
data for risk Management. This project maps the request from the business analysts to the
technical data deliverable by the existing database and send the data in a new format
downstream to other systems
* Modelling the schema for a trade data warehouse on Sybase IQ
maintain the schema for IQ
maintain all db objects like view / stored procedures etc
setup maintenance tasks for logical partitioning
* Deliver maintenance tasks for all these systems
* 3rd Level-Support for applications and SYBASE database to 1st and 2nd level support of the
application
* Release management
* Tuning of the database


Environment: Most of the installations are SYBASE 12.5, SYBASE 15 on Sun Solaris 8 and Solaris 10, Sybase
replication server 12.5, 12.6, 15, IQ 15.4

07/2005 - 06/2006
DBA and 3rd level Support
Commerzbank

Job description:
Sybase DBA and 3rd level Support of a complex production environment
* 3rd Level-Support for SYBASE on SUN Solaris to support the 1st and 2nd level support of the
application, Sybase DBA of a production environment.
* My Tasks are to help the application support in questions they can't resolve by their own,
specially tuning the application.


Environment: Most of the installations are SYBASE 12.5.02 on Sun Solaris 8. Some run on Solaris 9 and SYBASE
12.5.1.

07/2004 - 06/2005
DBA and SQL Developer
Postbank

Job description:
Sybase DBA and 3rd level Support of Kondor Reporting system
* deliver application support for database and solaris, specially tuning the application.
* Design and deliver additional reports for Kondor+ in TSQL
* Add mapping functionality between Kondor calculation engine and T-SQL reporting .

Environment: SYBASE 11.9.1 / sybase 12 on Sun Solaris 8.

10/2003 - 06/2004
Sybase DBA
GfK, Gesellschaft für Konsumforschung

Job description:
Sybase DBA and 3rd level Support of a complex production environment
* 3rd Level-Support for SYBASE on SUN Solaris to support the 1st and 2nd level support of the
application, Sybase DBA of a production environment of about 15 instances of SYBASE SQL Server
on SUN with the biggest database of 130 GB.
* Deliver databse support for application support team
* Implement some scripts to monitor performance and for accounting, end of year production
support

Environment: Most of the installations are SYBASE 11.9.2 on Sun Solaris 8. Some run on Solaris 9 and SYBASE 12.0.

05/2000 - 08/2003
Technical consultant Sybase / MS SQLServer
DZ Bank

Job description:
Front Arena
* Installing Font Arena on SUN / Solaris and Windows.
* Setup test environment, configure for maximal throughput.
* Setup system for high availability, define and implement interfaces to other systems like WM,
EUREX, OPTAS, XETRA
Database tuning of the application SUMMIT and MUREX
* Remove some Bottlenecks of the application and of the configuration of the SQL Server. Some
problems were solved specially reorganizing the databases.


Environment: Sybase 12.0 on Sun Solaris 2.6, Sybase 12.5 on Sun Solaris 2.6 and 2.8, MS SQL Server 2000 / 2003 on
Windows

01/1999 - 04/2000
Sybase DBA, developer and 3rd-level support
DZ Bank

Job description:
production/Test Environment
* Working in the operating team to optimize the production risk system of the customer which
runs in a pool of SUN E6000 on SYBASE 11 using the self-developed risk system based on
infinity.
* Optimize the database processes to minimize the manual work to run the system and to minimize
the maintenance time needed.
* Improve performance and quality of Sybase applications.


Environment: Sybase 11, Sun Solaris 2.5, CA Unicenter TNG

06/1998 - 12/1998
MS SQL database Modeller, system Administrator
Unisys

Job description:
Voucher processing
* Develop complete new software for voucher processing for banks.
* Database modelling definition of technical guidelines of the database system, definition of
standards for triggers and stored procedures and views, performance tuning of the database
servers.
* Development of scripts for database administration and self repairing features in the
distributed environment.


Environment: The system runs in a cluster of 10 MS SQL Server 6.5 on NT 3.5.1.

04/1997 - 05/1998
System architect, developer, production support and Team leader
Dresdner Bank

Job description:
Bloomberg back office information system architecture
* Definition of technical and logical standards for the database, database modelling and support
of the information system for fixed income / sales based on the Bloomberg online and batch
feeds.
* Technical project leader for all solaris and Sybase aspects of the application, team leader of
4 internal employees of Dresdner Bank.



Environment:
Sybase SQL Server, Replication Server, IQ on SUN

01/1993 - 12/1997
Consultant
Sybase ASE


01/1990 - 01/1993
Founder and CEO
SQL Gmbh

Function: Consultant in industry and telecom,
teacher for in house courses of Sybase at client site

01/1987 - 01/1990
Scientific assistants
Alfred-Wegener-Institute for marine and polar research


Reisebereitschaft

Verfügbar in den Ländern Deutschland
Profilbild von Sigmund Westerwick Sybase Expert and DBA, ORACLE, MS SQL aus Linsengericht Sybase Expert and DBA, ORACLE, MS SQL
Registrieren