Application Development AS400 Developer (IBM, i Series) - Part-Time in Oklahoma - Hybrid/REMOTE

RICEFW Technologies Inc; Oklahoma City (OK); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Office of Management and Enterprise Services (OMES) seeks an experienced AS/400 Developer/Administrator for a long-term contract with the Oklahoma Insurance Department. The role covers maintenance, database management, and application administration on the IBM i environment.

Key duties include legacy RPG/CL code maintenance, DB2 for i query tuning, security configuration, and coordinating with external hosting providers for patching, backups, and disaster recovery testing.

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 with hosted/managed AS400 environments.
• Experience in IBM i work management, subsystems, and security.

Responsibilities

• Legacy Application Maintenance & Support for RPG/CL on AS/400.
• Coordinate hosting provider activities for OS patching and environments.
• Manage DB2 for i databases, tuning SQL queries and indexes.
• Document system flows and interdependencies for cloud migrations.

Skills

AS400 IBM i

RPG IV

RPGLE

CL

SQL on DB2 for i

FTP/SFTP

Hosting coordination

Application administration

DB2 for i tuning

Job description

Location & Schedule:- Oklahoma City/Hybrid Remote M-F 20 hrs a week

Timeline & Interview Process:- 1 round Teams Video call - 30 mins (Technical/Cultural FIT to OID), if needed, maybe a second round for the shortlisted candidates

Description

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.

Key Responsibilities

1. 1. Legacy Application Maintenance & Support
   • 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.
2. 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 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.
3. 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. 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.

Requirements

• Experience: Minimum of five (5) years of hands-on experience in AS400 (IBM i, iSeries) application development and support.
• Programming Skills: Exceptional proficiency in RPG IV (ILE RPG), RPGLE, CL, and SQL on DB2 for i.
• Hosting Coordination: Prior experience working in a hosted/managed AS400 environment, collaborating with external hosting providers to resolve infrastructure or environmental issues.
• Application Administration: Proven experience in IBM i work management, subsystem coordination, application security, and user profile management.
• Data Integration: Strong background in file transfer automation (FTP, SFTP)