DB2 Database Engineer ( db2 IBM iseries platform ) at Inabia Software & Consulting Inc.

📍 Job Overview

Job Title: DB2 Database Engineer (Db2 IBM iSeries Platform)
Company: Inabia Software & Consulting Inc.
Location: Houston, Texas, United States
Job Type: Contractor (Hybrid - 3 days on-site)
Category: Database Administrator / Engineer
Date Posted: June 11, 2025
Experience Level: Mid-Senior level (5-10 years)
Remote Status: On-site (Hybrid)

🚀 Role Summary

Key Responsibilities: Develop and maintain database applications on the IBM iSeries platform using Db2. Utilize dynamic SQL, temporary and temporal tables, convert RPG code to SQL stored procedures, and perform performance tuning.
Key Skills: Db2, IBM iSeries Platform, Dynamic SQL, Temporary Tables, Temporal Tables, RPG Code Conversion, SQL Stored Procedures, Commitment Control, Performance Tuning, Logging, Exception Handling, REST APIs, Json, XML, Python, Microservices.
📝 Enhancement Note: This role requires expert-level SQL stored procedures development experience in the Db2 IBM iSeries platform, making it an excellent fit for experienced database engineers looking to leverage their skills in a hybrid work environment.

💻 Primary Responsibilities

Database Application Development & Maintenance: Develop and maintain various database applications on the IBM iSeries platform using Db2, utilizing dynamic SQL, temporary and temporal tables, and converting RPG code to SQL stored procedures.
Performance Tuning: Optimize database performance by identifying bottlenecks, implementing indexing strategies, and refining SQL queries.
Exception Handling & Logging: Implement robust exception handling and logging mechanisms to ensure data integrity and facilitate troubleshooting.
Front-end Interaction: Collaborate with front-end developers to integrate database applications with REST APIs, JSON, and XML.
Tool Proficiency: Leverage IBM tools such as Aldon, RDI, and ACS to manage and develop database applications on the IBM iSeries platform.
Modernization & Conversion: Convert RPG code to SQL stored procedures and modernize legacy applications to improve performance and maintainability.
📝 Enhancement Note: This role involves a mix of application development, performance optimization, and collaboration with front-end teams, requiring a well-rounded database engineer with strong SQL and RPG skills.

🎓 Skills & Qualifications

Education: Bachelor's degree in Computer Science, Information Technology, or a related field. Relevant certifications (e.g., IBM Data Science Professional Certificate) are a plus.

Experience: 5-10 years of experience in database administration or a related role, with a strong focus on Db2 and the IBM iSeries platform. Proven expertise in SQL stored procedures development is essential.

Required Skills:

Expertise in Db2 and the IBM iSeries platform
Proficiency in dynamic SQL, temporary tables, and temporal tables
Strong RPG code conversion skills (RPGIV, RPGLE, RPGFree)
Experience with commitment control, procedures, table functions, UDFs, logging, and exception handling
Familiarity with IBM tools such as Aldon, RDI, and ACS
Experience with REST APIs, JSON, and XML
Basic knowledge of Python and microservices

Preferred Skills:

Experience with data warehousing and business intelligence tools
Familiarity with Agile development methodologies
Knowledge of cloud platforms (e.g., AWS, Azure, Google Cloud)
Experience with containerization and orchestration tools (e.g., Docker, Kubernetes)

📝 Enhancement Note: Candidates with a strong background in SQL stored procedures development and experience with the IBM iSeries platform are highly encouraged to apply. Familiarity with modern development tools and practices will be an asset in this role.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

Demonstrate expertise in Db2 and the IBM iSeries platform with relevant projects showcasing SQL stored procedures development, performance tuning, and exception handling.
Highlight experience with RPG code conversion and modernization projects.
Include examples of integrating database applications with front-end technologies using REST APIs, JSON, and XML.
Showcase proficiency in IBM tools such as Aldon, RDI, and ACS with relevant project examples.

Technical Documentation:

Provide clear and concise documentation for SQL stored procedures, including input parameters, output values, and error handling.
Include performance analysis and optimization strategies for database applications.
Demonstrate understanding of data integrity and security best practices with relevant documentation.

📝 Enhancement Note: A strong portfolio focusing on Db2 and the IBM iSeries platform, along with relevant documentation, will help candidates stand out in the application process.

