Senior Consultant DBA, Developer, Support

2/2016 – 12/2016

Implementation/Installation/Testing of SAP ASE HADR for HCP (HANA Cloud Platform) persistence team.

IT-Beratung (allg.)

2/2013 – 12/2015

Sybase ASE databases, Perl Scripting, Backup management with HP Data Protector, Analysis and performance and tuning. Upgrade ASE 15.7 to ASE 16.0. All performed in a Linux X86 environment. Development of processes/scripts for space management, auditing, database encryption.

Sybase, Linux (Kernel), Qualitätsmanagement / QS / QA (IT), Perl, Scripting, Back up / Recovery, IT-Beratung (allg.)

3/2012 – 2/2013

I am responsible for administering Sybase ASE database instances, IQ, backup and replication servers supporting Brokerage, Trading and asset management systems on various Solaris and Linux platforms, i.e., Murex, Kondor, Summit, etc.
I also am responsible for database design and deployment of Sybase upgrades, hardware upgrades, performance and tuning, general database support and deployment activities.
I support Sybase Replication Server environments, including Warm Standby as well as standard replication.
I provide daily consulting to development groups in SQL performance and tuning, database design, and troubleshooting. I also advise development managers on future migration strategies and production configuration changes for better performance.
I support Customer Service Centers with database issues. I also participate in a 7 x 24 on-call rotation in support of Sybase databases.
I created the database environments for the Fortune system.
I perform installation of software changes to various applications and database software.
For the DKIB to Commerzbank fusion, I migrated Autosys maintenance jobs to Cron, and converted over monitoring jobs from Patrol to in-house monitoring tools.
Maintain script and SQL sources, using subversion.
Documentation managed with Sharepoint.

Sybase, SQL, Hardware Entwicklung, SAP Beratung (allg.), IT-Support (allg.), Migration, Konfiguration, Back up / Recovery, IT-Beratung (allg.)

2/2008 – 1/2012

I am responsible for administering Sybase ASE database instances, IQ, backup and replication servers supporting Brokerage, Trading and asset management systems on various Solaris and Linux platforms, i.e., Murex, Kondor, Summit, etc.
I also am responsible for database design and deployment of Sybase upgrades, hardware upgrades, performance and tuning, general database support and deployment activities.
I support Sybase Replication Server environments, including Warm Standby as well as standard replication.
I provide daily consulting to development groups in SQL performance and tuning, database design, and troubleshooting. I also advise development managers on future migration strategies and production configuration changes for better performance.
I support Customer Service Centers with database issues. I also participate in a 7 x 24 on-call rotation in support of Sybase databases.
I created the database environments for the Fortune system.
I perform installation of software changes to various applications and database software.
For the DKIB to Commerzbank fusion, I migrated Autosys maintenance jobs to Cron, and converted over monitoring jobs from Patrol to in-house monitoring tools.
Maintain script and SQL sources, using subversion.
Documentation managed with Sharepoint.

Sybase, SQL, Datenbankadministration, Hardware Entwicklung, SAP Beratung (allg.), Microsoft SharePoint Server, Apache Subversion (SVN), IT-Support (allg.), Migration, Konfiguration, Back up / Recovery, IT-Beratung (allg.), Design (allg.)

7/2000 – 7/2008

Designed and installed and manage the Sybase environment for management and replication of ultra high net worth Family Office Sybase installation on Sun Solaris requiring high security encryption and SSL features. I managed over 20 environments of Very Large Databases. For the Family Office ongoing critical project, I received the Fidelity World Class Award.
Designed and wrote the Fidelity Investments wide Sybase auditing procedures for capture of system administrator actions to Oracle data warehouse. Also managed and implemented the TOA archiving procedures.
Designed and implemented the integration of Reuters upgrades/downgrades feeds into Fidelity Investments local databases written in Transact-SQL.
Migrated Sybase 11.0. Servers to Sybase ASE 15 with minimal impact to the applications.
Managed the conversion of IMS high net work customer database system by offshore resources to Oracle.
Designed architecture and managed the installation of Sybase HA with Solaris clustering.
As an in-house expert on Sybase products, I replaced most of the vendor supplied technical support functions, providing technical assistance to Sequoia developers in the creation of efficient queries, to team management on the backup and database consistency checks to provide for greater system availability.
Managed the re-architecture and migration of the IRA management systems to higher capacity hardware. I received the Fidelity Investments Presidents Award for the successful completion of this project.

