DB2 DBA/RPG Programmer

Full-time Direct Hire Remote Position - Working Eastern Time Hours

We seek a production DBA to manage DB2 databases on the IBM i 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.

*** Please note: This position involves 65% DB2 DBA / 35% Application Program m ing (RPG). ***

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 the redesign of existing systems to fulfill business needs.

- Monitors and evaluates the performance of IBM i DB2 databases

- Troubleshoots database performance issues.

- Manages database objects Libraries, views, tables, stored

procedures, and triggers.

- Supports developers and the 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 IBMi development

team.

- Creates technical support documentation for databases.

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

Qualifications:

- 10+ years of IBM i/iSeries/AS400 experience

- 7+years ofexperience supporting DB2 for IBM i 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 iDatabase

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

U.S. Citizens or Green Card holders only, please. We are unable to

accept 3rd party candidates, transfer a visa, or provide sponsorship at

this time.

Why is This a Great Opportunity:

Career growth opportunities

Stable and growing $2.5B healthcare company serving customers across the USA (Company has grown organically and through acquisitions)

Ongoing Business and Technology transformations

Matching 401k, Medical, Dental, Vision, Life, Tuition Reimbursement, & more

Work/Life Balance

Nigel

Apply for this position