Hybrid AS/400 IBM i Developer | RPG/DB2 Expert (Contract)

Socket.dev; Oklahoma; Hybrid; USD 71,635,000 - 85,962,000; Part time

Job summary

State of Oklahoma - Government Agency is seeking a Part-time AS400 Developer/Admin for a 1-year contract in Oklahoma City with hybrid options. The role focuses on maintaining and enhancing legacy RPG/CL code, DB2 for i management, and secure integrations with hosting providers.

The candidate will coordinate OS patching, batch processing, and security configurations while working closely with hosting partners to ensure reliability and compliance, with a local presence required.

Qualifications

• 5 years of hands-on AS400 (IBM i, iSeries) development and support experience.
• Proficiency in RPG IV (ILE RPG), RPGLE, CL, and SQL on DB2 for i.
• Experience in hosted/managed AS400 environments and coordination with hosting providers (e.g., Ensono).
• Strong IBM i work management, subsystem coordination, security, and user profile management.
• Experience with file transfer automation (FTP/SFTP) and external integrations.

Responsibilities

• Maintain, modify, and optimize legacy RPG-based code (RPG, RPG III/IV, RPGLE, CL).
• Troubleshoot operational bugs, batch runs, and user-reported system issues.
• Update logic for regulatory/licensing changes and agency processes.
• Coordinate with hosting provider on OS patching, database utilities, and environment tweaks.
• Manage application security configurations, user profiles, object authorities, and QAUDJRN auditing.
• Manage local job queues, subsystems, and application schedulers.
• Coordinate with storage/backup teams for backups, DR testing, and verifications.
• Tune DB2 for i databases, optimize SQL queries and indexes.
• Support secure automated file transfers between hosted AS400 and external systems.
• Work with state DBAs and cloud architects to extract/clean/archive legacy data.
• Document system flows, schemas, and interdependencies for migration to cloud.

Job description

State of Oklahoma - Government Agency is seeking a Part-time AS400 Developer/Admin for a 1-year contract in Oklahoma City with hybrid options. The role focuses on maintaining and enhancing legacy RPG/CL code, DB2 for i management, and secure integrations with hosting providers.

The candidate will coordinate OS patching, batch processing, and security configurations while working closely with hosting partners to ensure reliability and compliance, with a local presence required.