AS400 Developer/Admin

Technix LLC; Oklahoma City (OK); Hybrid; USD 85,000 - 115,000; Part time

Job summary

Oklahoma Insurance Department (OID) / Office of Management and Enterprise Services (OMES) seeks an experienced AS400 Developer/Admin for a long-term contract. The role focuses on application maintenance, database management, and liaison work with the external hosting provider for the hosted IBM i environment.

Responsibilities include legacy code maintenance, security configurations, and supporting cloud migration efforts. Hybrid schedule with on-site days in Oklahoma City, OK.

Qualifications

• Minimum of five years of hands-on AS400 development and support.
• Proficiency in RPG IV (ILE RPG), RPGLE, CL, and SQL on DB2 for i.
• Experience in hosted/managed AS400 environments with external hosting providers.
• Applied knowledge of IBM i security, user profiles, and subsystem coordination.

Responsibilities

• Legacy Application Maintenance & Support: modify and optimize legacy code (RPG, RPG III/IV, RPGLE, CL).
• Application Administration & Infrastructure Liaison: coordinate with hosting provider for maintenance and patching, manage security and audits.
• DB2 Database & Integration Management: tune DB2 for i databases, optimize queries and indexes, manage file transfers.
• Modernization & Migration Enablement: document flows, assist cloud migration, archive legacy data.

Skills

RPGLE

CL

SQL on DB2

SFTP/FTP

Job description

Job ID

SW1025

Agency

Oklahoma Insurance Department (OID) / Office of Management and Enterprise Services (OMES)

Hours

20 hours per week

Special Requirements

• 1 round Teams Video call - 30 mins (Technical/Cultural FIT to OID), if needed, maybe a second round for the shortlisted candidates
• Candidates must be local to Oklahoma City or willing to relocate, as hybrid schedules require designated on-site days at Oklahoma Insurance Department or OMES facilities

Position

AS400 Developer/Admin

Duration

1 year with extension Possible

Location

Oklahoma City, OK (Hybrid)

Mandatory Skills

• RPGLE, CL, and SQL on DB2
• SFTP /FTP

Job Description

The Office of Management and Enterprise Services (OMES), in coordination with the Oklahoma Insurance Department (OID), is seeking an experienced, high-caliber AS400 Developer/Admin for a long-term contract engagement. This critical resource will provide essential application maintenance, database management, and application-level administration services for OID's core IBM AS/400 (IBM i Series) environment.

Because the underlying AS/400 hardware partition, operating system, and baseline infrastructure are fully hosted and managed by an external provider, this position does not require hardware or OS-level systems engineering. Instead, the contractor will focus on application development, software support, database management, and serving as the technical liaison to Ensono for environment-level modifications.

Additionally, the contractor will play a key role in assisting state IT leadership with database extraction, documentation of legacy business logic, and support for ongoing cloud migration and data archiving initiatives.

Responsibilities

Legacy Application Maintenance & Support

Maintain, modify, and optimize custom legacy application code written in RPG, RPG III, RPG IV (ILE RPG), RPGLE, and Control Language (CL).

Investigate and troubleshoot operational bugs, batch run anomalies, and user-reported system issues.

Update existing logic to adapt to regulatory changes, licensing requirements, and agency business process updates.

Application Administration & Infrastructure Liaison

Serve as the primary technical point of contact to coordinate with the hosting provider for system maintenance, OS patching schedules, database utilities, and environmental adjustments.

Manage application-level security configurations, including user profiles, object-level authority, and verify system audit logs (QAUDJRN) to maintain system integrity.

Manage local job queues, active subsystems, and application-level job schedulers.

Coordinate with Ensono's storage and backup operations teams to ensure application backup windows, disaster recovery testing, and restoration verifications are carried out successfully.

DB2 Database & Integration Management

Query, manage, and tune DB2 for i databases, optimizing SQL queries and indexes to ensure database responsiveness.

Support secure, automated file transfers (SFTP/FTP) and interfaces between the hosted AS400 partition and downstream state, regional, or partner systems.

Modernization & Migration Enablement

Cooperate with state database administrators and cloud architects to extract, clean, and archive legacy tables.

Document system flows, database schemas, and interdependencies to facilitate a seamless transition of legacy business logic to modern cloud systems.

Required / Desired Skills

Experience: Minimum of five (5) years of hands-on experience in AS400 (IBM i, iSeries) application development and support.

Programming Skills: Exceptional proficiency in RPG IV (ILE RPG), RPGLE, CL, and SQL on DB2 for i.

Hosting Coordination: Prior experience working in a hosted/managed AS400 environment, collaborating with external hosting providers (such as Ensono) to resolve infrastructure or environmental issues.

Application Administration: Proven experience in IBM i work management, subsystem coordination, application security, and user profile management.

Data Integration: Strong background in file transfer automation (FTP, SFTP) and managing external integrations.

Highly Valued Skills (Nice-to-Haves)

• Direct experience assisting in legacy-to-cloud migrations or data warehousing extractions.
• Familiarity with modern IBM i tools such as Rational Developer for i (RDi).
• Prior experience working in public service (