Freelancerprofil: Z16173

DBA System- und Datenbankadministration, Sybase, Murex

IT-Erfahrung seit:
2018
Position:
IT Administration / Support
IT Datenbankadministration
IT Helpdesk/ Technischer Support
Projekte im Werdegang
01/2018 - 03/2018 Banking know-how, Finance, Sybase, MS SQL Server, SQL, Perl, Change Management, Sun OS / Solaris, Storage, Middleware/Transactions, CVS, Release Management
Operating Systems: Solaris 2.6, 7 and 8 Hardware: SUN E4500, E10K, Comparex Storage Systems Development: SQL, Perl, Sybperl, Korn-Shell Database Server: Sybase ASE 11.0.3, 11.9.2 and 12.0 Middleware: Sybase Replication Server 11 Databases: 100 Databases of 1GB - 20 GB 200 users 100 - 2500 tables Database Tuning: Deadlocks, Performance, Temp. Database, Queries Replication: Replication of 20 tables with Warm-Standby Primary Server Tools, Libraries:Maestro (job scheduler), Big Brother (monitoring) SCCS, CVS (release management) Secure Copy (software deployment) job scheduler

03/2013 - 04/2013 Banking know-how, Finance
System analysis and system development Banking/Finance MM

04/2010 - 05/2010 Sybase, Banking know-how, Finance, Storage, Veritas, IBM Tivoli, Sun OS / Solaris, SQL, Change Management, C, C++, Oracle, CVS, Release Management
Operating Systems: Solaris 8 System Management: Veritas Volume Manager and Cluster (3.5) Hardware: SunFire 6800, Sun V880, Sun Storedge 6320 Development: SQL, Korn-Shell Database Server: Sybase ASE 12.0 and ASE 12.5 Databases: 10 dataserver, > 50 database pairs 20G and 4G (Murex and MxmL) Database Tuning: Tools, Libraries:N/A Server configuration (cache, disk i/o) Operating Systems: Solaris 8 Hardware: Siemens Primepower Development: SQL, Korn-Shell, C/C++ Database Server: Oracle 9i Databases: Single database instance, 5 schema of 2.5GB Database Tuning: N/A Tools, Libraries:Summit Toolkit, CVS (release management), Oracle SQL*Loader Major, Volume Manager, Tivoli Workload Scheduler, Veritas Volume Manager and Cluster, meta model, Abstract operational model

02/2010 - Sun OS / Solaris, CVS, Release Management, Document management, Sybase, MS SQL Server, SQL, Perl, MS Office
Operating Systems: Solaris 8 Hardware: SUN E4500, V880 Development: SQL, Perl, Sybperl, Korn-Shell Database Server: Sybase ASE 12.0 Databases: 20 Databases of 1GB - 7GB, 100 - 2000 tables, 50 users Database Tuning: Deadlocks, Performance, Temp. Database, Queries Tools, Libraries:MS Office, CVS (release management), Secure Copy (software deployment), OTRS (request tracking), Big Brother (monitoring)

07/2005 - 03/2006 Sybase
Sybase administration

07/2005 - 03/2006 Banking know-how, Finance, Sybase, Sun OS / Solaris, SQL
Operating Systems: Solaris 8 and 9 Hardware: Sun, Siemens-Fujitsu Development: SQL, Korn-Shell, awk Database Server: Sybase ASE 12.X, Replication Server 12.X, Sybase IQ 12.X Database Tuning: Server configuration (cache, disk i/o, segments) Tools, Libraries:ksh toolset (automated installation)

09/2004 - 06/2005 Sybase
Helaba in Frankfurt/Germany Murex and Sybase administration

07/2004 - 08/2004 MS-Project
Summit Administration (interims project)

01/2004 - 01/2006 Sybase
Referenzen und Rollen Helaba in Frankfurt/Germany Murex and Sybase administration

04/2003 - 04/2004 System analyst and system developer, database adminstrator System analyst, system developer

