AS400 / IBM i Application Developer

Role: Application Development AS400 Developer / Administrator
Client: Oklahoma Insurance Department (OID) / Office of Management and Enterprise Services (OMES)
Location: Oklahoma City, OK Hybrid
Schedule: Part-Time Approximately 20 hours per week
Duration: 12 Months
Experience Required: 5+ Years
Work Authorization: U.S. Citizen / Green Card / H-1B
Not Eligible: OPT / OPT EAD
Interview Process: Technical and Cultural Fit Interview Required

Position Overview

The Office of Management and Enterprise Services (OMES), in coordination with the Oklahoma Insurance Department (OID), is seeking an experienced AS400 / IBM i Developer and Application Administrator for a long-term contract engagement.

This role will support OID's core IBM AS/400 / IBM iSeries environment, with responsibility for legacy application development and maintenance, DB2 database support, application-level system administration, integrations, production troubleshooting, and modernization activities.

The ideal candidate will have strong hands-on experience with RPGLE, RPG IV/ILE RPG, Control Language (CL), DB2 for i, SQL, FTP/SFTP, and IBM i application administration.

This individual will also serve as a key technical liaison between the agency, hosting providers, infrastructure teams, database administrators, and cloud modernization teams.

Key Responsibilities

AS400 / IBM i Application Development & Maintenance

• Maintain, enhance, troubleshoot, and optimize legacy applications running within the IBM AS400 / IBM i environment.
• Develop and maintain applications using:
• RPG
• RPG III
• RPG IV / ILE RPG
• RPGLE
• Control Language (CL)
• SQL
• Analyze and resolve production defects, operational issues, batch-processing failures, and user-reported application problems.
• Modify existing application logic to accommodate:
• Regulatory changes
• Licensing requirements
• Agency policy changes
• Business process enhancements
• Perform code analysis, debugging, testing, and production support for existing AS400 applications.
• IBM i Application Administration
• Provide application-level administration and operational support within the IBM i environment.
• Manage and support:
• IBM i user profiles
• Application security
• Object-level authorities
• Job queues
• Active subsystems
• Application job schedulers
• Review and verify IBM i system audit logs, including QAUDJRN, to help maintain system and application integrity.
• Troubleshoot application-related IBM i operational issues and coordinate resolution with infrastructure teams when necessary.

Hosting Provider & Infrastructure Coordination

• Serve as a primary technical liaison between OID and its external AS400 hosting/managed-services providers.
• Coordinate activities related to:
• IBM i operating system maintenance
• OS patching
• Database utilities
• Environmental changes
• Storage operations
• Backup activities
• Disaster recovery
• System restoration
• Work closely with Ensono and other infrastructure/hosting teams to coordinate application backup windows and operational activities.
• Participate in disaster recovery testing and verify successful application and data restoration.
• DB2 for i Database Management
• Query, manage, troubleshoot, and optimize DB2 for i databases.
• Develop and execute SQL queries for application support, data analysis, troubleshooting, and integration.
• Analyze and optimize:
• SQL queries
• Database indexes
• Database access patterns
• Application/database performance
• Assist with legacy table maintenance, data extraction, cleanup, migration, and archival activities.
• File Transfer & Systems Integration
• Develop and support secure file-transfer integrations using:
• SFTP
• FTP
• Support interfaces between the hosted AS400 environment and downstream:
• State systems
• Regional systems
• Partner systems
• Third-party applications
• Troubleshoot file-transfer failures and integration-related production issues.
• Support automation of recurring data exchanges and file-transfer processes.
• Modernization & Migration Support
• Collaborate with state database administrators, application teams, and cloud architects on modernization initiatives.
• Assist with extracting, cleaning, transforming, and archiving legacy AS400 data.
• Analyze existing legacy applications and business logic to support migration to modern platforms and cloud environments.
• Document:
• Application architecture
• System workflows
• Database schemas
• Interfaces
• Application dependencies
• Business rules
• Batch processes
• Integration points
• Help identify legacy system dependencies that must be addressed during application modernization and migration.

Required Qualifications

• Minimum 5 years of hands-on experience supporting and developing applications within an IBM AS400 / IBM i / iSeries environment.
• Strong hands-on development experience with:
  • RPGLE
  • RPG IV / ILE RPG
  • Control Language (CL)
  • SQL
  • DB2 for i
• Strong experience maintaining and supporting legacy AS400 applications.
• Experience debugging RPG programs and troubleshooting production application issues.
• Hands-on experience with DB2 for i database development, queries, and performance optimization.
• Experience with IBM i work management, including:
• Subsystems
• Job queues
• Job scheduling
• User profiles
• Object authorities
• Application security
• Experience supporting file transfers and system integrations using FTP and SFTP.
• Experience working within a hosted or managed AS400 environment.
• Ability to coordinate effectively with external hosting providers and infrastructure teams when resolving environmental or system-related issues.
• Experience supporting backup, recovery, and disaster recovery activities.
• Strong troubleshooting, analytical, and problem-solving capabilities.
• Ability to document existing legacy applications, database structures, interfaces, and system dependencies.
• Strong verbal and written communication skills.
• Highly Relevant Skills
• IBM AS400 / IBM i / iSeries
• RPGLE
• RPG IV / ILE RPG
• RPG III
• Control Language (CL)
• DB2 for i
• SQL
• IBM i Application Administration
• IBM i Work Management
• Subsystems
• Job Queues
• User Profile Management
• Object-Level Security
• QAUDJRN
• SFTP
• FTP
• Batch Processing
• Application Support
• Production Support
• Legacy Application Modernization
• Data Migration
• Disaster Recovery
• Managed / Hosted AS400 Environments

Interview Process

Round 1: Approximately 30-minute Microsoft Teams video interview focused on technical qualifications and cultural fit with OID.

A second interview may be conducted for shortlisted candidates if required.

Work Schedule

This is a part-time hybrid engagement requiring approximately 20 hours per week in support of the Oklahoma City-based environment.