Database Admin, IBMi

Lincare • Clearwater, FL

1d

About The Position

This employee is responsible for planning, designing, developing, and configuring database systems to meet business needs and requests. The role is a mix of development and production DBA responsibilities. Responsible for administration, capacity planning, engineering/design, performance monitoring, and optimization of the DB2 for I database platform. Should be able to adapt to rapidly changing environments and technology.

Requirements

• Bachelor's Degree Required
• 10+ years of IBMi/iSeries/AS400 experience Required
• 7+ years of experience supporting DB2 for databases in an enterprise environment Required
• Experience working with enterprise applications Required
• Demonstrable 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
• Effective verbal and written communication

Nice To Haves

• Relevant certifications or training Preferred
• Hands-on experience using system performance tools such as Job Watcher, Collection Services, PEX Analyzer, or similar tools
• Experience using Turnover, Aldon, or similar change management tools

Responsibilities

• Supports the design and implementation of new database environments and redesign of existing systems to fulfill business needs
• Monitors and evaluates performance of IBMi databases
• Troubleshoots database performance issues
• Manages database objects (Libraries, views, tables, stored procedures, triggers)
• Supports developers and testing team by maintaining test environments and configuring databases to development specifications
• Works with application development teams to develop data models that support business processes
• Ensures DB changes adhere to best practices
• Reviews all proposed DB changes proposed by IBMi development team
• Creates technical support documentation for databases
• Acts as a SME on IBMI database structure and environment

What This Job Offers

• Job Type: Full-time
• Career Level: Senior