AS400 Developer

Cays Inc; Oklahoma City (OK); On-site; USD 90,000 - 120,000; Full time

Job summary

Cays Inc in Oklahoma City seeks an experienced AS400/IBM i developer to maintain and modernize legacy applications. You will work with RPG IV, RPGLE, CL and SQL on DB2 for i, in a hosted/managed environment, coordinating with hosting providers and ensuring security, job scheduling, and backups.

Strong familiarity with FTP/SFTP and disaster recovery testing is a plus for this role. The position requires hands-on experience in IBM i administration and system integration tasks.

Qualifications

• Five+ years of AS400 (IBM i) development and support.
• Proficiency in RPG IV, RPGLE, CL, and SQL on DB2 for i.
• Experience with hosted/managed AS400 environments.
• IBM i work management, subsystems, and security administration.
• Strong file transfer automation (FTP/SFTP) background.

Responsibilities

• Maintain, modify, and optimize legacy RPG/CL code.
• Investigate and troubleshoot operational bugs and batch issues.
• Coordinate hosting provider maintenance and environmental changes.
• Manage IBM i work management, subsystems, and security.
• Ensure backups and DR testing in coordination with hosting teams.

Skills

RPG IV

RPGLE

CL

SQL DB2/i

IBM i admin

Hosted AS/400

FTP/SFTP

Work management

Security auditing

Job description

Key Responsibilities

• 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.

• 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.

• 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.

• 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)