Role: AS400
Developer/Admin
Location: Oklahoma
City, OK (Hybrid On-Site 3/2 From Day 1)
Duration: 12+ Months
Hours: 20 hours per week
Visa: USC, GC, H4-EAD, L2-EAD
Position Overview
The Office of Management and Enterprise
Services (OMES), in coordination with the Oklahoma Insurance Department (OID),
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, the contractor will focus 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.
Key Responsibilities
1. 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.
2. 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, 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 & 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 (such as Ensono) 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 Oklahoma Insurance Department or
OMES facilities.
Candidates must pass a comprehensive
background check as required by State of Oklahoma IT security standards.
Skills Required
- Minimum five years of hands-on AS400, IBM i, or iSeries application development and support experience
- Exceptional proficiency with RPG IV, ILE RPG, RPGLE, CL, and SQL on DB2 for i
- Experience working in a hosted or managed AS400 environment with external hosting providers
- Experience with IBM i work management, subsystem coordination, application security, and user profile management
- Strong experience with FTP, SFTP, and external system integrations
- Local to Oklahoma City or willing to relocate for the hybrid on-site schedule
- Ability to pass a comprehensive background check meeting Oklahoma state IT security standards
- Experience supporting legacy-to-cloud migrations or data warehouse extractions
- Familiarity with Rational Developer for i (RDi)
- Public sector experience or experience supporting insurance regulatory systems
What We Do
Established in 2004, 3Core System is a certified small minority owned business providing ERP Systems Integration, AMS, IT Consulting and Staff Augmentation Services to Fortune 1000, SMB, and State, Local and Education (SLED) customers. While our System Integration services help organizations achieve digital and cloud transformation objectives, AMS Services help increase the availability of critical services of end user applications. On the other hand, our IT Consulting Services would provide subject matter experts to help you assist with specific project needs and the Staff Augmentation services help you balance workload and achieve budget parameters. >ERP System Integration Services: 3Core Systems is an SAP Silver Partner and authorized service provider offering technical architecture, application design and configuration, integration, testing, data migration and solution adoption services for solutions including SAP SuccessFactors, SAP HCM On-Premises and SAP Business Intelligence >Application Management Services (AMS): We offer post go-live, System Health Check and Optimization, Function Enhancements, Integration Monitoring, Release, and patch services. Our AMS services span across SAP Solutions including ERP (S/4 HANA), Financial Management, Human Capital Management, Data and Analytics, Supply Chain, CRM, and Customer Experince. >IT Consulting and Staffing Augmentation Services: Ever since its inception, 3Core Systems has been offering IT Consulting and Staff Augmentation solutions including temporary, long-term, project based and contract staffing services that could be personalized based on your needs. Our staffing services span across emerging technologies and legacy solutions including but not limited to Artificial Intelligence, Machine Learning, Data Science, Cloud, ERP, CRM, BI/BW/ETL, Database, Web & E-Commerce, UI/UX, Network & Security and Mobile.
