Application Developer
Listed on 2026-09-23
-
IT/Tech
Database Administrator, Systems Administrator
Position Summary
LCI is seeking an experienced, high-caliber AS400 Developer/Admin for a long-term contract engagement. This critical resource will provide essential application maintenance, database management, and application-level administration services for OID’s core IBM AS/400 (IBM i Series) environment. Because the underlying AS/400 hardware partition, operating system, and baseline infrastructure are fully hosted and managed by an external provider, this position does not require hardware or OS-level systems engineering.
Instead focus will be on application development, software support, database management, and serving as the technical liaison to Ensono for environment-level modifications. Additionally, the contractor will play a key role in assisting state IT leadership with database extraction, documentation of legacy business logic, and support for ongoing cloud migration and data archiving initiatives.
LCI is seeking an experienced, high-caliber AS400 Developer/Admin for a long-term contract engagement. This critical resource will provide essential application maintenance, database management, and application-level administration services for OID’s core IBM AS/400 (IBM i Series) environment. Because the underlying AS/400 hardware partition, operating system, and baseline infrastructure are fully hosted and managed by an external provider, this position does not require hardware or OS-level systems engineering.
Instead focus will be on application development, software support, database management, and serving as the technical liaison to Ensono for environment-level modifications. Additionally, the contractor will play a key role in assisting state IT leadership with database extraction, documentation of legacy business logic, and support for ongoing cloud migration and data archiving initiatives.
- 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 agency business process updates.
- 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 Ensono’s storage and backup operations teams to ensure application backup windows, disaster recovery testing, and restoration verifications are carried out successfully.
- 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 state, regional, or partner systems.
- Document system flows, database schemas, and interdependencies to facilitate a seamless transition of legacy business logic to modern cloud systems.
- Maintain a working familiarity with legacy system architectures, dependencies, and integration points to safely support operational systems while building modern alternatives. Collaborate on code submission pipelines by submitting pull requests for technical staff review.
- Cooperate with state database administrators and cloud architects to extract, clean, and archive legacy tables.
- Experience:
Minimum of two (2) years of hands‑on experience in AS400…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).