Previous Job
Previous
Unisys OS2200 Database Consultant
Ref No.: 17-01166
Location: Harrisburg, Pennsylvania
Position Type:Contract
Start Date: 02/23/2017
  • This position description is for an on-site consultant who would provide design support and maintenance for the customer's Client OS2200-based hierarchical (DMS) and relational databases (RDMS).
  • Client OS2200 hierarchical (DMS) databases conform to CODASYL network database standards.
  • Client OS2200 relational (RDMS) databases are compliant with SQL standards.
  • This position will be on-site working with the customer's IT staff in their offices in Harrisburg, PA.
  • The candidate selected for this position will provide support for OS2200 logical and physical database design and maintenance and review and prepare for growth of OS2200 databases.
  • This consultant would also be called upon to develop special utility programs for database maintenance.
  • The types of database maintenance to be performed include the addition, modification, or deletion of database records and the addition, modification, or deletion of fields in database records.
  • Other database maintenance areas would involve the analysis and addition of access mechanisms to improve the performance of database queries.
  • Coordination of the data dictionary for the Client OS2200 databases would also be required.
The following list includes the job responsibilities for this consultant position:
  • Perform logical database design for Client OS2200 DMS hierarchical databases.
  • Perform physical database design for Client OS2200 DMS hierarchical databases.
  • Code and interpret schemas for Client OS2200 DMS hierarchical databases.
  • Code and interpret subschemas for Client OS2200 DMS hierarchical databases.
  • Perform database reorganizations for Client OS2200 DMS hierarchical databases.
  • Perform logical database design for Client OS2200 RDMS relational databases.
  • Perform physical database design for Client OS2200 RDMS relational databases.
  • Code and interpret schemas for Client OS2200 RDMS relational databases.
  • Code and interpret subschemas for Client OS2200 RDMS relational databases.
  • Create COBOL programs to perform database unloads and reloads, as needed, for Client OS2200 DMS and RDMS database maintenance functions.
  • Create hierarchical (DMS) database maintenance and reorganization routines, as needed, using I-QU PLUS-1 software from KMSYS Worldwide Inc.(http://www.kmsys.com).
  • Create hierarchical (DMS) database maintenance routines, as needed, using Client OS2200 DMU and DRU utilities.
  • Coordinate and maintain the data dictionary using the Client UREP products.
  • Proactively monitor the sizes of Client OS2200 DMS and RDMS databases and proactively develop and execute plans to increase sizes of databases and make recommendations on purge and archive processes to deal with the removal of old records.
  • Proactively monitor Client OS2200 DMS DARP and SARP page usage for handling the storage of additional records onto overflow pages.
  • This is critical so that there is always a sufficient amount of overflow pages to handle the requirements of the customer's mission-critical applications.
  • Perform capacity planning for Client OS2200 DMS and RDMS databases to plan for disk storage capacity to meet the needs of current and upcoming applications.
  • This is also critical to help ensure that sufficient lead time is availalble for funding, purchasing, and preparing additional disk storage.
  • Assist in diagnosing and addressing application issues in COBOL programs that use Client OS2200 DMS and RDMS databases.
  • Based on the nature of the application issues and the impacts to the database design and integrity, this consultant will be called upon to develop automated processes to identify and correct the impacted fields in database records and relationships between records.
  • The COBOL programs may perform transaction processing or batch processing.
  • Familiarity with both transaction and batch processing is critical.
  • The customer also has a large number of Windows-based custom-built .NET multi-tier applications that integrate with the Client OS2200 COBOL applications and DMS and RDMS databases.
  • Familiarity with distributed transaction processing based on the x/Open model and standard is critical.
  • Be proficient in the use of the DBE (Database Editor) utility for performing analysis and maintenance of Client OS2200 DMS databases.
  • This consultant will be required to work non-standard hours, on occasion, to complete some of the migration work to avoid disrupting users or systems during the normal business day.