AS400 Developer/Admin
AS400 Developer/Admin – ContractLocation: Oklahoma City, OK – HybridDuration: 12-month initial contract, with high probability of extensionHours: 20 hours/weekInterview: 1 round Teams video interview – 30 minutes; possible second roundPosition Overview:We are seeking an experienced AS400 Developer/Admin to support its core IBM AS/400 (IBM i / iSeries) environment.The consultant will focus on legacy application development and maintenance, database management, application administration, integrations, and modernization support. The underlying AS400 hardware, operating system, and baseline infrastructure are hosted and managed by an external provider, so this is not an OS/hardware-level engineering role.Key Responsibilities:1. Legacy Application Development & SupportMaintain, modify, and optimize applications written in:RPGRPG IIIRPG IV / ILE RPGRPGLECLTroubleshoot application bugs, batch processing issues, and user-reported problems.Modify existing application logic for regulatory, licensing, and business-process changes.2. Application Administration & Infrastructure CoordinationCoordinate with the external hosting provider on system maintenance, OS patching, database utilities, and environmental changes.Manage application-level security, including user profiles and object-level authority.Review QAUDJRN audit logs.Manage job queues, active subsystems, and application-level job schedulers.Coordinate backup, disaster recovery testing, and restoration activities with Ensono's storage/backup teams.3. DB2 Database & Integration ManagementQuery, manage, and tune DB2 for i databases.Optimize SQL queries and indexes.Support automated FTP/SFTP file transfers.Manage interfaces between the AS400 environment and state, regional, or partner systems.4. Modernization & MigrationAssist with extracting, cleaning, and archiving legacy data.Work with DBAs and cloud architects on modernization initiatives.Document system flows, database schemas, and application interdependencies to support migration of legacy business logic to modern cloud platforms.Required Skills5+ years hands-on AS400 / IBM i / iSeries development and supportStrong RPG IV / ILE RPGRPGLECLSQL / DB2 for iIBM i work management and subsystem coordinationApplication security and user-profile administrationFTP/SFTPExternal system integrationsExperience working with a hosted/managed AS400 environmentExperience coordinating with external hosting providers such as EnsonoNice-to-Have SkillsLegacy-to-cloud migration experienceData warehousing/data extraction experienceRational Developer for i (RDi)Public-sector experienceInsurance/regulatory systems experience