AS400 Developer / Administrator – Contract

Asterism IT Solutions; Oklahoma City (OK); Hybrid; USD 83,000 - 138,000; Part time

Job summary

Asterism IT Solutions is seeking an experienced AS400 Developer / Administrator to support a critical IBM i environment. This contract role is 20 hours per week with a hybrid schedule in Oklahoma City, OK, offering extension potential.

The ideal candidate has hands-on legacy app development, administration, and DB2 for i expertise. The role focuses on application-level development, database support, and coordination with the external hosting provider, with responsibility for maintenance,

Qualifications

• 5+ years hands-on AS400 / IBM i / iSeries experience.
• 5+ years IBM i application development and production support.
• Proficiency in RPG, RPG III, RPG IV, ILE RPG/RPGLE, CL/CLLE, SQL, and DB2 for i.

Responsibilities

• Maintain, modify, enhance, and troubleshoot legacy applications.
• Provide production-level application maintenance and support.
• Troubleshoot defects, batch processing issues, and operational problems.
• Modify application logic to support business and regulatory changes.
• Manage IBM i application-level administration and work management.
• Manage job queues, subsystems, and application job scheduling.
• Manage IBM i user profiles, application security, and object-level authorities.
• Review system audit information including QAUDJRN.
• Coordinate with external hosting/service providers on environmental and infrastructure-related issues.
• Support application backup, disaster recovery, and restoration activities.
• Query, manage, and optimize DB2 for i databases.
• Develop and optimize SQL queries and database indexes.
• Troubleshoot database performance and application data-access issues.
• Support FTP/SFTP and automated file-transfer processes.
• Maintain integrations between IBM i and external/downstream systems.
• Extract, cleanse, archive, and prepare legacy data for migration.
• Document application flows, database schemas, dependencies, business logic, and system relationships.
• Collaborate with DBAs and cloud/modernization teams on legacy-to-cloud migration initiatives

Skills

AS400 / IBM i expertise

RPG / RPG III / RPG IV / RPGLE

CL / CLLE

SQL / DB2 for i

Production support / troubleshooting

Tools

Rational Developer for i (RDi)

Job description

AS400 Developer / Administrator – Contract

Location: Oklahoma City, OK – Hybrid
Position Type: Contract
Duration: 12 Months
Hours: 20 Hours/Week
Extension: High probability of extension

Job Overview

We are seeking an experienced AS400 Developer / Administrator to support a critical IBM AS/400 (IBM i / iSeries) environment.

The ideal candidate will have strong hands-on experience in legacy application development and maintenance, IBM i application administration, DB2 for i, production support, troubleshooting, integrations, and modernization/migration support.

The underlying AS400 hardware and operating system infrastructure is externally hosted and managed. This role focuses primarily on application-level development, administration, database support, integrations, and coordination with the external hosting provider.

Key Responsibilities

• Maintain, modify, enhance, and troubleshoot legacy applications developed using RPG, RPG III, RPG IV, ILE RPG/RPGLE, CL, and SQL

• Provide production-level application maintenance and support

• Troubleshoot application defects, batch processing issues, and operational problems

• Modify application logic to support business and regulatory changes

• Manage IBM i application-level administration and work management

• Manage job queues, subsystems, and application job scheduling

• Manage IBM i user profiles, application security, and object-level authorities

• Review system audit information including QAUDJRN

• Coordinate with external hosting/service providers on environmental and infrastructure-related issues

• Support application backup, disaster recovery, and restoration activities

• Query, manage, and optimize DB2 for i databases

• Develop and optimize SQL queries and database indexes

• Troubleshoot database performance and application data-access issues

• Support FTP/SFTP and automated file-transfer processes

• Maintain integrations between IBM i and external/downstream systems

• Extract, cleanse, archive, and prepare legacy data for migration

• Document application flows, database schemas, dependencies, business logic, and system relationships

• Collaborate with DBAs and cloud/modernization teams on legacy-to-cloud migration initiatives

Required Skills & Qualifications

• 5+ years of hands-on AS400 / IBM i / iSeries experience

• 5+ years of IBM i application development and production support

• Strong proficiency in:

  • RPG

  • RPG III

  • RPG IV

  • ILE RPG / RPGLE

  • CL / CLLE

  • SQL

  • DB2 for i

• Strong experience maintaining and troubleshooting legacy IBM i applications

• Experience working in a hosted or managed IBM i environment

• Experience coordinating with external hosting/service providers

• Experience with IBM i:

  • Work management

  • Job queues

  • Subsystems

  • Job scheduling

  • User profile management

  • Application security

  • Object-level authorities

  • QAUDJRN / audit logs

• Strong DB2 for i and SQL experience, including performance and index optimization

• Experience with FTP/SFTP and automated file transfers

• Experience supporting external system integrations

• Strong production troubleshooting and application support experience

Preferred Qualifications

• Legacy-to-cloud migration experience

• Data warehousing/data extraction experience

• Legacy data cleansing and archiving

• Experience with Rational Developer for i (RDi)

• Public-sector/government IT experience

• Insurance or regulatory systems experience

• Experience documenting legacy business logic and application dependencies

Work Environment

• Oklahoma City, OK

• Hybrid work arrangement

• Candidates should be local to Oklahoma City or willing to relocate for required onsite work

• Ability to work effectively with IT leadership, technical teams, and external service providers