DB2 UDB Experte, DSS, BI, Data Warehouse(DWH)/ETL (Informatica), Oracle und SQLServer

Professional main focus: DB2 UDB Experte, DSS, BI, Data Warehouse(DWH)/ETL (Informatica), Oracle und

SQLserver DBA


Education:

Degree in Computer Science 11/2001 - Diplom Informatiker (FH)

Advanced Training:

08/2002 - MQSeries - Administration of workstations
08/2002 - AIX/UNIX

06/2003 - DB2 Family
08/2003 - DB2 UDB for UNIX - Administration

04/2005 - MOC2072 Administration of Microsoft SQL Server 2000 databases
04/2005 - MOC2073 Programming of Microsoft SQL Server 2000 databases

Profil
-------

DB2 UDB Expert for Linux, Unix/AIX und Windows (LUW)

o DB2 Database Administrator (DBA) on AIX and Windows
o Building of high availability (HACMP/HADR) and backup solutions
o Tuning and performance tests in symmetric multiprocessor system (SMP) environment with database partition feature (DPF)/inter-partition parallelism and intra-partition parallelism queries
o Establishing of DB2 Standby (replication) databases by using of user exits or HADR configuration (log-shipping)
o Using of flashcopy (Cloning) feature for DB2 databases via set write suspend/resume commands
o Analyse, design und maintain of db2 systems, also by using the DB2-health monitor
o Establishing of federated databases
o Writing and optimization of SQL statements
o Programming of stored procedures
o Scripting in shell, especially in KornShell
o Managing open problem management records (PMRs) in IBM

Informatica Specialist

o Informatica PowerCenter administrator
o Establishing and analysing of Informatica Infrastructures in SAP environment
o Analyse and design of workflows, sessions, mappings, etc.

SQLServer DBA on Windows
Oracle DBA on AIX and Windows

5+ years project experience to work in an international environment
2 years experience to work abroad


Knowledge
---------------

Datenbanken/RDBMS: IBM DB2 UDB für LUW EEE/ESE 7/8/9
MS SQLServer7/8(2000)/9(2005)
Oracle EE 8i/9i/10g

Data Warehouse/ETL: Informatica PowerCenter/PowerMart 6/7
Informatica PowerConnect (Striva)
Informatica PowerChannel
Informatica PowerAnalyzer
Symilarity Systems Athanor

Database-Tools: Quest Central for DB2
Quest Spotlight on DB2
Quest Spotlight on SqlServer
Quest Toad 7 for Oracle
Quest SQL Navigator 4

Backup-Tools: IBM Tivoli TSM/ADSM [Archive Client 5]/TDP
BMC SQL-Backtrack 3
Oracle RMAN

Operation systems: IBM AIX 4/5, UNIX/Linux Derivate
MS Windows 2000/2003 (Advanced) Cluster Server

(Script-)languages: VB6,VBA
ksh, csh, sh, Perl, PHP
J2EE,C