IBM i (AS400) DB2 Developer

Intellics Global Services; Bengaluru; Hybrid; INR 1,800,000 - 2,400,000; Full time

Job summary

Intellics Global Services in Bengaluru is seeking an experienced IBM i DB2 Developer (P4) with 8+ years of hands-on DB2/AS400 expertise. The role focuses on designing stored procedures, tuning SQL, and building enterprise reports in an hybrid work setup.

You will collaborate with analysts and developers to translate requirements into robust database solutions, ensure data integrity, participate in code reviews and deployments, and document best practices.

Qualifications

• 8+ years of experience with DB2 for IBM i AS400 database development.
• Strong expertise in writing and optimizing stored procedures triggers and userdefined functions.
• Advanced SQL skills including query tuning and performance optimization.
• Experience with report development and data extraction for business intelligence.
• Familiarity with IBM i AS400 system tools and utilities.
• Understanding database security backup and recovery processes.
• Excellent problemsolving and communication skills.
• Strong experience with ODS concepts and data modeling DLM is essential.
• Proven ability to design and model application databases for transactional and reporting systems.

Responsibilities

• Design, develop and maintain DB2 stored procedures and database functions on IBM i AS400.
• Optimize and tune complex SQL queries for performance and scalability.
• Develop and maintain enterprise level reports using DB2 SQL and related tools.
• Collaborate with business analysts and application developers to understand requirements and translate them into efficient database solutions.
• Troubleshoot and resolve database related issues ensuring data integrity and system reliability.
• Participate in code reviews testing and deployment of database changes.
• Document database objects processes and best practices.

Skills

IBM AS400

SQL

DB2

Job description

Job Title

P4 - IBM i (AS400) DB2 Developer 1488521

Experience

8+ Years /

Hiring Locations

Bangalore preferably

Target Notice Period

Immediate to 1 week

Is remote work an option?

Hybrid

Must have skill / Mandatory

IBM AS400, SQL, DB2

JOB DESCRIPTION/ REQUIREMENTS

Key Responsibilities

• Design develop and maintain DB2 stored procedures and database functions on IBM i AS400
• Optimize and tune complex SQL queries for performance and scalability
• Develop and maintain enterprise level reports using DB2 SQL and related tools
• Collaborate with business analysts and application developers to understand requirements and translate them into efficient database solutions
• Troubleshoot and resolve database related issues ensuring data integrity and system reliability
• Participate in code reviews testing and deployment of database changes
• Document database objects processes and best practices

Required Skills Experience

• 8+ years of experience with DB2 for IBM i AS400 database development
• Strong expertise in writing and optimizing stored procedures triggers and userdefined functions
• Advanced SQL skills including query tuning and performance optimization
• Experience with report development and data extraction for business intelligence
• Familiarity with IBM i AS400 system tools and utilities
• Understanding database security backup and recovery processes
• Excellent problemsolving and communication skills
• Strong experience with Operational Data Store ODS concepts and data modeling DLM is essential
• Proven ability to design and model application databases for transactional and reporting systems