Application Development AS400 Developer / Administrator

Position Summary The Oklahoma Insurance Department (OID), in partnership with the Office of Management and Enterprise Services (OMES), 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 Legacy Application Development & Support Maintain, enhance, and support legacy business applications developed using:RPGRPG IIIRPG IV (ILE RPG)RPGLECL (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. Application Administration & Infrastructure Coordination Serve as the primary point of contact between OID and the hosting provider. Coordinate:Operating System MaintenancePatch ManagementDatabase UtilitiesEnvironment ChangesManage application security including:User ProfilesObject-Level SecurityAccess ControlsAudit Log Review (QAUDJRN)Support:Job QueuesActive SubsystemsApplication Scheduling ProcessesCoordinate backup, recovery, disaster recovery testing, and restoration validation activities. DB2 Database Administration & Integration Support 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:FTPSFTPMaintain integrations with internal and external partner systems. Modernization & Migration Support Partner with database administrators, infrastructure teams, and cloud architects. Support legacy data extraction, cleanup, archival, and migration activities. Document:System ArchitectureData FlowsDatabase SchemasApplication DependenciesIntegration ProcessesAssist 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)RPGLECL (Control Language)SQLExperience administering and supporting IBM i business applications. Experience with:DB2 for iQuery DevelopmentDatabase OptimizationPerformance TuningExperience managing:User ProfilesSecurity PermissionsObject AuthoritiesSystem AuditingExperience troubleshooting and supporting production systems. Experience supporting:FTPSFTPAutomated File TransfersExperience 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. Certifications & Clearance Preferred Certifications IBM i Administration CertificationIBM DB2 CertificationRPG Programming CertificationITIL Foundation Certification Compliance Requirements Agency must maintain and provide proof of $5 Million Cyber Insurance Coverage. Work involves High Data Sensitivity information and requires adherence to strict security and confidentiality standards. Clearance Must satisfy Oklahoma state onboarding and security requirements. How To Apply Interested candidates may apply directly through this posting or the approved Oklahoma procurement process. Qualified applicants will be contacted by the recruiting team for further evaluation. Required Technical Skills RPGLERPG IV (ILE RPG)CL (Control Language)SQL on DB2 for iIBM AS/400 / IBM iSeriesFTP / SFTPApplication AdministrationSecurity ManagementJob Queue ManagementLegacy Application SupportDB2 Performance Tuning About Varmoda Varmoda is a federal IT solutions provider founded in 2020 and headquartered in McLean, Virginia, delivering citizen-centric public services across Financial Assistance, Public Benefits, and Security & Defense domains. Our five-layer architecture — Salesforce (Engagement), Databricks (Data), ServiceNow (Orchestration), Pega (Decisioning), and Oracle HR (Capacity) — puts data at the common thread of every solution we build for federal agencies and the citizens they serve. Varmoda holds CMMI Maturity Level 3, ISO 9001, ISO 20000, and ISO 27001 certifications, and is recognized as a V3 veteran-friendly employer. Why Varmoda Growth opportunity within a fast-scaling federal IT firmDirect impact on citizen-facing federal programsCompetitive benefits including 401k, health insurance, Paid Time Off, Life Insurance and others — customize per role/locationVeteran-friendly (V3) workplace culture Equal Employment Opportunity Varmoda is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. Varmoda and its affiliated entities never request payment, banking details, or financial information from candidates during hiring. All legitimate communication comes from a varmoda.com address or JobDiva — report suspicious contact to info@varmoda.com. Varmoda and its affiliates are Equal Opportunity Employers; all qualified applicants are considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, age, or any other legally protected characteristic.