AS/400 IBM Developer

Qode; Oklahoma City (OK); Hybrid; USD 52,000 - 62,000; Part time

Job summary

State of Oklahoma - Government Agency is seeking an AS/400 Developer/Admin contractor for a 1-year engagement (20 hours per week) in Oklahoma City, with hybrid options available. Work authorization allowed: USC or GC only.

Responsibilities include maintaining legacy RPG/CL code, tuning DB2 for i SQL, and ensuring system security; coordinating with the hosting provider for patches and backups; managing job queues and file transfers; and documenting data flows to support modernization efforts.

Qualifications

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

Responsibilities

• Maintain, modify, and optimize legacy RPG, RPG IV, RPGLE, CL code.
• Investigate and troubleshoot operational bugs and batch anomalies.
• Update logic to adapt to regulatory/licensing changes and agency processes.
• Coordinate with hosting provider for OS patches, DB utilities, and environment changes.
• Manage application-level security configurations and audit logs.
• Handle local job queues, subsystems, and application-level schedulers.
• Coordinate with hosting/storage teams for backups and DR testing.
• Tune DB2 for i databases and optimize SQL queries and indexes.
• Support secure file transfers and interfaces with hosted AS400 partitions.
• Collaborate with state DBAs and cloud architects on data extraction and archiving.
• Document system flows and database schemas for migration to cloud.

Skills

AS/400 development

RPG IV (ILE RPG)

RPGLE

CL

SQL on DB2 for i

Hosted environment

File transfer automation

Security & user profiles

Job description

Client:State of Oklahoma - Government Agency

Job Title: AS400 Developer/Admin (Contractor)

Term: 1-year contract - 20 hours a week

Pay Rate:$50/Hr - $60/Hr

Location: Oklahoma City, OK (Hybrid options available) must be local

Work Authorization: USC or GC ONLY no other Visa considered

Scope: Looking for a PT 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.

Experience:

• 5 years of hands-on experience in AS400 (IBM i, iSeries) application development and support.
• Exceptional proficiency in RPG IV (ILE RPG), RPGLE, CL, and SQL on DB2 for i.
• Prior experience working in a hosted/managed AS400 environment, collaborating with external hosting providers (such as Ensono) to resolve infrastructure or environmental issues.
• Proven experience in IBM i work management, subsystem coordination, application security, and user profile management.
• Strong background in file transfer automation (FTP, SFTP) and managing external integrations.

Responsibilities:

• Maintain, modify, and optimize custom legacy application code written in RPG, RPG III, RPG IV (ILE RPG), RPGLE, and Control Language (CL).
• Investigate and troubleshoot operational bugs, batch run anomalies, and user reported system issues.
• Update existing logic to adapt to regulatory changes, licensing requirements, and agency business process updates.
• 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 integrity.
• Manage local job queues, active subsystems, and application-level job schedulers.
• Coordinate with Ensono’s storage and backup operations teams to ensure application backup windows, disaster recovery testing, and restoration verifications are carried out successfully.
• 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.
• 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.