Application Developer / AS400 Developer/Admin -Part Time

Luna Data Solutions, Inc.; Oklahoma City (OK); Hybrid; USD 55,000 - 83,000; Part time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

Short-term disability

Competitive compensation

Job summary

Luna Data Solutions, Inc. in Oklahoma City seeks a part-time AS400 Developer/Admin for a long-term contract. Role covers maintenance, DB2 for i, and administration of IBM i environment.

This hybrid position is 20 hours per week, Monday through Friday, local candidates or those willing to relocate. The ideal candidate has 5+ years hands-on AS400 experience, RPG IV, RPGLE, CL, and SQL, plus hosting coordination and security management.

Qualifications

• Minimum of five (5) years of hands-on AS400 (IBM i) development and support.
• Proficient in RPG IV, RPGLE, CL, and SQL on DB2 for i.
• Experience with hosted/managed AS400 environments and external hosting providers.
• Experience in IBM i work management, subsystem coordination and security.
• Strong background in FTP/SFTP data integration.

Responsibilities

• Maintain, modify, and optimize legacy AS400 code (RPG, RPGLE, CL).
• Troubleshoot operational issues, batch runs, and user-reported problems.
• Update logic for regulatory changes and licensing requirements.
• Coordinate with hosting provider for maintenance, patches, and environments.
• Manage application security, user profiles, and audit logs.
• Manage local job queues, subsystems, and schedulers.
• Coordinate backups and disaster recovery with hosting teams.

Skills

RPG IV

RPGLE

CL

SQL on DB2 for i

Hosting coordination

Application administration

Data integration (FTP/SFTP)

Tools

DB2 for i

IBM i hosting environment

Job description

We are seeking a part-time AS400 Developer/Admin in Oklahoma City, OK.

Location & Schedule: Oklahoma City/Hybrid Remote M-F 20 hrs. a week. Candidates must be local to Oklahoma City or willing to relocate.

Description

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.

Key Responsibilities

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.

3. 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.

4. Modernization & Migration Enablement

Cooperate with state 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:

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)

Preferred Skills:

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.

What We Offer

Work on a highly innovative team with cutting‑edge technology

Great opportunity to make a big impact and take ownership of technology initiatives

Altruistic work

• Competitive compensation and benefits including health, dental, vision, life and accident insurance, short-term disability insurance, and more!

Luna Data Solutions, Inc. (LDS) provides equal employment opportunities to all employees.

We will consider all applicants for employment.

LDS prohibits discrimination and harassment of any type regarding age, race, color, religion, sexual orientation, gender identity, sex, national origin, genetics, protected veteran status, and/or disability status.