10/2000 - 09/2001 Banking know-how, Finance, Sybase, MS SQL Server, Change Management, Unix General, Sun OS / Solaris, Storage, SQL, C, Middleware/Transactions, MS Office, Release Management
Operating Systems: Solaris 2.6 Hardware: SUN E3500 Comparex Storage Systems Development: SQL, C-Shell, Korn-Shell Database Server: Sybase ASE 11.9.2 Middleware: Sybase Replication Server 11.5 Databases: 10 Databases of 1GB - 5 GB 200 users 50 - 100 tables Database Tuning: Deadlocks Replication: Replication of 50 tables Tools, Libraries:MS Office Continuus (release management) Globus (software deployment) second controller

10/2000 - 03/2003 system and database administrator System analyst, system manager, database administrator

04/2000 - 09/2000 Banking know-how, Finance, Sun OS / Solaris, Veritas, Storage, SQL, Perl, Oracle, MS Office
Operating Systems: Solaris 2.5.1 Hardware: SUN E4500 IBM Enterprise Storage Systems Development: SQL, Bourne-Shell, Perl Database Server: Oracle 8.0.4 and 8.0.6 Databases: 10 Databases of 1GB - 5 GB 50 users 100 tables, 50 schemas Tuning: Location of database files (I/O contention) Blocksize of databases and filesystems Replication: Basic replication of 50 tables via snapshots Tools, Libraries:MS Office additional packages like Veritas volume manager

04/1999 - 03/2000 Sybase, Oracle, MS SQL Server, Banking know-how, Finance, Auditing, Perl, Sun OS / Solaris, Windows NT, Storage, SQL, ERwin, MS Office, BMC Patrol, PVCS
Operating Systems: Solaris 2.5.1, Windows NT Hardware: SUN E450, E3500, E4500, IBM Enterprise Storage Systems Development: SQL, Korn-Shell, Perl, ERwin 3.5 Database Server: Sybase SQL-Server 11.0.3/11.5 Oracle 8.0.3, Oracle 8.0.4, Oracle 8.0.5 MS SQL-Server 6.5 Databases: 20 Databases of 100M - 5 GB 10 - 100 users, 50 - 100 tables Tuning: Location of database files (I/O contention) Blocksize of database and filesystem Replication: Basic replication of 50 tables via snapshots Tools, Libraries:MS Office, MS SQL Enterprise Manager, Patrol, PVCS MS SQL Enterprise Manager

04/1999 - 09/2001 Database administrator, system integrator

10/1998 - 03/1999 System and database administrator database administrator

10/1998 - 03/1999 Sybase, SQL, Banking know-how, Finance, Perl, Sun OS / Solaris, Windows NT, MS SQL Server, Middleware/Transactions, MS Office
Operating Systems: Solaris 2.5.1, Windows NT Hardware: SUN E3500 and E4500 Development: SQL, Korn-Shell, Perl Database Server: Sybase SQL-Server 11.0.3/11.5 Middleware: Sybase Replication Server 11 Databases: 50 Databases of 1GB - 10GB 10 - 150 users 50 - 100 tables, > 1000 tables (Murex) Database Tuning: Temp. Database Memory of SQL-Server Online Engines Replication: Replication of 20 tables with Warm-Standby Primary Server, multiple secondary sites Sybase Replication Server Manager

10/1998 - 03/1999 Sybase, SQL, Banking know-how, Finance, Perl, Sun OS / Solaris, Windows NT, MS SQL Server, Middleware/Transactions, MS Office
Operating Systems: Solaris 2.5.1, Windows NT Hardware: SUN E3500 and E4500 Development: SQL, Korn-Shell, Perl Database Server: Sybase SQL-Server 11.0.3/11.5 Middleware: Sybase Replication Server 11 Databases: 50 Databases of 1GB - 10GB 10 - 150 users 50 - 100 tables, > 1000 tables (Murex) Database Tuning: Temp. Database Memory of SQL-Server Online Engines Replication: Replication of 20 tables with Warm-Standby Primary Server, multiple secondary sites Sybase Replication Server Manager

