AS400 Developer/Admin (OMES supporting OID)

3Core Systems, Inc; Oklahoma City, Northern (OK, KY); Hybrid; USD 96,000 - 138,000; Full time

Job summary

3Core Systems, Inc. in Oklahoma City is seeking an AS400 Developer/Admin for a 12-month contract with hybrid on-site options. This role focuses on IBM i/AS400 application maintenance, DB2 integration, and coordination with Ensono for hosting services.

The candidate will manage RPG, RPGLE, CL, and SQL on DB2 for i, ensure system security, and support migration and data archiving initiatives within a government IT environment.

Qualifications

• Minimum of five (5) years of hands-on AS400 (IBM i, iSeries) development and support.
• Proficiency in RPG IV (ILERPG), RPGLE, CL, and SQL on DB2 for i.
• Experience coordinating with hosted/managed AS400 environments and external providers.
• Experience in IBM i work management, subsystems, security, and user profile management.
• Background in file transfer automation (FTP/SFTP) and external integrations.

Responsibilities

• Maintain, modify, and optimize legacy RPG/CL code and IBM i environment.
• Troubleshoot operational bugs, batch issues, and user-reported problems.
• Update logic for regulatory changes and agency processes.
• Coordinate with hosting provider for maintenance, OS patches, and backups.
• Manage application security configurations, user profiles, and audit logs.
• Oversee local job queues, subsystems, and schedulers.
• Collaborate on backup windows, DR testing, and restorations.

Skills

RPG IV

RPGLE

CL

SQL DB2 for i

Application administration

Hosting coordination

Data integration

RDi (IBM i tools)

Tools

RDi

Job description

AS400 Developer/Admin (OMES supporting OID)

Job Title: AS400 Developer/Admin (Contractor)
Location: Oklahoma City, OK (Hybrid options available)
Position Type: Contract
Contract Duration: 12-Month Initial Assignment (with high probability ofextension)

PositionOverview

The Office of Management and EnterpriseServices (OMES), in coordination with the Oklahoma Insurance Department (OID),is seeking an experienced, high-caliber AS400 Developer/Admin for along-term contract engagement. This critical resource will provide essentialapplication maintenance, database management, and application-leveladministration services for OID’s core IBM AS/400 (IBM i Series) environment.

Because the underlying AS/400 hardwarepartition, operating system, and baseline infrastructure are fully hosted andmanaged by an external provider, this position does not require hardware orOS-level systems engineering. Instead, the contractor will focus on applicationdevelopment, software support, database management, and serving as thetechnical liaison to Ensono for environment-level modifications.

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

KeyResponsibilities

Maintain, modify, and optimize customlegacy application code written in RPG, RPG III, RPG IV (ILE RPG), RPGLE, andControl Language (CL).

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

Update existing logic to adapt toregulatory changes, licensing requirements, and agency business processupdates.

Serve as the primary technical point ofcontact to coordinate with the hosting provider for system maintenance, OSpatching schedules, database utilities, and environmental adjustments.

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

Manage local job queues, activesubsystems, and application-level job schedulers.

Coordinate with Ensono’s storage andbackup operations teams to ensure application backup windows, disaster recoverytesting, and restoration verifications are carried out successfully.

3. DB2 Database & Integration Management

Query, manage, and tune DB2 for idatabases, optimizing SQL queries and indexes to ensure databaseresponsiveness.

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

4. Modernization & Migration Enablement

Cooperate with state databaseadministrators and cloud architects to extract, clean, and archive legacytables.

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

RequiredSkills & Qualifications

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

ProgrammingSkills: Exceptional proficiency in RPG IV (ILERPG), RPGLE, CL, and SQL on DB2 for i.

HostingCoordination: Priorexperience working in a hosted/managed AS400 environment, collaborating withexternal hosting providers (such as Ensono) to resolve infrastructure orenvironmental issues.

ApplicationAdministration: Provenexperience in IBM i work management, subsystem coordination, applicationsecurity, and user profile management.

DataIntegration: Strongbackground in file transfer automation (FTP, SFTP) and managing externalintegrations.

Highly Valued Skills (Nice-to-Haves):

Direct experience assisting in legacy-to-cloudmigrations or data warehousing extractions.

Familiarity with modern IBM i tools,suchas Rational Developer for i (RDi).

Prior experience working in public sectorenvironments or supporting insurance regulatory systems.

WorkEnvironment and Terms

This role is structured as a contractengagement. Candidatesmust be local to Oklahoma City or willing to relocate , as hybridschedules require designated on-site days at Oklahoma Insurance Department orOMES facilities.

Candidates must pass a comprehensivebackground check as required by State of Oklahoma IT security standards.