Sign in

IBMi/AS400 DB2 DBA

Company:
Rita Technology Services
Location:
Tampa, FL
Posted:
April 15, 2021

Description:

Newly created, direct-hire position for an IBMi DB2 DBA to join our growing client in Tampa, FL. This can be a remote role on a per case basis or someone willing to relocate to Tampa Bay in the future.

*** Please Note: Your duties will be asked to split some time as DBA and Developer (65% DB2 DBA - 35% Application Developer (RPG ILE/Free) ***

In this role, you will be 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.

The DBA is responsible for administration, capacity planning, engineering / design, performance monitoring, and optimization for the DB2 for IBMi/iSeries database platform.

Duties & Responsibilities:

Supports the design and implementation of new database environments and redesigns of existing systems to fulfill business needs.

Monitors and evaluates the performance of IBMi DB2 databases

Troubleshoots database performance issues.

Manages database objects – Libraries, views, tables, stored procedures, and triggers.

Supports developers and testing teams 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.

Reviews all proposed DB changes proposed by IBMi development team.

Creates technical support documentation for databases.

Acts as an SME on IBMI DB2 database structure and environment.

Will be asked to split some time as DBA and Developer (65% DB2 DBA - 35% Application Developer (RPG).

REQUIREMENTS:

Bachelor’s degree (or equivalent experience)

10+ years of IBMi/iSeries/AS400 experience

7+ years of experience supporting DB2 for databases in an enterprise environment.

Experience working with enterprise applications

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

Must be a US Citizen, Green Card holder, or possess a valid GC EAD.

Apply