Data Engineer

For over 16 years, Trilyon has been a leader in global workforce solutions, specializing in Cloud Technology, AI/ML, Software Development, Technical Writing, and Digital Transformation. We partner with top companies to deliver high-quality talent in engineering, IT, and emerging technologies. For additional information or to view all of our job opportunities, please visit our website https://trilyonservices.com/careers/ We are seeking a highly experienced Db2 Data Engineer for one of our cleint in Houston, TX. Title: Db2 Data Engineer Location: Houston, TX (Hybrid) Duration: 6+- Long term Job Summary: We are seeking a highly skilled DB2 Data Engineer with hands-on experience in the IBM iSeries (AS/400) environment. The ideal candidate will be proficient in developing and maintaining SQL-based applications, converting legacy RPG code to SQL stored procedures, and optimizing performance for enterprise-scale database systems. This role requires deep technical expertise in DB2, SQL stored procedures, and experience with modernization projects from RPG to SQL. Key Responsibilities: • Design, develop, and maintain database applications on the IBM iSeries platform. • Convert RPG code to SQL stored procedures in DB2 for improved performance and maintainability. • Perform query optimization, performance tuning, logging, and exception handling for DB2 applications. • Analyze and read RPGIV, RPGLE, and RPGFree programs with embedded SQL for modernization efforts. • Develop, test, and deploy DB2 SQL stored procedures following best practices. • Integrate back-end database logic with front-end applications using REST APIs and JSON. • Utilize IBM tools such as Aldon, RDI, and ACS for development and deployment. • Work on application modernization and migration from RPG-based systems to modern DB2 SQL architectures. • Implement source control and CI/CD processes using Git. • Collaborate with cross-functional teams to support data-driven solutions and business requirements. Required Skills & Qualifications: • Strong expertise in DB2 development on the IBM iSeries (AS/400) platform — must have experience creating and maintaining SQL stored procedures. • Proven experience with dynamic SQL, RPG-to-SQL conversion, and performance tuning. • Ability to read and interpret RPGIV, RPGLE, and RPGFree programs with embedded SQL. • Hands-on experience with IBM development tools — Aldon, RDI, ACS. • Experience developing or integrating with REST APIs and handling JSON data. • Exposure to Python, Microservices architecture, and VS Code IDE development. • Familiarity with Git source control and CI/CD pipelines. Preferred Qualifications: • Experience in application modernization or migration projects (RPG to SQL-based DB2). • Understanding of microservices-based architectures and containerized environments. • Excellent problem-solving skills with strong analytical and debugging abilities. • Strong communication and teamwork skills. Why Join Us? • Trilyon, Inc., offers a comprehensive benefits package. • Opportunities for growth and professional development. • Collaborative and inclusive company culture. Equal Employment Opportunity (EEO) Statement: • Trilyon, Inc., is an Equal Opportunity Employer committed to diversity, equity, and inclusion. We do not discriminate based on race, color, religion, gender, gender identity, sexual orientation, national origin, age, disability, veteran status, or any other protected status under applicable laws. Our diverse team drives innovation, competitiveness, and creativity, enhancing our ability to effectively serve our clients and communities. This commitment to diversity makes us stronger and more adaptable