DB2 DBA/RPG Programmer

Job description: Full-time | Direct Hire | Remote Position - Working Eastern Time HoursWe seek a production DBA to manage DB2 databases on the IBM i for ourlarge enterprise client. This is a remote position working Eastern timebusiness hours. Candidates must live in the US, preferably on the East Coast.*** Please note: This position involves 65% DB2 DBA / 35% Application Programming (RPG). ***You will be responsible for the administration, capacity planning,engineering/design, performance monitoring, and optimization of the DB2for I database platform. - Supports the design and implementation of new database environmentsand the 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, storedprocedures, and triggers.- Supports developers and the testing team by maintaining testenvironments and configuring databases to developmentspecifications.- Work with application development teams to develop data models thatsupport business processes.- Ensure DB changes adhere to best practices.- Review all proposed database changes proposed by IBMi developmentteam.- Creates technical support documentation for databases.- Acts as an SME on IBMI database structure and environment. Qualifications: - 10+ years of IBM i/iSeries/AS400 experience- 7+years ofexperience supporting DB2 for IBM i databases in anenterprise environment.Experience working with enterpriseapplications- Proven experience with key relational database concepts such asdatabase normalization, referential integrity, index strategy, andtransaction isolation.- Expert knowledge of the DB2 for I SQL language.- Advanced knowledge of trigger concepts, methodologies, andimplementation.- In-depth experience diagnosing and remediating Db2 for iDatabaseperformance 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 JobWatcher, 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 toaccept 3rd party candidates, transfer a visa, or provide sponsorship atthis time. Why is This a Great Opportunity: Career growth opportunitiesStable and growing $2.5B healthcare company serving customers across the USA (Company has grown organically and through acquisitions)Ongoing Business and Technology transformationsMatching 401k, Medical, Dental, Vision, Life, Tuition Reimbursement, & moreWork/Life BalanceNigel