Job description

SUMMARY Performs a variety of complex duties related to data base management systems; monitors, analyzes, investigates, recommends, installs, and deploys applications critical to the secure and efficient operation of the IBM i computer platform, communications, and integrated systems. Manages the overall system configuration including communications, partitions, performance, security auditing, and peripheral management, providing installation, configuration, preventative maintenance, and troubleshooting, and quickly resolves complex problems.

ESSENTIAL DUTIES & RESPONSIBILITIES

• Collaborate with developers, other programmers, users, network engineers, and designers to conceptualize, develop, and document new software programs and applications using a variety of development tools including but not limited to all versions of RPG, HTML, PHP, Java, JavaScript, and other programming languages and tools as needed.
• Analyze and assess existing business systems and procedures and recommend database technologies, tools, and solutions that meet business needs. Assist in defining software development project plans, including scoping, scheduling, and implementation.
• Troubleshoot problems at all system levels and work with all entities necessary to achieve effective resolution.
• Periodically generate statistics and write reports for management and/or team members on the status of the programming process.
• Train end users to operate new or modified programs and provide support for development and maintenance of user manuals and guidelines.
• Conduct research on emerging application development software products, languages, and standards in support of procurement and development efforts.
• Communicate with vendors to achieve efficient implementation of new software products or systems, and for resolution of any adaptation issues.
• Recommend, schedule, communicate, and perform software improvements, patches, and upgrades.
• Support and/or develop interfaces between software applications or to provide connectivity with other systems, such as data collection, non-IBM i servers, etc. and data transfer between the IBM i and other systems
• Develop and support IBM i DB2/DB400 and RDBMS databases on the IBM i
• Support EDI operations including communication session, user, and trading partner support, transaction mapping and program interfaces
• All activities will be done for the express purpose of providing the highest level of systems support and user satisfaction for ASI while maintaining consistency with company goals, industry best practices, regulatory requirements, and internal policies.

QUALIFICATIONS

• Extensive knowledge of IBM i hardware, system software, communications, security, application software, and the i5/os.
• Expert knowledge of programming development languages RPG, RPGII, RPGIII, RPGIV, RPGLE, Free-Format RPG, CL, and API Calls scripting including application tuning and optimization, and ability to write complex SQL statements and incorporate them into RPG and web-based programs
• Expert ability to program IBM i web-based applications using a variety of tools and/or languages such as WebSmart, HTML, PHP, Java, JavaScript, etc.
• Ability to create and manage views, stored procedures, triggers, and to do query optimization.
• Experience with installing, patching, and upgrading software applications
• Ability to develop and manage relational database systems (RDBMS) on the IBM i system and a thorough understanding of DB2/DB400 database architecture including logical and physical file design
• Experience with various emulation packages such as IBM Client Access and Passport including ODBC data transfer between systems
• Familiarity with data file and cross-reference utilities such Hawkeye Pathfinder, DBU, FEU, or similar products
• Strong customer service orientation with the ability to communicate effectively with non-technical staff and with members of interdisciplinary teams
• Flexible and adaptable regarding learning and understanding new technologies.
• Strong written, oral, and interpersonal communication skills.
• Highly self-motivated and directed with a keen attention to detail.
• Proven analytical and problem-solving abilities and ability to conduct research into hardware and software-related issues and products
• Experience working both independently and in a team-oriented, collaborative environment.

EDUCATION &/OR EXPERIENCE

• Two or four-year degree in the field of computer science or related field and 8+ years related work experience or 8+ years equivalent, verifiable work experience
• Thorough knowledge of i5/os including but not limited to security management, networking, communications, system utilities, performance tuning and optimization, SMTP, IFS, and configuration and management of multiple partitions
• RPG, RPGII, RPGIII, RPGIV, Free-Format RPG, RPGILE, SQL, API programming
• Proven project management skills
• Knowledge and understanding of system flow charts, data processing concepts, and telecommunications principles.
• A strong understanding of ERP systems in a manufacturing environment.
• Experience with a change management system.
• Infor XA experience is a plus.
• Certifications in related computer technology areas a plus

Job Type: Full-time

Pay: $75,000.00 - $85,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Tuition reimbursement
• Vision insurance

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Ability to commute/relocate:

• Madison, IN 47250: Reliably commute or planning to relocate before starting work (Required)

Work Location: One location

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.