💵 Compensation & Benefits

Salary Range: $90,000 - $120,000 USD per year (Based on experience and market research for Houston, Texas)

Benefits:

Competitive salary and benefits package
Opportunities for professional development and training
Hybrid work arrangement with 3 days on-site in Houston, Texas
Collaborative and inclusive work environment

Working Hours: Full-time (40 hours/week) with flexible hours and the ability to work remotely for 2 days a week.

📝 Enhancement Note: The salary range is estimated based on market research for Houston, Texas, and the candidate's experience level. Benefits and working hours are subject to change and should be verified with the hiring organization.

🎯 Team & Company Context

🏢 Company Culture

Industry: Information Technology and Services

Company Size: Medium (51-200 employees)

Founded: 1999

Team Structure:

The database team consists of experienced database administrators and engineers, working collaboratively to maintain and develop database applications on the IBM iSeries platform.
The team follows an Agile development methodology, with regular sprint planning and code reviews.
Cross-functional collaboration with front-end developers, project managers, and other teams is essential for success in this role.

Development Methodology:

The team follows an Agile/Scrum development methodology, with regular sprint planning and code reviews.
Code reviews are conducted to ensure code quality, performance, and maintainability.
Deployment strategies include CI/CD pipelines and automated deployment processes.

Company Website: https://www.inabia.com/

📝 Enhancement Note: Inabia Software & Consulting Inc. is a medium-sized IT services company with a strong focus on database administration and development. The company's collaborative work environment and Agile development methodologies make it an attractive choice for experienced database engineers.

📈 Career & Growth Analysis

Web Technology Career Level: Mid-Senior level database engineer with a strong focus on Db2 and the IBM iSeries platform. This role involves a mix of application development, performance optimization, and collaboration with front-end teams.

Reporting Structure: This role reports directly to the Database Team Lead, who is responsible for managing the database team and ensuring the delivery of high-quality database applications.

Technical Impact: The database engineer will have a significant impact on the performance, scalability, and maintainability of database applications on the IBM iSeries platform. They will work closely with front-end developers to ensure seamless integration and optimal user experience.

Growth Opportunities:

Technical Growth: Expand expertise in Db2, the IBM iSeries platform, and related technologies to become a subject matter expert in the team.
Leadership Growth: Develop leadership skills by mentoring junior team members, leading projects, and driving technical decision-making.
Architecture Growth: Gain experience in database architecture and design, contributing to the overall architecture of the company's technology stack.

📝 Enhancement Note: This role offers significant growth opportunities for experienced database engineers looking to advance their careers in a collaborative and supportive work environment.

🌐 Work Environment

Office Type: Hybrid work environment with 3 days on-site in Houston, Texas, and 2 days remote work per week.

Office Location(s): Houston, Texas, United States

Workspace Context:

The on-site workspace is designed to facilitate collaboration and communication among team members.
Multiple monitors and testing devices are available to ensure optimal productivity and performance.
The work environment encourages knowledge sharing, technical mentoring, and continuous learning.

Work Schedule: Full-time (40 hours/week) with flexible hours and the ability to work remotely for 2 days a week.

📝 Enhancement Note: The hybrid work environment at Inabia Software & Consulting Inc. offers a balance between on-site collaboration and remote flexibility, allowing database engineers to maintain a healthy work-life balance.

📄 Application & Technical Interview Process

Interview Process:

Phone/Video Screen: A brief phone or video call to discuss the candidate's experience, skills, and fit for the role.
Technical Assessment: A hands-on technical assessment focusing on SQL stored procedures development, performance tuning, and exception handling in the Db2 and IBM iSeries platform.
Behavioral Interview: A structured interview to assess the candidate's problem-solving skills, communication, and cultural fit.
Final Interview: A final interview with the Database Team Lead to discuss the candidate's fit for the role and answer any remaining questions.

Portfolio Review Tips:

Highlight relevant Db2 and IBM iSeries platform projects, demonstrating expertise in SQL stored procedures development, performance tuning, and exception handling.
Include examples of integrating database applications with front-end technologies using REST APIs, JSON, and XML.
Showcase proficiency in IBM tools such as Aldon, RDI, and ACS with relevant project examples.

Technical Challenge Preparation:

