Application Development AS400 Developer / Administrator

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.

• 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

• Growth opportunity within a fast-scaling federal IT firm
• Direct impact on citizen-facing federal programs
• Competitive benefits including 401k, health insurance, Paid Time Off, Life Insurance and others - customize per role/location
• Veteran-friendly (V3) workplace culture

Varmoda is a federal IT solutions provider founded in 2020 and headquartered in McLean, Virginia, delivering citizen-centric public services across Financial Assistance, Public Benefits, and Security & Defense domains. Our five-layer architecture - Salesforce (Engagement), Databricks (Data), ServiceNow (Orchestration), Pega (Decisioning), and Oracle HR (Capacity) - puts data at the common thread of every solution we build for federal agencies and the citizens they serve. Varmoda holds CMMI Maturity Level 3, ISO 9001, ISO 20000, and ISO 27001 certifications, and is recognized as a V3 veteran-friendly employer.