IBMi AS400/ DB2 Developer

American Benefit Corporation; Illinois; Hybrid; USD 80,000 - 100,000; Full time

Job summary

American Benefit Corporation is seeking an IBM i (AS400) / DB2 Developer to support and enhance their core backend systems. The role is focused on RPG and CL development, DB2 for i data management, and integration with modern applications. Responsibilities include developing RPG/CL programs, optimizing SQL queries, and collaborating with teams to ensure reliable data flow. Ideal candidates have experience in IBM i systems, debugging, and problem-solving skills while being comfortable with both legacy and modern systems.

Qualifications

• Experience with RPG programming and CL (Control Language).
• Background in DB2 for i and working on IBM i (AS400) systems.
• Ability to write, modify, and troubleshoot SQL queries.

Responsibilities

• Develop and maintain RPG programs and CL programs.
• Optimize SQL queries and maintain database objects.
• Support integration between IBM i systems and external platforms.

Skills

RPG programming

CL (Control Language)

DB2 for i

SQL query troubleshooting

Debugging skills

Batch processing

Job scheduling and queues

Job description

Overview

We are hiring an IBM i (AS400) / DB2 Developer to support and enhance our core backend systems. This role focuses on RPG and CL development, DB2 for i data management, and integration with modern applications.

This role will work closely with our software engineering team (web, desktop, mobile apps and APIs) and play a key part in connecting legacy systems with newer technologies.

Responsibilities

• Develop, maintain, and modify RPG programs
• Write, modify, and maintain CL programs for job control, automation, and batch processing
• Work with DB2 for i by writing, modifying, and optimizing SQL queries; maintain and update database objects (physical/logical files, tables, indexes); troubleshoot and debug issues across development, test, and production environments; and monitor and support batch jobs, job queues, and system processes
• Analyze existing applications and implement enhancements or fixes
• Support integration between IBM i systems and external platforms: ODBC connections, APIs and external applications (e.g., .NET systems); collaborate with software engineers to ensure reliable data flow between systems
• Assist in improving and modernizing existing applications and data access patterns
• Document system behavior, changes, and technical processes as needed

Required Qualifications

• Experience with: RPG programming
• CL (Control Language)
• DB2 for i
• Experience working on an IBM i (AS400) system
• Experience writing and troubleshooting SQL queries
• Strong debugging and problem-solving skills
• Ability to read, understand, and modify existing/legacy codebases
• Understanding of: Batch processing, Job scheduling and job queues

Preferred Qualifications

• Experience with embedded SQL in RPG
• Experience integrating IBM i systems with external applications: ODBC / JDBC
• APIs or service-based architectures
• Experience with DB2 performance tuning and query optimization
• Understanding of ILE concepts (modules, service programs)
• Exposure to system modernization efforts (e.g., improving legacy workflows, enabling external integrations)
• Familiarity with modern development environments or working alongside web/API teams

Nice to Have

• Experience in financial, benefits, claims, or pension systems
• Experience supporting or improving data pipelines between systems
• Familiarity with .NET or modern backend environments
• Experience working in environments with both legacy and modern systems

What We’re Looking For

• Someone who can take ownership of the IBM i / DB2 side of the system
• Comfortable working with both legacy code and evolving systems
• Able to collaborate effectively with engineers working on modern application stacks
• Strong attention to detail and ability to troubleshoot across systems
• Willingness to learn and adapt as systems evolve

Location

• Chicago, IL/Greater Chicago Area, Onsite/Hybrid