Oracle (allg.), Sybase, SQL, Datenbankadministration, Hardware Entwicklung, IT Sicherheit (allg.), Oracle Solaris (SunOS), .Net, IT-Support (allg.), Migration, Back up / Recovery

7/1996 – 7/1999

Performed consulting, major upgrades, performance tuning and re-architecture of Sybase systems for many European clients, including Renault Credit, Union Bank Switzerland in Basel, UBS Warburg in Zurich, JP Morgan Chase in Geneva, Banque du Luxembourg, and many more.
Within the Zurich classroom setting, I trained over 200 students in the use of Relational Databases, performance and Tuning, Database Administration, Application Development with SQL, Client Server Technologies, etc. These clients consisted of Project Managers, Application Developers, and other technical personnel. All training was delivered in German language.
I trained database administrators for the United Nations Office in Vienna, Austria at the local Austrian Sybase Center in Advanced Sybase administration techniques.
Supported partner software developers in Ukraine in support of offshore development with Sybase database expertise.
Performed client consulting at such corporations as Gateway, Inc., as well as for the state government of Colorado.
For US West (now Qwest), I migrated existing Sybase 4.9.2 database servers to ASE 11.5, a leap of 4 major releases with virtually no down time and without errors.
For Polkomtel GSM in Warsaw, Poland, I managed the Sybase ASE 11.0 Database Servers, performing all essential DBA tasks (including upgrades, migrations, patching), and interviewed, hired and trained a local Polish DBAs.

7/1995 – 7/1996

Managed the database implementation and administration of the Lawson Universe business software into the Sybase environment on IBM AIX servers for a massive catalog and customer fulfillment program for the Sears 1995 Wishbook.
Sybase 4.9,2 to 10 Migration
IBM AIX

1/1995 – 6/1995

Created tools to manage a worldwide network of over 100 Sybase database servers using C and UNIX shell scripts.  Developed stored procedures with Transact-SQL

10/1993 – 11/1994

Created a knowledge base management framework and user interface in support of nuclear weapons destruction inspection and verification projects.

7/1989 – 5/1993

In connection with the replacement of a mainframe based l designed and implemented and managed the implementation of the interface between the Honeywell mainframe logistical systems and the replacement client server based system.
Administered Sybase Databases (4.9.2) for the HQ of the US European command.
To improve development outcomes used Agile like Whirlpool Development Model/Rapid Prototyping (backend Sybase SQL Server version 4.9.2, Solaris 1.0 on SPARC, C).
Modeled command organizations with Entity Relationship Diagramming, Data Flow Diagramming).
Administered the local office Sun servers and Sybase databases.
Built a system for testing military Air Traffic Controllers using COBOL on the Honeywell 6000 Mainframe, improving the pass/fail rate ratio for new controllers by 27%
Created management information reports for supply/logistical requirements for the US Air Force, Europe, using the Selective Inquiry System, a locally developed report creation tool and C, for which I was awarded a special letter of commendation by the Deputy Chief of Staff of Plans, USAF.
Ported a mainframe weather forecasting module to the PC-DOS environment in C, cutting the maintenance expenses for the US Army HQ in Europe by 95%.
Wrote resource tracking software for the Transportation Command using COBOL, C, and IDS databases on the Honeywell mainframe and Level-6 mini computers.

Transact-SQL (T-SQL)