AS400 Developer/Admin - Part-Time

Connect Tech+Talent; Oklahoma City (OK); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Connect Tech+Talent seeks an experienced AS/400 technical specialist to support a 12-month contract in Oklahoma City. You will modify and optimize legacy RPG/CL applications and ensure secure, reliable operation in a hosted Ensono environment.

The role emphasizes deep DB2 for i expertise, batch and job scheduler management, and collaboration with hosting providers to coordinate patches, backups, and DR testing. Strong documentation and regulatory change adaptation are essential.

Qualifications

• Minimum five years of hands-on AS400 (IBM i) development and support.
• Proficient in RPG IV, RPGLE, CL, and SQL on DB2 for i.
• Experience coordinating with hosted AS400 environments and providers like Ensono.
• Experience in IBM i work management, subsystems, and security.
• Experience with FTP/SFTP file transfers and external integrations.

Responsibilities

• Maintain, modify, and optimize legacy RPG/CL programs.
• Troubleshoot operational bugs and batch issues.
• Update logic for regulatory changes and licensing requirements.
• Coordinate with hosting provider for maintenance, OS patching, and environment changes.
• Manage application security configurations and audit logs.
• Manage local job queues, subsystems, and schedulers.
• Coordinate with storage/backup teams for DR testing and restoration verifications.
• Query, manage, and tune DB2 for i databases; optimize SQL and indexes.
• Support secure file transfers and interfaces to external systems.
• Archive legacy data with state DB admins and cloud architects.
• Document system flows, schemas, and interdependencies for cloud transition.

Skills

AS400 development

RPG IV

RPGLE

CL

SQL DB2 for i

Hosting coordination

IBM i work management

Subsystem coordination

Application security

User profiles

FTP/SFTP automation

Job description

Location: Oklahoma City, OK (Hybrid options available)

Position Type: Contract

Contract Duration: 12-Month Initial Assignment (with high probability of extension)

Key Responsibilities

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.

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.

3. 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.

4. 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 Skills & Qualifications

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 sector environments or supporting insurance regulatory systems.