Application Development AS400 Developer

OP Consulting Group LLC

Oklahoma City, OK, United States

24 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Db2400 Business Logic IBM System I Computer Programming Databases Data Integration Document Management Systems File Transfer IBM RPG (Programming Language) Information Technology Audit Job Scheduling Software Maintenance

+8 more

Software Engineering SQL Databases Subsystems RPL (Programming Language) File Transfer Protocol (FTP) Software Security Control Language Database Tools and Utilities

Job description

Legacy Application Maintenance & Support * Maintain, modify, and optimize custom legacy application code written in RPG, RPG III, RPG IV (ILE RPG), RPGLE, and Control Language (CL). * Investigate and troubleshoot operational bugs, batch run anomalies, and user-reported system issues. * Update existing logic to adapt to regulatory changes, licensing requirements, and business process updates.
Application Administration & Infrastructure Liaison * Serve as the primary technical point of contact to coordinate with the hosting provider for system maintenance, OS patching schedules, database utilities, and environmental adjustments. * Manage application-level security configurations, including user profiles, object-level authority, and verify system audit logs (QAUDJRN) to maintain system integrity. * Manage local job queues, active subsystems, and application-level job schedulers. * Coordinate with third-party storage and backup operations teams to ensure application backup windows, disaster recovery testing, and restoration verifications are carried out successfully.
DB2 Database & Integration Management * Query, manage, and tune DB2 for i databases, optimizing SQL queries and indexes to ensure database responsiveness. * Support secure, automated file transfers (SFTP/FTP) and interfaces between the hosted AS400 partition and downstream or partner systems.
Modernization & Migration Enablement * Cooperate with database administrators and cloud architects to extract, clean, and archive legacy tables. * Document system flows, database schemas, and interdependencies to facilitate a seamless transition of legacy business logic to modern cloud systems.

Requirements

Experience: Minimum of five (5) years of hands-on experience in AS400 (IBM i, iSeries) application development and support.
Programming Skills: Exceptional proficiency in RPG IV (ILE RPG), RPGLE, CL, and SQL on DB2 for i.
Hosting Coordination: Prior experience working in a hosted/managed AS400 environment, collaborating with external hosting providers to resolve infrastructure or environmental issues.
Application Administration: Proven experience in IBM i work management, subsystem coordination, application security, and user profile management.
Data Integration: Strong background in file transfer automation (FTP, SFTP).