Hybrid IBM iSeries DB2 SQL Developer: Modernize & Optimize

Amtex Enterprises Inc.; Houston (TX); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Paid parking

Job summary

Amtex Enterprises Inc. in Houston is seeking an IBM iSeries DB2 SQL Developer to design, implement, and optimize database solutions on the IBM iSeries platform.

The role focuses on SQL stored procedures, modernization from RPG to SQL, and integrating backend services via REST APIs and JSON. The ideal candidate will have expert SQL skills on IBM iSeries, experience with DB2, and familiarity with IBM tooling (Aldon, RDI, ACS).

Qualifications

• Expert level experience with SQL stored procedures on the IBM iSeries platform.
• Experience converting RPG to SQL stored procedures in DB2.
• Exposure to IBM tools such as Aldon, RDI, ACS.

Responsibilities

• Develop and maintain database applications on the IBM iSeries platform, using SQL stored procedures and DB2.
• Modernize tables, tune performance, and work with large transactional data sets.
• Interact with front-end via REST APIs and JSON.
• Implement business logic in SQL stored procedures on IBM iSeries.
• Maintain source control with Git and integration workflows.
• Gain experience with Python, microservices, and VS Code IDE development.

Skills

IBM iSeries

SQL stored procedures

Performance tuning

DB2

RPG to SQL modernization

REST APIs

JSON

Python

Microservices

VS Code

Git

Aldon

RDI

ACS

Tools

Aldon

RDI

ACS

Job description

Amtex Enterprises Inc. in Houston is seeking an IBM iSeries DB2 SQL Developer to design, implement, and optimize database solutions on the IBM iSeries platform.

The role focuses on SQL stored procedures, modernization from RPG to SQL, and integrating backend services via REST APIs and JSON. The ideal candidate will have expert SQL skills on IBM iSeries, experience with DB2, and familiarity with IBM tooling (Aldon, RDI, ACS).