US-SC-Columbia: Database Administrator

To see other opportunities, please visit http://dba.fyicenter.com/
Date: 21-May-2008

Database Administrator

Job description: Will assist DB2 DBA staff as needed in project planning, consulting, and migration support for a migration of the State of South Carolina DB2 for z/OS Version 7 environment to DB2 for z/OS Version 8.

There are six non-SAP subsystems remaining that need to be migrated to Compatibility Mode. Three of the subsystems support CICS, batch, and Java/Websphere applications and three support a three-tier distributed client/server application running on Windows Citrix servers connecting via DB2 Connect.

There are three SAP subsystems that need to be migrated to Version 8 New Function Mode. The SAP application is at version 4.6C and runs on AIX servers connecting to DB2 for z/OS via the ICLI interface. The latest Consolidated Service Test Level and Version 7 fallback maintenance still needs to be applied to the SAP subsystems and assistance is also needed to determine and make any changes required to the SAP application and/or server environment to support DB2 Version 8.

The three SAP subsystems and the three subsystems that support the distributed applications are running on a separate LPAR under the z/OS.e (soon to be NALC) version of the operating system.

Work will also include preparation for the possibility of SQL access path degradation involving both static and dynamic SQL. Most of the dynamic SQL is issued by the large OLTP three-tier distributed application written in Borland**s DELPHI running on Windows Citrix servers that accesses DB2 for z/OS via DB2 Connect ODBC. Parts of this application have also been written in C# using the .NET development framework.

We also need assistance in making sure the DB2 Connect Enterprise Edition Version 8 and Version 9 environments are optimally configured for the current DB2 for z/OS Version 7 subsystems and document any configuration changes needed when the z/OS subsystems migrate to Version 8, examining all the APARs in all the FIXPAKs for Versions 8 and 9 to check for any needed additional actions relating to fixes. This is to include any changes needed on the DB2 Connect clients.

We also need help in testing Java applications accessing DB2 from WEBSPHERE using JDBC drivers that are different from the ones provided by IBM DB2.

Will also assist in the correct setup for DB2-related OMVS Unix System Services HFS files and OMVS configuration parameters for running multiple subsystems, some at Version 8 and some at Version 7.

To apply for this position, please visit this Website.

Thank you,
DBA FYI Center
http://dba.fyicenter.com/