03/1998 - 09/1998 Banking know-how, Finance, Risk Management/Basel II, Visual Basic, Sun OS / Solaris, Windows NT, Sybase, MS SQL Server, Middleware/Transactions, MS Office, MS-Access
Operating Systems: Solaris 2.4 and 2.5.1, Windows NT Hardware: SUN SS 1000 E, E450, E4000, E6000 Development: Visual Basic, Visio Professional Database Server: Sybase SQL-Server 11.0.3 Databases: 20 Databases of 1GB - 20GB Middleware: Sybase Replication Server 11 Replication: Replication of 20 tables, single primary site, multiple secondary sites Tools, Libraries:MS Office, MS Access Operational Model, data model, Documentation of the operational model

08/1996 - 09/1998 DG Bank (GIS) Frankfurt/Germany System + database administrator, system integrator

07/1995 - 09/1995 Computer Science, Sun OS / Solaris, C++, Oracle
Software Nexus informatics 3 MM - Design and implementation of a job-dispatcher (optimised management of database requests) Operating Systems: Solaris 2.4 Hardware: SUN SS 1000 E Development: SUN Sparcworks C++ Database Server: Oracle 7 Database: 10 Databases of, 100M - 1 GB 10 users, 100 tables Dispatcher, Connection manager

04/1995 - 06/1995 C++, Oracle, Computer Science, SQL, Storage, Sun OS / Solaris
Software Nexus informatics 3 MM - Design of classes in order to connect to Oracle databases, execution of dynamic SQL, storage of SQL contexts, stored procedure interface and the processing of result sets Operating Systems: Solaris 2.4 Hardware: SUN SS 1000 E Development: SUN Sparcworks C++ Database Products: Oracle 7 Databases: 5 Databases of 100M - 500M Tools, Libraries:Tools.h++, ACE

01/1995 - 03/1995 VMS, Sun OS / Solaris, Computer Science, Fortran
Software Nexus informatics 3 MM - Implementation of VMS Systemcalls - Coding of wrapper functions and procedures in FORTRAN - Coding of functions in C called by the wrapper functions and procedures Operating Systems: OpenVMW, Solaris 2.4 Hardware: SUN SS 1000 E Development: SUN Sparcworks FORTRAN and C

01/1995 - 07/1996 Computer Science
Nexus informatics Munich, Germany NRK Norway Software developer, database administrator

07/1994 - 12/1994 Logistics, AIX, C++
Software Compex 6 MM - Design and implementation of a graphical user interface (order forms and booking). - Redesign and coding of the control flow (event driven). - Design and implementation of a picture catalog (X Bitmaps) of items. - Display of pictures in order forms via hot keys Operating Systems: SCO ODT 3.0, AIX 3.2.5 Hardware: IBM RS 6000, PC Development: C++ Compiler Database Products: C-Tree Tools, Libraries:Zinc Class Library, Motif 1.2, C-Tree

01/1994 - 06/1994 Logistics, AIX, C++
Software Compex 6 MM - Re-coding of libraries. - Review of data types and functions, i.e. function pointers and declarations Operating Systems: SCO ODT 3.0, AIX 3.2.5 Hardware: IBM RS 6000, PC Development: C++ Compiler Database Products: Tools, Libraries:C-Tree C-Tree

02/1993 - 12/1993 AIX, C
Software Compex - Fax-Server - File transfer - EDIFACT 11 MM Operating Systems SCO ODT 3.0, AIX 3.2.5, MS DOS Hardware IBM RS 6000, PC Development C Compiler Database Products Tools, Libraries C-Tree C-Tree

02/1993 - 12/1994 Compex Heidelberg, Germany Software developer

