AS/400 Developer
- VRK IT VISION
1 Days Ago
55-60 per Hourly
W2, C2C, 1099
Oklahoma City-OK
8-13 Years
Required Skills: Oracle Cloud ERP, business & functional analysis, complex ERP environments, GL, AR, AP, Fixed Assets, Cash Management & Procure-to-Pay, accounting, auditing, P&L, balance sheets, ERP accounting concepts, Oracle Integration Cloud, OIC, OIC-based integrations, SQL, Oracle Cloud ERP tables, Oracle Cloud ERP schemas
Job Description
Position Overview
The Office of Management and Enterprise Services (OMES), in coordination with the Oklahoma Insurance Department (OID), is seeking an experienced, high-caliber AS400 Developer/Admin for a long-term contract engagement. This critical resource will provide essential application maintenance, database management, and application-level administration services for OID’s core IBM AS/400 (IBM i Series) environment.
Because the underlying AS/400 hardware partition, operating system, and baseline infrastructure are fully hosted and managed by an external provider, this position does not require hardware or OS-level systems engineering. Instead, the contractor will focus on application development, software support, database management, and serving as the technical liaison to Ensono for environment-level modifications.
Additionally, the contractor will play a key role in assisting state IT leadership with database extraction, documentation of legacy business logic, and support for ongoing cloud migration and data archiving initiatives.
Key Responsibilities
1. Legacy Application Maintenance & Support
Maintain, modify, and optimize custom legacy application code written in RPG, RPG III, RPG
Update existing logic to adapt to regulatory changes, licensing requirements, and agency business process updates.
2. Application Administration & Infrastructure Liaison
Serve as the primary technical point of contact to coordinate with the hosting provider for system maintenance, OS patching schedules, database utilities, and environmental adjustments.
Manage application-level security configurations, including user profiles, object-level authority, and verify system audit logs (QAUDJRN) to maintain system integrit
3. DB2 Database & Integration Management
Query, manage, and tune DB2 for i databases, optimizing SQL queries and indexes to ensure database responsiveness.
Support secure, automated file transfers (SFTP/FTP) and interfaces between the hosted AS400 partition and downstream state, regional, or partner systems.
4. Modernization & Migration Enablement
Cooperate with state database administrators and cloud architects to extract, clean, and archive legacy tables.
Document system flows, database schemas, and interdependencies to facilitate a seamless transition of legacy business logic to modern cloud systems.
The Office of Management and Enterprise Services (OMES), in coordination with the Oklahoma Insurance Department (OID), is seeking an experienced, high-caliber AS400 Developer/Admin for a long-term contract engagement. This critical resource will provide essential application maintenance, database management, and application-level administration services for OID’s core IBM AS/400 (IBM i Series) environment.
Because the underlying AS/400 hardware partition, operating system, and baseline infrastructure are fully hosted and managed by an external provider, this position does not require hardware or OS-level systems engineering. Instead, the contractor will focus on application development, software support, database management, and serving as the technical liaison to Ensono for environment-level modifications.
Additionally, the contractor will play a key role in assisting state IT leadership with database extraction, documentation of legacy business logic, and support for ongoing cloud migration and data archiving initiatives.
Key Responsibilities
1. Legacy Application Maintenance & Support
Maintain, modify, and optimize custom legacy application code written in RPG, RPG III, RPG
Update existing logic to adapt to regulatory changes, licensing requirements, and agency business process updates.
2. Application Administration & Infrastructure Liaison
Serve as the primary technical point of contact to coordinate with the hosting provider for system maintenance, OS patching schedules, database utilities, and environmental adjustments.
Manage application-level security configurations, including user profiles, object-level authority, and verify system audit logs (QAUDJRN) to maintain system integrit
3. DB2 Database & Integration Management
Query, manage, and tune DB2 for i databases, optimizing SQL queries and indexes to ensure database responsiveness.
Support secure, automated file transfers (SFTP/FTP) and interfaces between the hosted AS400 partition and downstream state, regional, or partner systems.
4. Modernization & Migration Enablement
Cooperate with state database administrators and cloud architects to extract, clean, and archive legacy tables.
Document system flows, database schemas, and interdependencies to facilitate a seamless transition of legacy business logic to modern cloud systems.
Required Skills & Qualifications
Experience: Minimum of five (5) years of hands-on experience in AS400 (IBM i)
Experience: Minimum of five (5) years of hands-on experience in AS400 (IBM i)
