Application Development

Tri-Force Consulting Services, Inc.; Oklahoma City (OK); Hybrid; USD 90,000 - 110,000; Full time

Job summary

Tri-Force Consulting Services, Inc. is seeking an experienced AS/400 Developer/Admin to support the Oklahoma Insurance Department’s IBM i environment.

The role combines application maintenance, database management, and security administration in a hybrid work setting. You will work with RPG IV, RPGLE, CL, and SQL on DB2 for i, coordinate with hosted providers, tune database performance, manage file transfers, and assist with disaster recovery testing and security auditing.

Qualifications

• 5+ years in AS/400 development and support.
• Proficiency in RPG IV, RPGLE, CL, and SQL on DB2 for i.
• Experience with hosted/managed AS400 environments.
• Experience in IBM i work management and security configurations.
• Experience with file transfer automation (FTP, SFTP).

Responsibilities

• Legacy application maintenance and support.
• Modify and optimize RPG/CL/SQL code for regulatory changes.
• Coordinate with hosting provider for maintenance and OS patches.
• Manage DB2 for i databases and optimize queries.
• Ensure security configurations and audit logging are maintained.
• Oversee backups, DR testing, and interfaces with partner systems.

Skills

AS/400 development

RPG IV (ILE RPG)

RPGLE

CL

SQL on DB2 for i

FTP/SFTP

Application security

Hosting coordination

Job description

Contract | Tri-Force Consulting Services, Inc. | United States

Posted On 09/14/2026

Job Information

IT Services

Work Experience 5+ years

NA

City Oklahoma City

State/Province Oklahoma

73101

Job Description

Job Title : Application Development

Duration : 12 Months

Notes- This is a Hybrid Role

Job 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

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