AS400 Developer / Administrator

Asterism IT Solutions; Oklahoma; Hybrid; USD 90,000 - 120,000; Full time

Job summary

Asterism IT Solutions seeks an experienced AS400 Developer/Administrator to support a critical IBM AS/400 environment, focusing on application-level development, administration, and DB2 for i, with external hosting coordination. Hybrid Oklahoma City-area role.

The candidate should possess 5+ years of hands-on AS400/IBM i experience, strong RPG/SQL skills, and a track record in production support, system integration, and data migration initiatives.

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.

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 transfers.
• 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 experience

IBM i application development

Production support

Tools

RPG

RPG III

RPG IV

ILE RPG/RPGLE

CL/CLLE

SQL

DB2 for i

QAUDJRN/audit logs

FTP/SFTP

Rational Developer for i (RDi)

Work management

Job queues

Subsystems

Job scheduling

User profiles

Application security

Object-level authorities

Job description

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