Year:

2014

Duration:

15 months

System environment:

Informix 11.70, Linux, Informix Warehouse, Informix Warehouse Accelerator, Reporting-/Analysis Tools (Cognos/Microstrategy)

Task:

The IT Service provider belongs to a nationwide operating Finance Group and was supported in the fields of optimization of the Informix database configuration, the acceleration of OLTP processes and the configuration/administration of Informix Warehouse Accelerator.

• Reorganisation of the IBM Informix database in order to enhance and accelerate ETL-processes. Preparation and execution of
• Informix- & Workshops dealing with options regarding system enhancements and Informix high availability options

Actions:

• Extension of data storage
• Consolidation of Data marts
• Adjustments Refresh-Skripte
• Creation & evaluation I/O statistics
• Creation & evaluation of index, table, chunk I/O statistics
• Optimization PDQ, Light Scans
• Query optimization (Informix optimizer)
• Creation DBSpaces
• Creation databases
• Execution of Informix-/SQL Workshops
• System evaluation
• Presentation Informix High-Availability options (HDR, RSS, SDS)
• Implementation consulting

Year:

2016

Duration:

4 months

System environment:

IBM Power/AIX, Informix 11.70, Informix HDR, Data Warehouse/Informix Warehouse Accelerator (IWA)

Task:

The company is nationwide active retailer and was supported in analyzing and changing of the database configuration (Caching, Fragmentation, PDQ) and the programming/optimization of statements of the batch applications. The focus was on Analysis and Removal of performance bottlenecks.

Actions:

• Analysis & Adjustments in server configuration
  • Caching
  • Fragmentation
  • PDQ
• Analysis of queries & batch applications
  • Performance tuning
  • PDQ
• Optimization database design

Year:

2015

Duration:

4 months

System environment:

HP/Linux, VMware ESX, Informix 11.70, Informix High Availability Tools, Connection Manager (CM)

Task:

The nationwide active company offers project related and regular services for institutions and partners in the healthcare environment.Focus were on system design, installation & configuration services, performance tuning, Informix Workshops.

Actions:

• Design/configuration memory requirements/organisation
• Installation/configuration data base server
• Implementation High Availabiltiy Cluster (High Availability Data Replication, HDR)
• Implementation Load Balancing Connection Manager (CM)
• Implementation Backup (onbar)
• Tests ( Failover, connectivity)
• Documentation of system environment
• Preparation & realization Informix Workshops for system administrators

Year:

2017/2018

Duration:

8 month

System Environment:

• Informix IDS 12.10
• Linux
• SQL
• 4GL

Task:

The Client is a public owned bank. It's goal is to provide financial support to small and medium sized companies, housebuilding, infrastructure projects and education. The bank uses the Informix Database Server in the fields of credit rating, the maintenance and administration of the scoring platform and the corresponding reporting tools. The bank was supported in the fields of programming and testing for Informix. In this context extensive knowledge of programming, administration and configuration for Informix databases was required. 

Actions:

• IBM Informix Database Server (IDS)
• SQL coding for Informix Informix
• 4GL programming für Informix