Query optimization, index strategy, execution plan analysis, and database configuration tuning across Sybase, Oracle, and Unix environments at Chronimed, Honeywell, and Northwest Airlines.
System tuning. A review of the I/O configuration of the DEC Alpha environment resulted in the change in configuration to ensure 100% database integrity while providing optimal performance. Analysis of stored procedure logic and implementation of approved changes against the top 200 procedures of the 1,500 procedure Order Entry system. Tuning of the Sybase server took place to optimize performance against Sybase release 11.9.2.
Analysis and implementation of indexing strategy to aid the performance of the PeopleSoft application. By analyzing the key structure of the populated PeopleSoft tables, we were able to significantly increase the performance of the overall application. Also, we re-deployed PeopleSoft against its own Sybase server. At the expense of additional memory, this strategic change allows the PeopleSoft application to run against its own engine (better CPU usage), have its own dedicated segment of memory, and allows for upgrade flexibility of both PeopleSoft and/or Sybase as needed.
Honeywell, Inc.1992–1999
Developed a performance trending application custom to the client's site. This tracking tool records numerous performance measurements of IBM AIX, Sybase and application activity. The values are taken every 5 minutes and stored in the Sybase database. A Microsoft Excel spreadsheet is configured to pull the data, based on an input date, for a four week period. The data is manipulated into trending graphs (VBA with Microsoft Excel) and tables to show the performance trend of the previous four week period.
Northwest Airlines, Inc.1995–1997
Analysis of a co-existence (legacy to open systems) application led to the implementation of a physical storage layout, increasing the application performance by 12%. Behavior of the Unix system indicated the existence of an overworked single drive. Implementation of RAID 0+1 increased performance and was implemented transparent to the application.