Brush up on SQL stored procedures development, performance tuning, and exception handling in the Db2 and IBM iSeries platform.
Familiarize yourself with IBM tools such as Aldon, RDI, and ACS.
Prepare for questions related to RPG code conversion, modernization, and integration with front-end technologies.

ATS Keywords: Db2, IBM iSeries Platform, SQL, Stored Procedures, Performance Tuning, Logging, Exception Handling, RPG, REST APIs, JSON, XML, Python, Microservices, Aldon, RDI, ACS, Agile, Scrum, Data Warehousing, Business Intelligence, Cloud Platforms, Containerization, Orchestration, Data Integrity, Security.

📝 Enhancement Note: The interview process at Inabia Software & Consulting Inc. is designed to assess the candidate's technical skills, problem-solving abilities, and cultural fit. Preparing for the technical assessment and behavioral interview will be crucial for success in the application process.

🛠 Technology Stack & Web Infrastructure

Database Technologies:

Db2 (expertise required)
IBM iSeries Platform (expertise required)
SQL (expertise required)
Temporary Tables (expertise required)
Temporal Tables (expertise required)
Commitment Control (expertise required)
Procedures, Table Functions, UDFs (expertise required)
Logging and Exception Handling (expertise required)

Programming Languages:

RPG (RPGIV, RPGLE, RPGFree) (expertise required)
SQL (expertise required)
Python (basic knowledge required)

Tools & Frameworks:

IBM Tools (Aldon, RDI, ACS) (expertise required)
REST APIs (expertise required)
JSON (expertise required)
XML (expertise required)
VS Code IDE (basic knowledge required)

📝 Enhancement Note: This role requires expertise in Db2, the IBM iSeries platform, and related technologies. Candidates with strong SQL and RPG skills, as well as experience with IBM tools and front-end integration, will be well-suited for this opportunity.

👥 Team Culture & Values

Database Team Values:

Expertise: Demonstrate a deep understanding of Db2, the IBM iSeries platform, and related technologies.
Collaboration: Work effectively with front-end developers, project managers, and other teams to deliver high-quality database applications.
Performance: Focus on optimizing database performance, scalability, and maintainability.
Innovation: Stay up-to-date with emerging technologies and best practices in database administration and development.

Collaboration Style:

The database team follows an Agile/Scrum development methodology, with regular sprint planning and code reviews.
Code reviews are conducted to ensure code quality, performance, and maintainability.
The team encourages knowledge sharing, technical mentoring, and continuous learning.

📝 Enhancement Note: The database team at Inabia Software & Consulting Inc. values expertise, collaboration, performance, and innovation. Candidates who embody these values will thrive in this collaborative and supportive work environment.

⚡ Challenges & Growth Opportunities

Technical Challenges:

Performance Optimization: Identify and address performance bottlenecks in database applications on the IBM iSeries platform.
Modernization: Convert RPG code to SQL stored procedures and modernize legacy applications to improve performance and maintainability.
Integration: Collaborate with front-end developers to integrate database applications with REST APIs, JSON, and XML.
Emerging Technologies: Stay up-to-date with emerging technologies and best practices in database administration and development.

Learning & Development Opportunities:

Technical Skill Development: Expand expertise in Db2, the IBM iSeries platform, and related technologies through hands-on projects and continuous learning.
Leadership Development: Develop leadership skills by mentoring junior team members, leading projects, and driving technical decision-making.
Architecture Decision-Making: Gain experience in database architecture and design, contributing to the overall architecture of the company's technology stack.

📝 Enhancement Note: This role presents numerous technical challenges and growth opportunities for experienced database engineers looking to advance their careers in a collaborative and supportive work environment.

💡 Interview Preparation

Technical Questions:

SQL Stored Procedures: Prepare for in-depth questions related to SQL stored procedures development, performance tuning, and exception handling in the Db2 and IBM iSeries platform.
RPG Code Conversion: Brush up on your RPG code conversion skills and be prepared to discuss modernization projects and strategies.
Front-end Integration: Familiarize yourself with REST APIs, JSON, and XML, and prepare for questions related to integrating database applications with front-end technologies.

Company & Culture Questions:

