AS400/RPG Developer

Dunham's Sports; Troy (MI); On-site; USD 90,000 - 120,000; Full time

Job summary

Dunham's Sports in Troy, MI, is seeking a Developer on IBM i Power Systems (AS400) to join our corporate office. This role requires deep RPG, CL, and DB2/400 expertise, and a proven track record with SQL and iSeries tools.

You will gather user requirements, author design documents, develop tests, and plan releases, while coordinating with cross-functional teams. This is a non-remote, on-site position with opportunities to work on mission-critical retail systems.

Qualifications

• Must be proficient in RPG, including RPG3 and ILE, on IBM i Power Systems.
• Expert in CL programming and handling printer/file/database files.
• Strong knowledge of DB2/400 and SQL (interactive and RPG-ILE).
• Experience with FTP, DDM, and Stream Files on iSeries.
• Familiar with IBM products Query and SDA; and non-IBM tools Hawkeye is plus.
• Ability to gather requirements, write design docs, and manage SDLC and QA plans.
• Experience with Lawson, Manhattan WMS, Island Pacific, and Visual Source Safe is a plus.
• Excellent communication; able to train end users; on-call readiness.
• Proven vendor interaction with third-party consultants and software vendors.

Responsibilities

• Develop and maintain RPG on IBM i Power Systems.
• Prepare user design documents and technical designs.
• Plan projects and create QA/test plans.
• Document user guides and conduct end-user training.
• Troubleshoot performance, apply PTFs, and manage releases.
• Collaborate with cross-department teams.
• Provide on-call support.

Skills

RPG

RPG3

ILE

Control Language (CL)

SQL

DB2/400

FTP

DDM

Stream Files

IBM iSeries

Query/SDA

Vendor management

Lawson ERP

Manhattan WMS

Island Pacific

Microsoft Office

Visual Source Safe

Hawkeye

Tools

Hawkeye

Manhattan WMS

Island Pacific

Lawson Financial Software

Microsoft Office

Visual Source Safe

DB2/400

Query

SDA

FTP

DDM

Stream Files

Mark Magic

Job description

Dunham's Sports, one of the largest full-line sporting goods chains in the U.S., was founded in 1937 as Dunham's Bait & Tackle. Today, we have over 260 stores across 25 Midwestern states, from Maryland to Montana.

We are seeking a Developer on IBM i Power Systems (AS400). This position works out of our corporate office in Troy, MI. This job is NOT REMOTE OR HYBRID.

Must be well-versed in RPG, including RPG3 and ILE. Expert with internal and external printer files and database files. Must be an expert in Control Language programming. The applicant must be well-versed in iSeries technical skills. Must know IBM products: Query and SDA. A working knowledge of FTP, DDM, and Stream Files is important. Expertise in SQL should include both Interactive and RPG-ILE. Experience with non-IBM products, DBU, and Hawkeye is also required. Experience with Mark Magic is helpful but not required.

A working knowledge of the SDLC and practical project management experience are expected. Must be able to gather user requirements, author user design documents, and develop technical design documents. Project planning skills are essential. Must be able to develop a quality assurance and formal test plan. Must also be able to author user documentation and be at ease conducting end-user training sessions.

Expertise with DB2/400 is also expected, as well as the ability to troubleshoot database performance issues. System performance tuning, PTF, and Release Upgrades are also highly desirable. Familiarity with common iSeries hardware, such as printers and tape drives, is also expected.

Developer on IBM i Power Systems (AS400) Requirements:

• Must be a self-starter, highly motivated, and well organized.
• Excellent verbal and written communication skills are required.
• Having the ability to work with members of other departments in both team and one-on-one roles is also required.
• Experience with third-party consultants and software vendors is very important.
• Must have the ability to: quickly identify technical issues, work with management in developing an action plan, execute the plan on schedule, and determine a measurement for success.
• Knowledge of Lawson financial software is a plus.
• Experience with Manhattan WMS software is also a big plus.
• Exposure to Island Pacific merchandising systems is also highly desirable but not mandatory.
• Complete familiarity with Microsoft products; Word, Excel, Project, and Outlook is required.
• Familiarity with Visual Source Safe is desirable.
• Must be open to on call responsibilities.