Ibmi Database Administrator

Lincare is the nation’s leading provider of oxygen, durable medical equipment and clinical respiratory services. We are currently seeking a Database Admin, IBMi to join our Corporate Headquarters in Clearwater, FL.

WHY WORK AT LINCARE?

• Culture- An inclusive, open and friendly environment focused on our associates and their success
• Benefits- Comprehensive benefits package with flexible options to fit your individual needs
• Growth- An industry leader who continues to transform the way respiratory care is delivered to our patients

Job Description:

The IBMi DBA is responsible for planning, designing, developing and configuring of 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 for the DB2 for I database platform. Candidates should be able to adapt to rapidly changing environments and technology.

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

· Performs other duties as assigned

· Complies with all policies and standards

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

· Relevant certifications or training preferred

· 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 candidates 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.

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Referral program
• Retirement plan
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday

Work Location: Remote