AS400 Developer

AS400 Developer / Admin

Duration - 12-Month Initial Assignment (with high probability of extension)


Hours: 20 hours per week



Position Overview


We are seeking an experienced AS400 Developer/Admin to provide application maintenance, database management, and application-level administration for an IBM AS/400 (IBM i Series) environment.


The role will focus on application development, software support, database management, and coordination with the hosted environment team for infrastructure-level modifications. The resource will also support database extraction, documentation of legacy business logic, cloud migration, and data archiving initiatives.

Key Responsibilities

Legacy Application Maintenance & Support

• Maintain, modify, and optimize legacy applications developed using RPG, RPG III, RPG IV (ILE RPG), RPGLE, and Control Language (CL).
• Troubleshoot application bugs, batch processing issues, and user-reported system problems.
• Modify existing application logic based on business and regulatory requirements.

Application Administration

• Coordinate with hosting providers regarding system maintenance, database utilities, patching schedules, and environmental changes.
• Manage application-level security, including user profiles and object-level authorities.
• Review system audit logs and maintain application security.
• Manage job queues, active subsystems, and application-level job scheduling.
• Coordinate backup, disaster recovery, and restoration activities.

DB2 Database & Integration Management

• Query, manage, and tune DB2 for i databases.
• Optimize SQL queries and indexes for database performance.
• Support automated FTP/SFTP file transfers and integrations with external systems.
• Troubleshoot and maintain application interfaces.

Modernization & Migration

• Assist with extracting, cleaning, and archiving legacy database tables.
• Document application flows, database schemas, and system dependencies.
• Support legacy application modernization and cloud migration initiatives.
• Work with database administrators and cloud teams on migration activities.

Required Skills & Qualifications

• 5+ years of hands-on experience with AS400 / IBM i / iSeries application development and support.
• Strong proficiency in RPG IV / ILE RPG, RPGLE, RPG, and CL/CLLE.
• Strong SQL and DB2 for i experience.
• Experience with IBM i application administration and support.
• Experience with job queues, subsystems, scheduling, application security, and user profile management.
• Experience with FTP/SFTP