DBDBA​/RPG Programmer

Full-time | Direct Hire | Remote Position - Working Eastern Time Hours

We seek a production DBA to manage DB2 databases on the IBM i for our large enterprise client. This is a remote position working Eastern time business hours. Candidates must live in the US, preferably on the East Coast.

**
* Please note:

This position involves 65% DB2 DBA / 35% Application Programming (RPG). ***

• Administration, capacity planning, engineering/design, performance monitoring, and optimization of the DB2 for I database platform.
• Supports the design and implementation of new database environments and redesign of existing systems to fulfill business needs.
• Monitors and evaluates the performance of IBM i DB2 databases.
• Troubleshoots database performance issues.
• Manages database objects – Libraries, views, tables, stored procedures, and triggers.
• Supports developers and the testing team by maintaining test environments and configuring databases to development specifications.
• Work with application development teams to develop data models that support business processes.
• Ensure DB changes adhere to best practices.
• Review all proposed database changes proposed by IBMi development team.
• Creates technical support documentation for databases.
• Acts as an SME on IBMI database structure and environment.

• Stable and growing $2.5B healthcare company serving customers across the USA.
• Ongoing Business and Technology transformations.
• Matching 401k, Medical, Dental, Vision, Life, Tuition Reimbursement, & more.
• Work/Life Balance.
• Career growth opportunities.

We have worked with this client for 20+ years and have made numerous placements with them. Hence the 18% fee. We placed the hiring manager with this client. He seeks a production DBA with AS400 (IBM i/iSeries) experience supporting DB2 databases, and current RPG programming experience. (Please, no mainframe or LUW database administrators; these people work on different systems/platforms.)

• 10+ years of IBM i/iSeries/AS400 experience
• 7+ years of experience supporting DB2 for IBM i 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).
• Strong analytic and problem-solving skills with attention to detail.
• 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.