Application Development AS400 Developer / Administrator

Position Summary Varmoda is seeking an experienced AS400 Developer / Administrator to support and maintain critical legacy applications and databases within the agency's IBM AS/400 (IBM iSeries) environment. This role will provide application development, maintenance, administration, database management, integration support, and modernization assistance for business-critical systems. The successful candidate will serve as the primary technical resource responsible for supporting RPG-based applications, DB2 databases, application security, data integrations, job scheduling, and migration preparation activities to support future modernization efforts.

Key Responsibilities

• Maintain, enhance, and support legacy business applications developed using:
  • RPG
  • RPG III
  • RPG IV (ILE RPG)
  • RPGLE
  • CL (Control Language)
• Troubleshoot production issues, batch processing failures, and user-reported defects.
• Modify application logic to support business, regulatory, licensing, and compliance changes.
• Perform application debugging, testing, deployment, and post-implementation validation.
• Serve as the primary point of contact between OID and the hosting provider.
• Coordinate:
  • Operating System Maintenance
  • Patch Management
  • Database Utilities
  • Environment Changes
• Manage application security including:
  • User Profiles
  • Object-Level Security
  • Access Controls
  • Audit Log Review (QAUDJRN)
• Support:
  • Job Queues
  • Active Subsystems
  • Application Scheduling Processes
• Coordinate backup, recovery, disaster recovery testing, and restoration validation activities.
• Administer and maintain DB2 for i databases.
• Develop and optimize SQL queries and indexes to improve application performance.
• Perform database troubleshooting, maintenance, and performance tuning.
• Support secure file transfer processes using:
  • FTP
  • SFTP
• Maintain integrations with internal and external partner systems.
• Partner with database administrators, infrastructure teams, and cloud architects.
• Support legacy data extraction, cleanup, archival, and migration activities.
• Document:
  • System Architecture
  • Data Flows
  • Database Schemas
  • Application Dependencies
  • Integration Processes
• Assist with modernization initiatives and migration planning activities.

Required 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 (Control Language)
  • SQL
• Experience administering and supporting IBM i business applications.
• Experience with:
  • DB2 for i
  • Query Development
  • Database Optimization
  • Performance Tuning
• Experience managing:
  • User Profiles
  • Security Permissions
  • Object Authorities
  • System Auditing
• Experience troubleshooting and supporting production systems.
• Experience supporting:
  • FTP
  • SFTP
  • Automated File Transfers
• Experience working in hosted or managed AS400 environments.
• Strong analytical and problem-solving capabilities.
• Excellent communication and documentation skills.

Preferred Qualifications

• Experience working with external hosting providers and managed infrastructure environments.
• Experience coordinating disaster recovery and backup validation activities.
• Experience supporting modernization or cloud migration initiatives.
• Experience documenting legacy systems and technical architectures.
• Familiarity with enterprise integration and data migration strategies.
• Experience supporting government, regulatory, insurance, or public-sector environments.

Required Technical Skills

• RPGLE
• RPG IV (ILE RPG)
• CL (Control Language)
• SQL on DB2 for i
• IBM AS/400 / IBM iSeries
• FTP / SFTP
• Application Administration
• Security Management
• Job Queue Management
• Legacy Application Support
• DB2 Performance Tuning

Preferred Certifications

• IBM i Administration Certification
• IBM DB2 Certification
• RPG Programming Certification
• ITIL Foundation Certification