DB2 IBM i SQL Pro: RPG to SQL Specialist (Remote)

The Jupiter Group, Inc; United States; On-site; USD 90,000 - 140,000; Full time

Job summary

The Jupiter Group, Inc. seeks a seasoned IBM iSeries DB2 developer to design and optimize database-focused applications. You will work with dynamic SQL, convert RPG code to SQL stored procedures, and perform performance tuning with robust logging and exception handling.

Reading RPGIV/RPGLE/RPGFree, and modernization from RPG to SQL are key requirements. Candidates should have hands-on experience with REST APIs and JSON, plus exposure to Python, microservices, and VS Code IDE.

Qualifications

• Must have expert SQL stored procedures on IBM iSeries (DB2) platform.
• Experience reading and converting RPGIV/RPGLE/RPGFree, with no embedded SQL.
• Experience modernizing RPG to SQL stored procedures on DB2.

Skills

DB2 iSeries

Dynamic SQL

SQL stored procedures

RPG reading

RPGIV/RPGLE/RPGFree

RPG to SQL conversion

REST APIs

JSON

Python

Microservices

VS Code

Logging

Exception handling

Aldon

RDI

ACS

Tools

Aldon

RDI

ACS

Job description

The Jupiter Group, Inc. seeks a seasoned IBM iSeries DB2 developer to design and optimize database-focused applications. You will work with dynamic SQL, convert RPG code to SQL stored procedures, and perform performance tuning with robust logging and exception handling.

Reading RPGIV/RPGLE/RPGFree, and modernization from RPG to SQL are key requirements. Candidates should have hands-on experience with REST APIs and JSON, plus exposure to Python, microservices, and VS Code IDE.