Application Development AS400 Developer
- AS400
- DB2
- Disaster Recovery
- SQL
- FTP
- SFTP
AS400 / IBM i Developer & Application Administrator
Location: Oklahoma City, OK – Hybrid
Position Type: Contract
Duration: 12 Months, with strong possibility of extension
Schedule: 20 hours per week
Work Location:Â Oklahoma City, OK 73105
Position Overview
The client is seeking an experiencedAS400 / IBM i Developer & Application Administrator to support legacy applications and databases within the Oklahoma Insurance Department (OID) environment.
The successful candidate will be responsible forRPG/RPGLE application development and maintenance, production support, DB2 for i database activities, application-level IBM i administration, and system integrations.
The underlying IBM i infrastructure and operating system are hosted and managed by an external provider. Therefore, this position focuses primarily onapplication development, application support, database management, and coordination with the hosting provider rather than hardware or OS-level infrastructure administration.
Key Responsibilities
Legacy Application Development & Support
-
Maintain, modify, enhance, and troubleshoot legacy applications developed usingRPG, RPG III, RPG IV/ILE RPG, RPGLE, and CL/CLLE.
-
Investigate and resolve application defects, production issues, batch processing problems, and user-reported issues.
-
Modify existing application logic to support regulatory, licensing, and business process changes.
-
Analyze existing legacy code and business logic to identify root causes and implement appropriate solutions.
IBM i Application Administration
-
Support application-level administration within the IBM i environment.
-
Manage user profiles, object-level authorities, and application security configurations.
-
Review IBM i audit information, includingQAUDJRN, as needed for troubleshooting and security verification.
-
Monitor and manage application jobs, job queues, subsystems, and scheduling activities.
-
Coordinate with the external hosting provider regarding system maintenance, environmental changes, and infrastructure-related issues.
-
Assist with backup, disaster recovery, and restoration verification activities.
DB2 for i & Integration
-
Develop and executeSQL queries against DB2 for i.
-
Troubleshoot and optimize database queries and indexes where appropriate.
-
Support application interfaces and automated file transfers usingFTP/SFTP.
-
Troubleshoot data exchanges between IBM i applications and external/state systems.
Modernization & Data Migration Support
-
Assist with extracting, cleaning, and archiving data from legacy IBM i databases.
-
Document application workflows, database structures, dependencies, and legacy business logic.
-
Support database and cloud teams during legacy application modernization and migration initiatives.
-
Help identify application and data dependencies that may impact migration activities.
Required Qualifications
-
5+ years of hands-on experience developing and supporting applications onAS400 / IBM i / iSeries environments.
-
Strong hands-on experience withRPG IV, ILE RPG, RPGLE, and CL/CLLE.
-
Strong experience withDB2 for i and SQL.
-
Experience troubleshooting production applications, batch jobs, and legacy application issues.
-
Experience with IBM i application administration, includingjobs, job queues, subsystems, user profiles, and object-level security.
-
Experience withFTP/SFTP and application integrations.
-
Experience working with hosted or managed IBM i environments and coordinating with external infrastructure/support teams.
Preferred Qualifications
-
Experience supportinglegacy-to-cloud migration, data extraction, or data archiving initiatives.
-
Experience withRational Developer for i (RDi).
-
Experience working with state government, public-sector, insurance, or regulatory applications.
-
Experience documenting legacy application architecture, business rules, and database dependencies.
-
Familiarity with IBM i backup, disaster recovery, and restoration processes.
Work Environment
-
Hybrid position based inOklahoma City, Oklahoma.
-
Candidates should be local to the Oklahoma City area or willing to relocate to meet the hybrid work requirements.
-
Position requires approximately20 hours per week.
Application Development AS400 Developer · LanceSoft Inc