RPG Programmer

Job Title: RPG Programmer (RPG IV / ILE, Embedded SQL, DB2)
Location: Downtown Houston, TX (Hybrid)
Industry: Oil & Gas / Energy
Employment Type: Full-Time

Position Summary

A large, established oil & gas company in downtown Houston is seeking an experienced RPG Programmer to support and enhance mission-critical applications running on IBM i (AS/400) platforms. This role focuses on developing and maintaining applications written in RPG IV / ILE using Embedded SQL, working heavily with DB2 databases while integrating data and applications with Oracle systems and modern enterprise platforms.

The ideal candidate understands legacy enterprise environments but is comfortable modernizing systems and integrating IBM i applications with newer technologies.

Key Responsibilities

• Develop, enhance, and maintain applications using RPG IV / ILE on IBM i platforms.
• Design and write programs using Embedded SQL for efficient data processing.
• Support and optimize applications utilizing DB2 for i databases.
• Develop and maintain integrations between IBM i systems and Oracle databases and enterprise systems.
• Analyze business requirements and translate them into technical solutions.
• Support business functions related to oil & gas operations, accounting, logistics, or trading systems.
• Troubleshoot production issues and provide performance tuning and problem resolution.
• Collaborate with infrastructure, database, and application teams on system improvements and modernization efforts.
• Participate in system upgrades, migrations, and modernization initiatives.
• Document technical designs, processes, and enhancements.

Required Qualifications

• 5+ years of experience developing in RPG IV / RPGLE / ILE environments.
• Strong experience with Embedded SQL in RPG programs.
• Experience working with DB2 for i databases.
• Experience integrating or working with Oracle databases.
• Strong understanding of IBM i (AS/400) architecture.
• Experience maintaining legacy enterprise applications.
• Strong problem-solving and debugging skills.
• Ability to work independently in a production support environment.

Preferred Qualifications

• Experience in oil & gas, energy, or commodity trading environments.
• Knowledge of CL programming and IBM i job control.
• Experience with APIs, web services, or modernization tools for IBM i.
• Exposure to modernization projects or hybrid system integrations.
• Familiarity with change management and DevOps practices in IBM i environments.