IBM i (AS400) DB2 DBA

Overview

Remote
Depends on Experience
Full Time

Skills

DB2 for IBMi
IBM DB2 for iSeries
DB2 DBA for IBM i
SQL
RPG Free
Database performance tuning
database normalization
Database Administration
IBM iSeries
Performance Monitoring
Optimization
Stored Procedures

Job Details

Full-time (Direct Hire) | Remote Position - Working Eastern Time Hours

We have a full-time (direct hire) position for a DBA to manage DB2 databases on the IBMi for our large enterprise client. This is a remote position working Eastern time business hours. Candidates must live in the US, preferably on the East Coast.

You will be responsible for the administration, capacity planning, engineering/design, performance monitoring, and optimization of the DB2 for I database platform.

  • Supports the design and implementation of new database environments and redesign of existing systems to fulfill business needs.
  • Monitors and evaluates the 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.
  • Work with application development teams to develop data models that support business processes.
  • Ensure DB changes adhere to best practices.
  • Review all proposed database changes proposed by IBM i development team.
  • Creates technical support documentation for databases.
  • Acts as an SME on IBMI database structure and environment.
  • 65% DB2 DBA - 35% Application Developer (RPG).

REQUIREMENTS:

    • 10+ years of IBMi/iSeries/AS400 experience
    • 7+ years of experience supporting DB2 for databases in an enterprise environment. Experience working with enterprise applications
    • Proven 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.
    • Hands-on experience using system performance tools such as Job Watcher, Collection Services, PEX Analyzer, or similar tools (preferred)
    • Experience using Turnover, Aldon, or similar change management tools

We are unable to accept 3rd party candidates, transfer a visa or provide sponsorship, at this time.

      ibmi as400 as/400 as-400 os400 series "IBM i" idatabase RPG sql

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.