Jürgen Bargmann-Database Administrator and Performance Tuning Specialist

Services / Specialties

• Databases: Administration, Design, Tuning, Application Development For Oracle Databases
• Operating Systems: Unix, Solaris, Linux, Windows
• Job Scheduling: Ca Autosys, Oracle Scheduler (Job Chains), Tws/Z, Tws/D
• Automation: Creating Procedures To Streamline Operational Tasks
• Migration: System Conversions, Software Migration, Database Migration, And Software Deployment At Large Scale (Concept And Implementation)
• Visualization: Automated Graphical Presentation Of Technical Data
• Programming: C, Unix Shell Scripts, Perl, Pl/Sql, Others
• Programming Of Technical-Scientific Algorithms
• Documentation Of Work Performed
• Training: Conducting Trainings And Workshops For Operating Systems, Database Systems, And Programming Languages; Creating Training Concepts And Materials

Languages (Programming And Scripting)

• Main: Unix Shell Scripts (Bourne, Korn, Bash), Sql, Perl, C, Awk
• Former: Various Assemblers, Various Basic Dialects, Fortran, Pascal, Modula, Lisp, Forth, Prolog, Simscript, Dbase/Clipper, Rexx, Vba, C++, Java

Databases

• Oracle (Focus): Administration Of All Versions From 5 To 21c
• Oracle: Programming With Pl/Sql
• Oracle Tools: Rman, Data Pump, Advanced Queue, Scheduler (Job Chains), Odi, Oms, Sql*Loader, Toad, Sql Developer
• Former: Dbase Ii, Iii+, Iv, Clipper S87, 5.0
• Informix: Administration Of All Versions From 4 To 7
• Informix: Programming With 4gl, E/Sql-C
• Oracle Development: Designer, Discoverer, Forms, Reports
• Oracle Tools: Grid Control
• High Availability: Rac, Data Guard

Job Scheduling And Data Transfer

• Main: Ca Autosys (Versions 4.5 And 11, Jil)
• Oracle Scheduler (Job Chains)
• Connect:Direct
• Others: Uc4, Tws/Z, Tws/D

Operating Systems / San

• Main: Unix, Solaris, Linux
• Basic Knowledge: Z/Os
• Former: Novell Netware 2.X, 3.X, 4.X; Os/2, Lan Manager; Xenix, Dec Osf/1, Hp-Ux, Sinix, Sco Unix
• Veritas: Vxfs, Vxvm 3.X, 4.X
• Ms-Dos All Versions, Windows All Versions Up To 11

Software Distribution / Management

• Former: Oma (Arosoft), Simm (Sysping), Ibm Tivoli

Selected Custom Tools – Oracle

• Program To Execute Arbitrary Sql Statements On Any Number Of Databases, Collect Results And Present Them In Report Form With Full Logging; Used For Ad-Hoc Queries And For Creating Automated Operational History With Archiving In A Monitoring Database (Perl)
• Graphical Representation Of Privilege Relationships In The Oracle Database (System Privileges, Object Privileges, Roles, Schemas, Users) (Pl/Sql, Graphviz)
• Monitoring Statements For Debezium Including Graphical Presentation (Sql)

Selected Custom Tools – Oracle Dbms Scheduler

• Display Of Job Chains Status (Text Output) (Pl/Sql)
• Display Of Job Chains Status (Graphic) (Pl/Sql, Graphviz)
• Display Of Job Chains Data Structures (Pl/Sql)
• Procedures To Create And Modify Jobs In Job Chains (Pl/Sql)

Selected Custom Tools – Ca Autosys

• Automatic Conversion Of Business Requirements From Excel Into Jil (Ksh)
• Procedures For Simultaneous Multiple Execution Of Autosys Jobs (Simulating "Plans" Of Other Scheduling Systems) (Jil, Bash)
• Critical Path Analysis (Text Output) (Ksh)
• Critical Path Analysis (Data Collection In Oracle Database) [Contribution] (Ksh, Perl)
• Critical Path Analysis (Graphical Presentation) [Contribution] (Apex)
• Querying The Autosys Oracle Database For Statistical Purposes, For Monitoring, And To Detect Irregularities In Job Definitions ("Anomaly Reports") (Sql*Plus, Bash, Excel)
• Timeline Display Of All Scheduled Job Starts In Chronological Order (Ksh)
• Automatic Sequential Execution Of Individual Jobs Regardless Of Their Conditions (Ksh)
• Various Tools For Semi-Automated Editing Of Autosys Jobs Including Logging Of Changes, E.G., Job Status Overview (Ksh, Bash)
• Training Materials For Autosys (Word, Excel, Powerpoint)

Selected Custom Tools – Migration Ca Autosys -> Ibm Tws/Z

• Conversion Of Autosys Boxes And Jobs Into Tws/Z Applications And Operations From Jil To Batchad Format (Ksh, Perl)
• Graphical Representation Of The Status Of Tws/Z Applications (Perl, Graphviz)

Selected Custom Tools – Connect:Direct

• Conversion Of Connect:Direct Log Files Into More Readable And Automatically Parsable Tables; Filters For Versatile Command-Line Use (Perl)

Selected Custom Tools – Leasman

• Program For Automatic Release Deployment Including Monitoring (Perl, Bash)
• Programs To Simplify And Speed Up Administrative Tasks In Leasman (Sap Interface, Version Status Reports, Etc.) (Pl/Sql)

Outside Interests

• Mathematics
• Electronics
• Printing Technology, Dtp
• Cryptography
• Forensics (File Systems)
• Accessible Web Design
• Simulations
• 3d Visualization
• Fuzzy Logic
• Genetic Algorithms