AS/400 Developer & Administrator (RPG/DB2) - Hybrid

Net2Source; Oklahoma City (OK); On-site; USD 95,000 - 125,000; Full time

Benefits offered by this job

401k

Health Insurance

Paid Time Off

Life Insurance

Job summary

Varmoda is seeking an experienced AS/400 Developer/Administrator to support legacy RPG applications and DB2 for i in a hosted IBM i environment. The role includes development, maintenance, security, data integrations, and modernization support for critical systems.

The candidate will manage RPG/CL/SQL development, DB2 for i performance, job scheduling, and disaster recovery validation, collaborating with database admins and cloud architects to plan migration efforts.

Qualifications

• Minimum 5 years of hands-on experience supporting IBM AS/400 (IBM i / iSeries) environments.
• Strong development experience with RPG IV (ILE RPG), RPGLE, CL, and SQL.
• Experience administering and supporting IBM i business applications.
• Experience with DB2 for i, query development, database optimization, and performance tuning.
• Experience managing user profiles, security permissions, object authorities, and system auditing.
• Experience troubleshooting and supporting production systems, FTP/SFTP, and hosted AS/400 environments.

Responsibilities

• Maintain, enhance, and support legacy RPG-based applications and DB2 for i databases.
• Troubleshoot production issues, batch processing failures, and user-reported defects.
• Coordinate OS maintenance, patching, database utilities, and environment changes.
• Develop and optimize SQL queries and indexes to improve performance.
• Manage application security, backups, disaster recovery testing, and data migrations.
• Document system architecture, data flows, and integration processes.

Skills

RPG IV

RPGLE

CL

SQL

DB2 for i

Query Development

Performance Tuning

Security Management

FTP

SFTP

IBM AS/400 / IBM iSeries

Application Administration

Legacy Application Support

AS/400 Hosting Experience

Tools

DB2 for i

Query Development

DB2 Performance Tuning

Job description

Varmoda is seeking an experienced AS/400 Developer/Administrator to support legacy RPG applications and DB2 for i in a hosted IBM i environment. The role includes development, maintenance, security, data integrations, and modernization support for critical systems.

The candidate will manage RPG/CL/SQL development, DB2 for i performance, job scheduling, and disaster recovery validation, collaborating with database admins and cloud architects to plan migration efforts.