DB2 DBA/RPG Programmer

DB2 DBA/RPG Programmer Salary: Confidential Location: Tampa, Florida Minimum Degree: Relocation Assistance: Available Job Description 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). *** You will be responsible for the 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 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, 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 IBM i development team.- Creates technical support documentation for databases.- Acts as an SME on IBM I database structure and environment. Qualifications - 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 i Database 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 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 to accept 3rd party candidates, transfer a visa, or provide sponsorship at this time. Why is This a Great Opportunity Career growth opportunities Stable and growing $2.5B healthcare company serving customers across the USA (Company has grown organically and through acquisitions) Ongoing Business and Technology transformations Matching 401k, Medical, Dental, Vision, Life, Tuition Reimbursement, & more Work/Life Balance Nigel Affinity Executive Search