Onsite AS/400 Programmer/Analyst: RPG & DB2 Expert

Stellar Consulting Solutions, LLC; Monroe (NJ); On-site; USD 120,000 - 150,000; Part time

Job summary

Stellar Consulting Solutions, LLC seeks an experienced iSeries developer to drive RPG-based projects on the IBM i platform. You will work on AS/400 DB2 databases, write complex SQL, and implement stored procedures, triggers, and UDFs.

Strong debugging with IBM ACS and RDi, plus OO design knowledge, is required. Familiarity with .NET, Java, HTML/XML, and WS-* standards is a plus. This is an onsite contract role in Monroe Township, NJ.

Qualifications

• 8+ years hands-on programming experience on iSeries using RPG in fixed and free format with embedded SQL, CLP, ILE, and DDS.
• 8+ years of hands-on experience with AS400/DB2 (SQL Server or Oracle a plus).
• Deep understanding of relational database theory and operation.
• Advanced SQL knowledge including tuning and performance optimization.
• Experience in developing stored procedures, triggers, and user-defined functions.

Responsibilities

• Hands-on programming on iSeries using RPG, embedded SQL, CLP, ILE, and DDS.
• Work with AS/400 DB2 and SQL Server or Oracle on related projects.
• Develop relational database solutions and optimize queries.
• Design and implement stored procedures, triggers, and UDFs.
• Leverage IBM ACS and RDi for development and debugging.
• Apply OO design principles and modern development practices.
• Collaborate with teams on .NET and Java platforms as needed.
• Work with HTML/XML and WS-* standards in web/SOA contexts.
• Utilize Visual Studio Code and Code for i extension.

Skills

iSeries RPG

RPG - fixed & free format

Embedded SQL

CLP

ILE

DDS

AS400/DB2

SQL

Query tuning

Stored procedures

Triggers

UDFs

OO programming

Microsoft.NET

C#

Java

HTML/XML

WSDL/SOA

Visual Studio Code

Code for i extension

Troubleshooting

Tools

IBM ACS (Access Client Solutions)

IBM RDi

Visual Studio Code

Code for i extension

Job description

Stellar Consulting Solutions, LLC seeks an experienced iSeries developer to drive RPG-based projects on the IBM i platform. You will work on AS/400 DB2 databases, write complex SQL, and implement stored procedures, triggers, and UDFs.

Strong debugging with IBM ACS and RDi, plus OO design knowledge, is required. Familiarity with .NET, Java, HTML/XML, and WS-* standards is a plus. This is an onsite contract role in Monroe Township, NJ.