Jürgen Bargmann

Services / Areas Of Expertise

• 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 Processes To Streamline Operational Tasks
• Migration: System Migrations, Software Migration, Database Migration And Software Deployment For Large Volumes (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 Completed Work
• Training: Conducting Training And Workshops For Operating Systems, Database Systems And Programming Languages; Creating Training Concepts And Materials

Languages (Programming And Scripting Languages)

• Focus: Unix Shell Scripts (Bourne, Korn, Bash), Sql, Perl, C, Awk
• Past: 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
• Past: 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

• Focus: Ca Autosys (Versions 4.5 And 11, Jil)
• Oracle Scheduler (Job Chains)
• Connect:direct
• Others: Uc4, Tws/z, Tws/d

Operating Systems / San

• Focus: Unix, Solaris, Linux
• Basic Knowledge: Z/os
• Past: 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

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

Selection Of Self-made Tools – Oracle

• Program To Execute Any Sql Statements On Any Number Of Databases, Collect Results And Present Them In Report Form Including Full Logging; Used For Ad Hoc Queries And Creating Automated Operating State Histories Including Archiving In A Monitoring Database (Perl)
• Graphical Display 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)

Selection Of Self-made Tools – Oracle Dbms Scheduler

• Display Of Operating Status Of Job Chains (Text Output) (Pl/sql)
• Display Of Operating Status Of Job Chains (Graphics) (Pl/sql, Graphviz)
• Display Of Data Structures Of Job Chains (Pl/sql)
• Procedures For Creating And Modifying Jobs In Job Chains (Pl/sql)

Selection Of Self-made Tools – Ca Autosys

• Automatic Conversion Of Business Department Requirements From Excel To Jil (Ksh)
• Process For Concurrent Multiple Execution Of Autosys Jobs (Emulating ‘Plans’ Of Other Scheduling Systems) (Jil, Bash)
• Critical Path Analysis (Text Output) (Ksh)
• Critical Path Analysis (Data Collection In Oracle Database) [Collaboration] (Ksh, Perl)
• Critical Path Analysis (Graphical Presentation) [Collaboration] (Apex)
• Query Of The Autosys Oracle Database For Statistical Purposes, Monitoring And Detecting Irregularities In Job Definitions (‘Anomaly Reports’) (Sql*plus, Bash, Excel)
• Timeline Display Of All Scheduled Job Starts In Chronological Order (Ksh)
• Automatic Execution Of Individual Jobs In Sequence Regardless Of Their Conditions (Ksh)
• Various Tools For Semi-automated Editing Of Autosys Jobs Including Change Logging, E.g. Job Status Overview (Ksh, Bash)
• Training Materials For Autosys (Word, Excel, Powerpoint)

Selection Of Self-made 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 Display Of Operating Status Of Tws/z Applications (Perl, Graphviz)

Selection Of Self-made Tools – Connect:direct

• Conversion Of Connect:direct Log Files Into More Readable And Automatically Analyzable Tables; Filters For Versatile Use On The Command Line (Perl)

Selection Of Self-made Tools – Leasman

• Program For Automatic Deployment Of Releases Including Monitoring (Perl, Bash)
• Programs To Simplify And Accelerate Administrative Tasks In Leasman (Sap Interface, Version Status Displays Etc.) (Pl/sql)

Looking Beyond

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