AS400 Developer/Admin (Contractor)

Aroha Technologies, Inc; Oklahoma; Hybrid; USD 62,000 - 88,000; Part time

Job summary

Aroha Technologies, Inc is seeking an experienced AS400 Developer/Admin for a 12-month contract in Oklahoma City, with hybrid on-site days. The role focuses on application maintenance, database management, and liaison with the hosting provider for environment-level changes.

Ideal candidates have 5+ years in AS/400 development, RPG IV, RPGLE, CL, and SQL on DB2 for i, plus hosting coordination and security considerations. On-site hybridity and long-term engagement are expected.

Qualifications

• Minimum of five years of hands-on AS400 (IBM i) development and support.
• Proficiency in RPG IV, RPGLE, CL, and SQL on DB2 for i.
• Experience with hosted/managed AS400 environments and external hosting providers.

Responsibilities

• Maintain and support legacy AS/400 applications (RPG, CL); troubleshoot bugs.
• Coordinate with hosting provider for environment changes and maintenance.
• Manage DB2 for i queries, tuning, and integration tasks.
• Support data migration, archiving, and documentation of legacy logic.

Skills

RPG IV

RPGLE

CL

SQL

DB2 for i

Hosting coordination

Application administration

FTP/SFTP

Tools

Rational Developer for i (RDi)

Job description

Job Title

AS400 Developer/Admin (Contractor)

Location

Oklahoma City, OK (Hybrid)

Position Type

Contract

Contract Duration

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

Hours

20 hours per week

Interview

1 round Teams Video call 30 minutes. If needed, there may be a second round for shortlisted candidates.

Interview Option

In-person interview at client discretion.

Position Overview

The organization 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 a 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, the contractor will focus on application development, software support, database management, and serving as the technical liaison to the hosting provider for environment-level modifications.

Additionally, the contractor will play a key role in assisting IT leadership with database extraction, documentation of legacy business logic, and support for ongoing cloud migration and data archiving initiatives.

Key Responsibilities

• 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 agency 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 and 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 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 state, regional, 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.

Required Skills & Qualifications

• 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) and managing external integrations.

Highly Valued Skills (Nice-to-Haves)

• Direct experience assisting in legacy-to-cloud migrations or data warehousing extractions.
• Familiarity with modern IBM i tools, such as Rational Developer for i (RDi).
• Prior experience working in public sector environments or supporting insurance regulatory systems.

Work Environment and Terms

• This role is structured as a contract engagement. Candidates must be local to Oklahoma City or willing to relocate, as hybrid schedules require designated on-site days at the organization s facilities.
• Candidates must pass a comprehensive background check as required by applicable IT security standards.