Application Development AS400 Developer / Administrator

Varmoda•Oklahoma City, OK

12d•Onsite

About The Position

The Oklahoma Insurance Department (OID), in partnership with the Office of Management and Enterprise Services (OMES), is seeking an experienced AS400 Developer / Administrator to support and maintain critical legacy applications and databases within the agency's IBM AS/400 (IBM iSeries) environment. This role will provide application development, maintenance, administration, database management, integration support, and modernization assistance for business-critical systems. The successful candidate will serve as the primary technical resource responsible for supporting RPG-based applications, DB2 databases, application security, data integrations, job scheduling, and migration preparation activities to support future modernization efforts.

Requirements

Minimum 5 years of hands-on experience supporting IBM AS/400 (IBM i / iSeries) environments.
Strong development experience with: RPG IV (ILE RPG), RPGLE, CL (Control Language), SQL.
Experience administering and supporting IBM i business applications.
Experience with: DB2 for i, Query Development, Database Optimization, Performance Tuning.
Experience managing: User Profiles, Security Permissions, Object Authorities, System Auditing.
Experience troubleshooting and supporting production systems.
Experience supporting: FTP, SFTP, Automated File Transfers.
Experience working in hosted or managed AS400 environments.
Strong analytical and problem-solving capabilities.
Excellent communication and documentation skills.

Nice To Haves

Experience working with external hosting providers and managed infrastructure environments.
Experience coordinating disaster recovery and backup validation activities.
Experience supporting modernization or cloud migration initiatives.
Experience documenting legacy systems and technical architectures.
Familiarity with enterprise integration and data migration strategies.
Experience supporting government, insurance, or public-sector environments.
IBM i Administration Certification
IBM DB2 Certification
RPG Programming Certification
ITIL Foundation Certification

Responsibilities

Maintain, enhance, and support legacy business applications developed using: RPG, RPG III, RPG IV (ILE RPG), RPGLE, CL (Control Language)
Troubleshoot production issues, batch processing failures, and user-reported defects.
Modify application logic to support business, regulatory, licensing, and compliance changes.
Perform application debugging, testing, deployment, and post-implementation validation.
Serve as the primary point of contact between OID and the hosting provider.
Coordinate Operating System Maintenance, Patch Management, Database Utilities, Environment Changes.
Manage application security including: User Profiles, Object-Level Security, Access Controls, Audit Log Review (QAUDJRN).
Support: Job Queues, Active Subsystems, Application Scheduling Processes.
Coordinate backup, recovery, disaster recovery testing, and restoration validation activities.
Administer and maintain DB2 for i databases.
Develop and optimize SQL queries and indexes to improve application performance.
Perform database troubleshooting, maintenance, and performance tuning.
Support secure file transfer processes using: FTP, SFTP.
Maintain integrations with internal and external partner systems.
Partner with database administrators, infrastructure teams, and cloud architects.
Support legacy data extraction, cleanup, archival, and migration activities.
Document: System Architecture, Data Flows, Database Schemas, Application Dependencies, Integration Processes.
Assist with modernization initiatives and migration planning activities.