DB2 Level 3 Engineer

4 days ago

Bengaluru, Karnataka, India Censoft Sdn Bhd Full time ₹ 15,00,000 - ₹ 35,00,000 per year

Position Summary

We are seeking a highly skilled DB2 Level 3 Engineer with deep expertise in DB2 database administration, performance tuning, and troubleshooting across IBM AS/400 (iSeries) and AIX platforms. This role is responsible for advanced incident resolution, root cause analysis, optimization, and providing guidance to the support teams.

Key Responsibilities

  • Provide Level 3 support for DB2 databases running on AS/400 (IBM iSeries) and AIX environments.
  • Lead complex incident investigations and drive root cause analysis for recurring database and system performance issues.
  • Perform advanced performance tuning, query optimization, and index management to ensure optimal DB2 performance.
  • Design and implement backup, recovery, and high availability (HA/DR) strategies.
  • Manage DB2 database security, access controls, and compliance with organizational standards.
  • Collaborate with application teams to optimize SQL queries, stored procedures, and database schemas.
  • Plan and execute DB2 upgrades, fix packs, and migration projects across AS/400 and AIX platforms.
  • Support capacity planning, system scaling, and performance benchmarking for critical workloads.
  • Develop and maintain technical documentation, standard operating procedures (SOPs), and knowledge base articles.
  • Mentor and provide technical guidance to Level 1 and Level 2 support teams.

Required Skills & Qualifications

  • Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
  • 8+ years of experience in DB2 database administration, with at least 5 years in Level 3 or senior support roles.
  • Strong expertise in DB2 for iSeries (AS/400) and DB2 LUW on AIX.
  • Hands-on experience with DB2 utilities, SQL tuning, query optimization, and workload management (WLM).
  • In-depth knowledge of backup/recovery strategies, HA/DR (HADR, TSA, Q Replication, MIMIX, etc.).
  • Familiarity with system-level troubleshooting on AIX and AS/400 (PASE, IFS, job logs, system values).
  • Experience in migration, patching, and version upgrades of DB2 environments.
  • Strong knowledge of ITIL processes (Incident, Problem, Change Management).
  • Excellent analytical and problem-solving skills, with ability to handle critical production issues under pressure.
  • Good communication skills to interact with application, infrastructure, and vendor teams.

Preferred/Good to Have

  • IBM DB2 Certification (DB2 DBA for LUW, DB2 for iSeries, etc.).
  • Experience with PowerHA, HACMP, BRMS, TSM, or Spectrum Protect.
  • Exposure to cloud-hosted DB2 environments or modernization projects.

Job Type: Contractual / Temporary

Contract length: 12 months

Pay: Up to ₹293,087.00 per month

Benefits:

  • Health insurance

  • DB2 Systems Programmer

    4 weeks ago

    Bengaluru, Karnataka, India TECEZE Full time

    Title: DB2 Systems Programmer Location: Chennai, Bangalore, Noida Mode: Hybrid Model Roles and Responsibilities: Key Responsibilities: DB2 Subsystem Management: Plan, prepare, and execute DB2 for z/OS subsystem installations, upgrades, and migrations (e.g., from DB2 12 to DB2 13, or between Function Levels). Apply IBM DB2 maintenance (PTFs, APARs, SPEs)...

  • DB2 Systems Programmer

    4 weeks ago

    Bengaluru, Karnataka, India TECEZE Full time

    Title: DB2 Systems ProgrammerLocation: Chennai, Bangalore, NoidaMode: Hybrid ModelRoles and Responsibilities:Key Responsibilities:- DB2 Subsystem Management:- Plan, prepare, and execute DB2 for z/OS subsystem installations, upgrades, and migrations (e.g., from DB2 12 to DB2 13, or between Function Levels).- Apply IBM DB2 maintenance (PTFs, APARs, SPEs)...

  • DB2 Systems Programmer

    3 weeks ago

    Bengaluru, Karnataka, India TECEZE Full time

    Title: DB2 Systems ProgrammerLocation: Chennai, Bangalore, NoidaMode: Hybrid ModelRoles and Responsibilities:Key Responsibilities: DB2 Subsystem Management: Plan, prepare, and execute DB2 for z/OS subsystem installations, upgrades, and migrations (e.g., from DB2 12 to DB2 13, or between Function Levels). Apply IBM DB2 maintenance (PTFs, APARs, SPEs)...

  • DB2 Systems Programmer

    23 hours ago

    Bengaluru, Karnataka, India TECEZE Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Title: DB2 Systems ProgrammerLocation: Chennai, Bangalore, NoidaMode: Hybrid ModelRoles and Responsibilities:Key Responsibilities:DB2 Subsystem Management:Plan, prepare, and execute DB2 for z/OS subsystem installations, upgrades, and migrations (e.g., from DB2 12 to DB2 13, or between Function Levels).Apply IBM DB2 maintenance (PTFs, APARs, SPEs) regularly...

  • DB2 Systems

    4 weeks ago

    Bengaluru, Karnataka, India TECEZE Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: BengaluruJob Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance tuning, high...

  • DB2 Systems

    4 weeks ago

    Bengaluru, Karnataka, India TECEZE Full time

    Job Title: DB2 Systems & Database Administrator Experience: 8–10 Years Location: Bengaluru Job Type: Full-time Role Overview We are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable) , performance...

  • DB2 Systems

    3 weeks ago

    Bengaluru, Karnataka, India TECEZE Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: Bengaluru Job Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance tuning,...

  • DB2 Systems

    2 days ago

    Bengaluru, Karnataka, India TECEZE Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Job Title:DB2 Systems & Database AdministratorExperience:8–10 YearsLocation:BengaluruJob Type:Full-timeRole OverviewWe are seeking an experiencedDB2 Systems & Database Administratorto manage, optimize, and support our DB2 database environments. The role requires strong expertise inDB2 administration (LUW/z/OS as applicable), performance tuning, high...

  • DB2 Database Administrator

    4 weeks ago

    Bengaluru, Karnataka, India TECEZE Full time

    Job Title: DB2 Database Administrator (DBA) – z/OS Platform Company: TECEZE Location: Bangalore / Chennai / Noida (Hybrid) Experience: 5+ Years Role Summary We are seeking an experienced DB2 Database Administrator (DBA) on the z/OS mainframe platform to join our team. The DBA will be responsible for the installation, configuration, performance tuning,...

  • DB2 Database Administrator

    3 weeks ago

    Bengaluru, Karnataka, India TECEZE Full time

    Job Title: DB2 Database Administrator (DBA) – z/OS PlatformCompany: TECEZELocation: Bangalore / Chennai / Noida (Hybrid)Experience: 5+ YearsRole SummaryWe are seeking an experienced DB2 Database Administrator (DBA) on the z/OS mainframe platform to join our team. The DBA will be responsible for the installation, configuration, performance tuning, security,...