Database Admin, IBMi

Lincare, Inc.

Clearwater, FL, United States

27 days ago

Apply on www.indeed.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Db2400 IBM System I Databases Data Integrity IBM DB2 Relational Databases Database Schema IBM RPG (Programming Language) Software Engineering SQL Stored Procedures Enterprise Software Applications Cloud Platform System

+2 more

Database Performance Performance Monitor

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.

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

Requirements

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