Company Culture: Research Inabia Software & Consulting Inc. and be prepared to discuss how your values and work style align with the company's culture.
Agile Methodologies: Brush up on your understanding of Agile/Scrum development methodologies and be prepared to discuss how you've applied them in previous roles.
Data Integrity & Security: Familiarize yourself with best practices for data integrity and security, and be prepared to discuss how you've implemented them in previous projects.

Portfolio Presentation Strategy:

Project Selection: Choose relevant Db2 and IBM iSeries platform projects that demonstrate your expertise in SQL stored procedures development, performance tuning, and exception handling.
Code Walkthrough: Prepare a clear and concise code walkthrough, highlighting your problem-solving skills, performance optimization strategies, and exception handling mechanisms.
User Experience Focus: Emphasize the user experience impact of your database applications and how you've optimized them for performance and scalability.

📝 Enhancement Note: Preparing for technical questions related to Db2, the IBM iSeries platform, and front-end integration will be crucial for success in the interview process. Additionally, researching the company's culture and being prepared to discuss your alignment with its values will help demonstrate your fit for the role.

📌 Application Steps

To apply for this DB2 Database Engineer position at Inabia Software & Consulting Inc.:

Customize Your Portfolio: Tailor your portfolio to highlight relevant Db2 and IBM iSeries platform projects, demonstrating your expertise in SQL stored procedures development, performance tuning, and exception handling.
Optimize Your Resume: Highlight your relevant experience, skills, and achievements in database administration and development, with a focus on Db2, the IBM iSeries platform, and front-end integration.
Prepare for Technical Challenges: Brush up on your SQL stored procedures development, performance tuning, and exception handling skills in the Db2 and IBM iSeries platform. Familiarize yourself with IBM tools such as Aldon, RDI, and ACS.
Research the Company: Learn about Inabia Software & Consulting Inc.'s culture, values, and work environment to ensure a strong fit for your career goals and work style.

📝 Enhancement Note: Tailoring your portfolio, optimizing your resume, and preparing for technical challenges will be essential for success in the application process. Additionally, researching the company and being prepared to discuss your alignment with its values will help demonstrate your fit for the role.

Content Guidelines (IMPORTANT: Do not include this in the output)

Web Technology-Specific Focus:

Tailor every section specifically to database administration and development roles, with a strong focus on Db2 and the IBM iSeries platform.
Include web technology methodologies, performance optimization, and user experience considerations.
Address web technology career progression, emerging technology adoption, and technical specialization in database administration and development.

Quality Standards:

Ensure no content overlap between sections - each section must contain unique information.
Only include Enhancement Notes when making significant inferences about web technology processes, server configuration, or team structure.
Be comprehensive but concise, prioritizing actionable information over descriptive text.
Strategically distribute web technology-related keywords throughout all sections naturally.
Provide realistic salary ranges based on location, experience level, and web technology specialization.

Industry Expertise:

Include specific web technologies, frameworks, server platforms, and infrastructure tools relevant to the role.
Address web technology career progression paths and technical leadership opportunities in web teams.
Provide tactical advice for web portfolio development, live demonstrations, and project case studies.
Include web technology-specific interview preparation and coding challenge guidance.
Emphasize performance optimization, accessibility standards, and user experience principles in web technology roles.

Professional Standards:

Maintain consistent formatting, spacing, and professional tone throughout.
Use web technology industry terminology appropriately and accurately.
Include comprehensive benefits and growth opportunities relevant to web technology professionals.
Provide actionable insights that give web technology candidates a competitive advantage.
Focus on web technology team culture, cross-functional collaboration, and user impact measurement.

Technical Focus & Portfolio Emphasis:

Emphasize web technology best practices, performance optimization, and user experience design principles.
Include specific portfolio requirements tailored to the web technology discipline and role level.
Address browser compatibility, accessibility standards, and user experience design principles.
Focus on problem-solving methods, performance optimization, and scalable web architecture.
Include technical presentation skills and stakeholder communication for web projects.

Avoid:

Generic business jargon not relevant to web technology roles.
Placeholder text or incomplete sections.
Repetitive content across different sections.
Non-technical terminology unless relevant to the specific web technology role.
Marketing language unrelated to web technology, server administration, or user experience.

Generate comprehensive, web technology-focused content that serves as a valuable resource for web developers, server administrators, and infrastructure professionals evaluating career opportunities and preparing for technical interviews in the web development industry.

DB2 Database Engineer ( db2 IBM iseries platform )