The Role
Maintain and enhance legacy IBM i applications using RPG and CL; troubleshoot production issues; administer application security, jobs, subsystems, and schedulers; manage DB2 for i databases and integrations; coordinate hosting, backups, disaster recovery, and infrastructure support; and document legacy systems for modernization and cloud migration.
Summary Generated by Built In
Job Title : Application Development
Location : Oklahoma City
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.
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. 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. 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)
About Us:
Since 2000, Tri-Force Consulting Services (https://triforce-inc.com) has been an MBE/SDB certified IT Consulting
firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps),
systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government
and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity,
increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing
core values: integrity, diligence, and technological excellence.
Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the
Inc. 5000 list of the nation's fastest-growing companies.
Skills Required
- At least five years of hands-on AS400, IBM i, or iSeries application development and support experience
- Proficiency in RPG IV, ILE RPG, RPGLE, CL, and SQL on DB2 for i
- Experience working in a hosted or managed AS400 environment with external hosting providers
- Experience with IBM i work management, subsystem coordination, application security, and user profile management
- Strong experience with automated FTP and SFTP file transfers
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Tri-Force Consulting Services, Inc. is a U.S.-based IT consulting and staffing agency that provides comprehensive IT solutions, including AI-powered services, custom software development, cybersecurity, cloud technology, and IT staffing to government and commercial sectors.
