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:
- 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
}
