Database Admin, IBMi

Lincare Holdings; Clearwater (FL); On-site; USD 95,000 - 150,000; Full time

Job summary

Lincare Holdings in Clearwater, FL seeks an experienced IBMi/DB2 for i specialist to plan, design, develop, and optimize DB2 for i database environments. You will support development and testing teams, ensuring best-practice database changes and robust data models aligned with business processes.

Required are 10+ years IBMi/iSeries experience and 7+ years DB2 for i in enterprise settings; bachelor's degree and enterprise application exposure are essential.

Qualifications

• Bachelor's Degree required.
• 10+ years IBMi/iSeries/AS400 experience required.
• 7+ years of experience supporting DB2 for databases in an enterprise environment required.
• Experience working with enterprise applications required.
• Certifications or training preferred.

Responsibilities

• Administer, plan, design, develop and configure DB2 for i on the IBMi platform to meet business needs.
• Monitor performance and optimize database systems; troubleshoot performance issues.
• Support developers and testing teams by maintaining test environments and configuring databases to development specifications.
• Collaborate with application teams to design data models supporting business processes.
• Review DB changes proposed by IBMi development teams and ensure adherence to best practices.
• Create technical documentation for databases; act as SME on IBMI database structure and environment.

Skills

IBMi/iSeries expertise

DB2 for iSQL knowledge

Performance tuning

RPG (ILE/Free)

SQL and data modeling

Communication skills

Education

Bachelor's Degree

Tools

Plan Cache

Visual Explain

Index Advisor

Detailed Database Monitor

Job Watcher

Collection Services

PEX Analyzer

Aldon

Job description

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.

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.

Job Functions

• 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.

Education

• Bachelor's Degree Required

Work Experience

• 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
• Relevant certifications or training Preferred

Knowledge, Skills, and Abilities

• 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.
• Preference given to someone with 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.