IBMi AS400/ DB2 Developer

Job Title: IBM i (AS400) / DB2 Developer

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 and maintain CL programs for job control, automation, and batch processing
• Work with DB2 for i:
• Write, modify, and optimize SQL queries
• Maintain and update database objects (physical/logical files, tables, indexes)
• Troubleshoot and debug issues across development, test, and production environments
• 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