10/1991 - 10/1992 Storage, Unix General, C, ESQL
Operating Systems: SCO UNIX Hardware: Siemens PC Development: C, ESQL/C Database Products: Informix Tools, Libraries:Motif 1

 
Branche
  Telekommunikation
Verteidigung und Sicherheit
 
Kenntnisse
Hardware
Betriebssysteme
AIX
Sun OS / Solaris
Unix
VMS
Programmiersprachen
C
C++
CSS
Fortran
HTML / XML
Perl
SQL
VB (Visual Basic)

Datenbanken
Access
MS SQL Server
Oracle
Sybase

Datenkomm. / Netzwerk
Storage Systeme
TCP/IP

Design / Entwicklung

SAP / ERP Module

Software / Tools
BMC Patrol
CVS (Concurrent Version System)
MS Office
PVCS Serena Versionsmanagement
Tivoli IBM

Standards / Prozesse
Basel II / Risk Management
Changemanagement
Rechnungswesen
Releasemanagement
Risk Management
 
Ausbildung & Zertifikate
08/1996 - 02/1998 20 MM
Operating Systems: Solaris 2.4 and 2.5.1, Windows NT Hardware: SUN SS 1000 E, E4000 Development: Visual Basic, Visio Professional Database Server: Sybase SQL-Server 10, 11.02, 11.5 Middleware: Sybase Replication Server 11 Databases: 100 Databases of 1GB - 20GB 100 users 200 tables Trigger: 20 Stored Procedures Tuning: Temp. Database Memory of SQL-Server, Online Engines Named Caches Locking (clustered indexes, table partitioning, transaction mgmt.) Indexes Location of database devices, raw devices/volumes Replication: Replication of 20 tables, single primary site, multiple secondary sites Tools, Libraries:MS Office

10/1995 - 07/1996 SUN HA Cluster, 10 MM
Software Nexus informatics 10 MM - Administration of SUN Server 1000 E incl. operating system, volume manager, cluster software, compiler Operating Systems: Solaris 2.4 Hardware: SUN SS 1000 E Development: Korn Shell Database Server: Oracle 7 Databases: 10 Databases of 100M - 1 GB 100 users, 100 tables

 
Sprachen
chinesisch
englisch
schwedisch
spanisch (++++)


Sonstiges
 

für Freelancer

für Kunden

Kontakt

people4project GmbH
Lörenskogstr. 3
85748 Garching bei München
+49 (89) 55 29 39 - 40
Kontaktdaten anfordern
Image

Vereinbarung zur Verwendung von Cookies

Allgemeine Verwendung

Wir verwenden Cookies, Tracking Pixels und ähnliche Technologien auf unserer Website. Cookies sind kleine Dateien, die von uns erstellt und auf Ihrem Gerät gespeichert werden. Unsere Website verwendet Cookies, die von uns oder von Dritten zu verschiedenen Zwecken im Rahmen der Verwendung und Funktionalität einschließlich der Personalisierung unserer Website abgelegt werden. Es ist möglich, dass Cookies verwendet werden, um zu nachzuvollziehen, wie Sie die Website verwenden und so zielgerichtete Werbung anzuzeigen.

Dritt-Anbieter

Unsere Website nutzt verschiedene Dienste von Dritt-Anbietern. Wenn Sie auf unserer Website sind, können diese Dienste anonyme Cookies im Browser des Benutzers ablegen und diese Cookies mit in der Cookie-Datei des Besuchers speichern. Im folgenden eine Liste einiger derartiger Dienste: Google, Facebook, Twitter, Adroll, MailChimp, Sucuri, Intercom und andere soziale Netzwerke, Anzeigen-Agenturen, Sicherheits-Software wie z.B. Firewalls, Datenanalyse-Unternehmen und Anbieter von Internetzugängen. Diese Dienste sammeln möglicherweise auch anonyme Identifizierungsmerkmale wie die IP-Adresse, den HTTP-Referrer, die eindeutige Geräte-Kennung und andere nicht-persönliche Informationen zur Identifizierung sowie Server Logfiles.