Remote Position - Working Eastern Time Hours
- Role: Ibmi/AS400 RPG Admin
- Duration:Full Time
- Location: Remote
- Salary: 120k/Annum
Job Description
- 10+ years of IBM i/iSeries/AS400 experience
- 7+ years of experience supporting DB2 for databases in an enterprise environment. Experience working with enterprise applications
- Proven experience with key relational database concepts such as database normalization, referential integrity, index strategy, and transaction isolation.
- Expert knowledge of the DB2 for I SQL language.
- Advanced knowledge of trigger concepts, methodologies, and implementation.
- In-depth experience diagnosing and remediating Db2 for iDatabase performance issues using tools such as Plan Cache, Visual Explain, Index Advisor, Detailed Database Monitor, or similar tools.
- Expert knowledge of modern RPG programming language. (ILE/Free).
- Ability to write RPG code to develop solutions to fine-tune the databases. Perform maintenance, performance tuning, analyzing tables, and queries. SQL scripts, checking for issues, etc. Tuning slow queries.
- Hands-on experience using system performance tools such as Job Watcher, Collection Services, PEX Analyzer, or similar tools (preferred)
- Experience using Turnover, Aldon, or similar change management tools
U.S. Citizens or Green Card holders only, please. We are unable to accept 3rd party candidates, transfer a visa, or provide sponsorship, at this time.
Note: IBM i is also referred to as IBMi, iSeries, or AS400. Candidates MUST have this platform experience, not mainframe or Unix.
Job Type: Full-time
Pay: $120,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Experience:
- platform: 1 year (Preferred)
- IBMi or iSeries or AS400: 1 year (Required)
Work Location: Remote