AS/400 Developer & Administrator — Hybrid (OKC)

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

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.