Development Tools

Qualifications Profile
Personal Details
Name:
Pablo Stapff
Date of birth:
1972
Nationality:
German
Marital status:
Married, 1 Son
Focus
Senior Oracle DBA, Oracle RAC, Oracle Developer (PL/SQL, Apex), Performance Tuning, Database
Design and Modeling, Oracle Replication
Education
Software Engineer (Public University in Montevideo – Uruguay)
Languages
English:
German:
Spanish:
French:
Fluent
Fluent
Mother tongue
Basic
Branches
Bank
Finance
Aerospace
Research
Publicity
Public Services
Services
TECHNICAL SKILLS
Databases
Oracle Server 8i, 9i, 10g, 11g
Oracle RAC
Oracle Clusteware
Oracle VM
Oracle Automatic Storage Management (ASM)
PL/SQL
Oracle Application Express (APEX)
Oracle Streams
Oracle Advanced Replication
Oracle Partitioning, Advanced Queuing
Oracle Enterprise Security
Oracle Identity Management (Oracle Internet Directory)
Oracle Transparent Gateway for Sybase
BMC Backtrack
Quest Shareplex for Oracle
Database Tools
Oracle SQL Developer
Oracle SQL Developer Data Modeler
Dezign (Datanamic)
TOAD (Quest)
Programming Languages
PL/SQL, SQL
Perl
Shell-Skript (ksh, sh, csh)
Python
Java
SQL Forms, SQL Reports
Visual Basic
C
Development Tools
Subversion (SVN)
Bugzilla
Eclipse
Wiki
Operating Systems
Linux (SuSE, Red Hat, Ubuntu)
Oracle Unbreakable Linux
Sun Solaris 2.8 und 2.9, 2.10
HP-UX 10 und 11
Windows XP/NT/2000/98/95, DOS
OpenVMS
Cluster Technologies
Oracle RAC
Oracle Clusterware
Veritas VolumenCluster
Veritas Cluster,
MC ServiceGuard
Others
Tivoli
WORK EXPERIENCE
Since 1. 09
Migration from Opics to Opics+ and CBS
Position
Oracle Consultant, PL/SQL and Python developer
Company
Hamburger Sparkasse (HASPA)
Tasks
Co-work on the database solution for the system integration
Database design and modeling
Writing the data partitioning and implementation
Build of the database infrastructure
Development Stored Procedures (Packages, Triggers) and Apex applications
Writing of interfaces between the systems
Performance Tunning
Development of tools to simplify the database administration
Give workshops to employees in topics like handling of big tables and performance
Oracle 11g, 10g, 8i
Oracle Advanced Queuing, Flashback Queries, Distributed Transactions
Oracle Application Express (APEX)
Python (cx_Oracle, ibm_db, pysvn) und Perl
Windows, AIX, Linux
Eclipse, Subversion (SVN), EPIC, PyDev, Wiki
Tools
6. 09 – 5. 10
Oracle Internet Directory (OID / LDAP) Migration
Position
Oracle DBA
Company
Deutsches Klimarechenzentrum GmbH - Max Plank Institut
Tasks
Tools
Migration of the OID Instance (Oracle Internet Directory) and Oracle Enterprise Security to a
new server
Registration of the Oracle RAC Database with the OID
Oracle Fusion Middleware / Identity Management / OID, Oracle RAC
1. 09 - 11. 09
Inconsistencies Detection Tool for VPM (A380 Project)
Position
PL/SQL developer
Company
EADS Airbus Deutschland GmbH
Tasks
Conception, design and specification of a high performance tool to detect database
inconsistencies in a replicated environment using Oracle Streams
Development of the tool using PL/SQL
Documentation and Support
Oracle 10g
Oracle Streams
PL/SQL, SQL, Oracle SQL Developer
Subversion, Bugzilla
Tools
1. 08 – 12. 08
Abgeltungssteuer (Withholding Tax )
Company
Hamburger Sparkasse (HASPA)
Position
Oracle Consultant, PL/SQL, Python and Perl Developer
Tasks
Development of interfaces between Opics, Tributum und Kondor+
Database design and modeling
Database performance tunning
Consulting in database technologies like: security, interconnectivity, integration, etc.
Documentation
PL/SQL, Perl, Python
Oracle 8i, 9i
Windows, Unix, AIX
Eclipse, Subversion (SVN), EPIC, PyDev, Wiki
Tools
11. 06 – 12. 07
Third & second Level Support Oracle & PDM Systems
Position
Oracle DBA
Company:
EADS Airbus Deutschland GmbH
Tasks
3rd Level Support for Database Administration, Quest Shareplex and System
Administration
New tools development (Perl, PL/SQL, Shell Script)
New patches and updates coordination
Problem escalation to software providers (Oracle, Quest)
Comparative studies between Quest-Shareplex and Oracle Data Guard
Tools
HP-UX 10 und 11
VPM
Oracle Advanced Replikation, MC Service Guard, Tivoli,
Remedy-Magic, Shareplex for Oracle, Oracle Enterprise Manager, SQL-PLUS,
TOAD for Oracle
Oracle 8i, 9i, 10g
SQL, PL/SQL, Perl, Shell-Skript, Visual Basic
1. 07
Hardware and Database Migration
Position
Oracle DBA
Company
Springer & Jacoby Digital (Media)
Tasks
Migration from a Oracle 9i Datenbase/Debian-Linux to a Oracle 9i/Suse-Linux
Oracle 9i configuration and und optimization
Linux (SuSE, Debian)
Oracle 9i
SQL, PL/SQL, Shell-Skript
Tools
2. 07
Oracle Internet Directory and Oracle Enterprise Security configuration
Position
Oracle DBA
Company
NEC High Performance Computer Europe for the Max Plankt Institut – DKRZ
biggest Oracle database worldwide:
http://www.wintercorp.com/VLDB/2005_TopTen_Survey/2005TopTenWinners.pdf
Tasks
Directory Configuration (OID/LDAP)
Configuration and connection of new database to the Directory
Enterprise Users/Enterprise Roles/Enterprise Login Configuration
Certificates and Wallet Configuration
Tools
Oracle 9i, Oracle Enterprise Security, Oracle Internet Directory
Linux 64 bits (Red Hat)
11. 05 – 10. 06
Product Lifecycle Management (PDM) – VPM, Mirror VPM – A380
Position
Oracle DBA
Company
EADS Airbus Deutschland GmbH
Tasks
Daily work optimization
Support on the migration from Oracle 8.1.7.4 to Oracle 9.2.0.7
Development of several tools to automate administration (Perl, Shell-Script, PL/SQL, VB)
Database operative maintenance of Oracle 8i, 9i and 10g (Production and acceptance
environments)
Coordination and deployment from new system and DB updates
Operative maintenance of the Multi-master Replication (sync and async) using Oracle
Advanced Replication
Operative maintenance of the Master-Slave replication using Quest Shareplex
Problem analysis and resolution in DB, OS and Cluster areas
Documentation
On Call service
Tools
Oracle 8i, 9i, 10g, Oracle Advanced Replication, Oracle DataMiner
Shareplex for Oracle, TOAD for Oracle
HP-UX 10 und 11, MC Service Guard, Tivoli, Remedy-Magic
VPM
SQL, PL/SQL, Perl, Shell-Skript, Visual Basic
4. 05 – 10. 05
Product Lifecycle Management (PLM) – Primes – A400M
Position
Oracle DBA and System Administrator
Company
EADS Airbus Deutschland GmbH
Tasks
Daily work optimization
Development of several tools to automate administration (Perl, Shell-Script, PL/SQL, VB),
Operative maintenance of the Web-Farm (PTC-Windchill)
Coordination and deployment of updates.
Troubleshooting, telephone support
Problem analysis and resolution in DB, OS and Cluster areas
Documentation
On Call service
Tools
Sun Solaris 2.8 und 2.9, HP-UX,
PTC Windchill
Oracle 8.1.7, Oracle Enterprise Manager, Toad for Oracle
SQL Plus, PL/SQL, Perl, Shell-Skript, Visual Basic-, VBA-Programmierung
1. 05 – 3. 05
ICD-Integration and Migration – A380
Position
PL/SQL Entwickler
Company
EADS Airbus Deutschland GmbH
Tasks
Development and deployment of several tools for the data migration
Data migration and import into a Oracle database
Documentation
Tools
Visual Basic, SQL, PL/SQL
Oracle 9i
1. 04 – 12. 04
Database and System Administration
Position
Oracle DBA and System Administration
Company
EADS Airbus Deutschland GmbH
Tasks
Daily work optimization
Support on the migration from Oracle 8.1.7.4 to Oracle 9.2.0.7
Developement of several tools to automate administration (Perl, Shell-Skript, PL/SQL, VB)
Database operative maintenance of Oracle 8i, 9i and 10g (Production and acceptance
environements)
Operative maintenance of the Web-Farm (PTC-Windchill)
Coordination and deployment of software updates.
Problem analysis and resolution in DB, OS and Cluster areas
Documentation
On Call service
Tools
Sun Solaris 2.8 und 2.9, HP-UX
PTC Windchill
Oracle 8i und 9i
SQL Plus, PL/SQL, Oracle Enterprise Manager, Perl, Shell-Skript, Visual Basic, ExcelProgrammierung
7. 03 – 12. 03
Development of a Help tool
Position
Developer
Company
EADS Airbus Deutschland GmbH (Luftfahrtindustrie)
Tasks
Development and deployment of a Help Tool (Perl, Shell-Skript, VB).
Tools
Visual Basic, Oracle 8i, SQL
3. 03 – 7. 03
ISDB Migration (A380 Project)
Position
Developer
Company
EADS Airbus Deutschland GmbH
Tasks
Analysis of the data to be migrated with the end user
Programming of VB code to automate the data conversion
Tools
Visual Basic, Oracle 8i, SQL
12. 97 – 7. 02
Update of the Booking and Payroll systems
Position
Projekt Leader, Oracle DBA
Company
Ministry of Justice - Uruguay
Tasks
Outsourcing of the Booking and Payroll system (planning, coordination and follow up of the
software development)
Installation of the servers, databases and applications
Database and system administration (database installation, database tuning , migration of
data from the old applications )
Server Administration (Windows 2000/NT Server, Solaris)
Coordination of the Technical Support Department
Programming of batch process (PL SQL)
Coordination of the roll out of new Application versions and patches
2nd Level Support
Automation of administrative tasks with VB (software installation, Windows-Policies, user
profiles, etc.)
Tools
Oracle 8i
SUN Solaris, Windows 2000, Windows NT 40
PL/SQL, SQL Loader, import, export, SQL Trace, tkprof
WSH (VB), Perl, ksh, WMI
9. 99 – 3. 01
Consultant in development and communication technologies
Position
Consulta
Company
Social Insurance System (Uruguay, UN Program)
Tasks
Design of a method to monitor the application’s performance and availability through filtering
of HTTP requests and responses with a packet filtering software. This application was later
successfully used for measuring the Quos (quality of service) of the outsourced applications
Update of the Bank Technical guidelines in areas like: programming languages, development
tools, hardware, etc.
Cost analysis for the extension of the WAN
Participation on the definition of the security lines for the development and deployment of the
new and actual applications
Tools
Oracle Server, HTTP Protocol, Microsoft Network Monitor, WAN, LAN, T1, Frame Relay
4. 99 – 11. 99
Temporary leader of the IT department
Position
Projekt Leader, Coordinator
Company
Chic Parisien (wholesale, Uruguay)
Tasks
Temporary management of the projects carried out by the IT department: Accounting,
Payroll, Warehouse, Purchase, Sales, Production, P.O.S.-System (Point of Sale)
Designed a plan for the migration of the company applications and data from the AS400/DB2
to the Windows/Oracle platform
Design and later deployment of a plan for the online connection of all the company branches
using Frame Relay lines and routers
Found a serious performance problem in the AS400 server with a non-well documented
feature of the operating system related to interactive and batch CPU usage. This problem
was harming the company for long time and was found after extensive performance tests
and the reading of the implementation details of the operating system
Tools
Oracle 8i, Windows NT, AS/400, IBM DB2
12. 97 – 11. 99
Web applications development
Position
Web Developer
Company
Uruweb (Web services development, Uruguay)
Tasks
Development of diverse Web applications with access to SQL and Oracle databases (i.e.
http://www.uruguayxxi.gub.uy from the Finance Ministry of Uruguay )
Migration of the web application to an interactive CD-ROM using Visual Basic
Tools
Java, Oracle, SQL Server, Perl, CGI BIN, Python, Linux
8. 94 – 11. 97
Software development and migration projects
Position
Oracle Developer
Company
Micra SRL (Software Development, Uruguay)
Tasks
Development of an application for the Land and Property Registry of Uruguay with SQL
Forms, SQL Report, SQL Menu, PL SQL, VMS
Development of the following applications: Accounting, Payroll, Purchase with SQL Forms,
SQL Report, SQL Menu, PL SQL , Perl, Unix script
Development of an EDI/EDIFACT interface between the purchase system and the suppliers
Configuration and support of the communication equipments: Frame Relay, Leased Lines,
Voice over Frame Relay, Routers, Muxes, etc.
Migration of the accounting and finance systems of the Bank of Uruguay from Unix SVR4 to
Sun Solaris
Tools
PL/ SQL, Pro C, SQL Forms, SQL Reports, SQL Menu, SQL Plus, C, Perl, Unix SVR4, Sun
Solaris, Oracle 7, shell programming, EDI/EDIFACT
Educational background
3. 2010
1. 2010
10. 2009
6. 2009
4. 2008
2. 2008
9. 2007
11. 2006
11. 2006
9. 2006
3. 2006
3. 2002
9. 2000
10. 1999
11. 1999
9. 1999
8. 1999
9. 1996
11. 1995
5. 1993
3. 1993
3. 1993
SIG Security Identity Management - ACTIVE Workshop
Oracle Data Guard
Oracle Streams
Oracle Exadata
Security und Identity Management
Informations-Integration in der Oracle Datenbank (Replikation)
Administration von großen Datenbanken – DOAG Düsseldorf
DOAG Konferenz – Mannheim
High Availability and beyond – Trivadis – DOAG Konferenz
Oracle 10g Tunning - DOAG Hannover
Professioneller Einstieg in Oracle 10g für den DBA - DOAG Köln
Logical Framework for Project Management
Oracle 8: Backup and Recovery
Oracle 8: Server Administration
Supporting Windows NT 40 Enterprise Technologies
Supporting MS-Windows NT 40 Server Core Technologies
Administering Microsoft Windows NT 40
Distributed Information System Design witch Client Server Architectures
Distributed Architectures for Information Systems
Networking Technologies
Netware System Manager 311
Microcomputer Concepts for Netware Users