DB2 SQL Data Engineer

Inabia Software & Consulting Inc.; Houston (TX); Remote; USD 80,000 - 100,000; Full time

Job summary

A leading consulting company is seeking a Senior DB2 SQL Data Engineer to work in a remote capacity near Houston, TX. This role will involve database development, modernization of RPG programs, and application integration using iSeries tools. Ideal candidates will have significant experience in SQL and a strong background in database optimization practices.

Qualifications

• Proven track record as a Senior Database Developer in DB2 iSeries.
• Expertise in SQL stored procedures and database optimization.
• Solid understanding of RPG languages and modern development tools.

Responsibilities

• Develop and maintain SQL stored procedures in DB2 iSeries environment.
• Modernize and convert RPG programs to SQL-based applications.
• Collaborate with developers to integrate database solutions.

Skills

DB2

SQL

RPG programming

iSeries tools

Python

Tools

Aldon

RDI

ACS

VS Code IDE

Job description

This role is open to candidates authorized to work in the U.S. without sponsorship now or in the future. No C2C. To be considered, please submit an updated resume (maximum 3 pages) in MS Word format, ensuring consistent font size and proper grammar.

Role: DB2 SQL Data Engineer
Location: Remote (Should be Nearby Houston, TX)
Duration: 12+ months
Pay Rate: $48 - $60/hr

Must have skills: DB2, SQL, RPG programming andiSeries tools.
Python is nice to have.

We are seeking a Senior DB2 SQL Data Engineer with expert-level proficiency in SQL stored procedures and deep familiarity with the DB2 iSeries system (not Z/OS, not mainframe). The ideal candidate will have a strong database development and application coding background, particularly in modernizing and converting RPG programs to SQL. This role requires extensive hands-on experience in iSeries tools like Aldon, RDI, and ACS, alongside proficiency in contemporary development environments and languages such as Python, microservices, and VS Code IDE.

Responsibilities:

• Develop and maintain SQL stored procedures and scripts in the DB2 iSeries environment.
• Modernize and convert RPGIV, RPGLE, and RPGFree programs to SQLbased applications.
• Collaborate closely with application developers and analysts to integrate database solutions.
• Utilize iSeries tools such as Aldon, RDI (Rational Developer for i), and ACS (Access Client Solutions) for application development and deployment.
• Participate in design sessions and provide input for database architecture and application performance tuning.
• Ensure data integrity, security, and performance of the DB2 database environment.
• Write and maintain technical documentation related to database design, configuration, and processes.

Requirements:

• Proven track record as a Senior Database Developer with a focus on DB2 database development in iSeries environment.
• Expertise in SQL stored procedures, SQL scripting, and database optimization techniques.
• Solid understanding of RPG programming languages (RPGIV, RPGLE, RPGFree).
• Experience in application development beyond traditional green screen environments for iSeries.
• Proficiency in iSeries development tools such as Aldon, RDI, and ACS.
• Familiarity with modern programming languages and tools such as Python, microservices architecture, and VS Code IDE.
• Ability to work independently and as part of a team, with strong communication and problemsolving skills.
• Prior experience in converting legacy RPG programs to SQL-based applications is highly desirable.

Preferred Skills:

• Knowledge of Python programming and its integration with DB2 databases.
• Exposure to microservices architecture and RESTful API development.
• Familiarity with modern IDEs like VS Code for application development.

Inabia is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, citizenship, color, family or medical care leave, gender identity or expression, genetic information, immigration status, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran or military status, race, ethnicity, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable local laws, regulations and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application process, please let our hiring team know.