> Markdown version of [/jobs/ext/3381754-application-development-as400-developer-administrator](https://www.wearedevelopers.com/jobs/ext/3381754-application-development-as400-developer-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Application Development AS400 Developer / Administrator - **Company:** Varmoda Tech LLC - **Location:** Oklahoma City, OK, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Db2400, Os/400 Operating System, Business Logic, Application Performance Management, IBM System I, Audit Trail, Batch Processing, Business Software, Databases, Data Integration, Data Migration, Data Mining, IBM DB2, Database Schema, Software Debugging, Disaster Recovery, File Transfer, IBM RPG (Programming Language), Job Scheduling, Performance Tuning, Queueing Systems, Standard Sql, Software Engineering, SQL Databases, Data Streaming, Subsystems, RPL (Programming Language), Systems Architecture, Systems Integration, File Transfer Protocol (FTP), Database Optimization, Software Security, Control Language, Patch Management, Enterprise Integration, Cloud Migration, Legacy Systems, Database Tools and Utilities - **Published:** September 16, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=fa76c6290fc45024 ## About the Role * 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., * 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, regulatory, insurance, or public-sector environments. Certifications & Clearance Preferred Certifications * IBM i Administration Certification * IBM DB2 Certification * RPG Programming Certification * ITIL Foundation Certification Compliance Requirements * Agency must maintain and provide proof of $5 Million Cyber Insurance Coverage. * Work involves High Data Sensitivity information and requires adherence to strict security and confidentiality standards. Clearance * Must satisfy Oklahoma state onboarding and security requirements., * RPGLE * RPG IV (ILE RPG) * CL (Control Language) * SQL on DB2 for i * IBM AS/400 / IBM iSeries * FTP / SFTP * Application Administration * Security Management * Job Queue Management * Legacy Application Support * DB2 Performance Tuning ## Description 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., Legacy Application Development & Support * 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. Application Administration & Infrastructure Coordination * 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. DB2 Database Administration & Integration Support * 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. Modernization & Migration Support * 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.