Senior Db2 Database Specialist

3 days ago

Bengaluru Chennai, India 7ac82f8e-ab07-41ab-b1a6-82d16edd2564 Full time ₹ 15,00,000 - ₹ 30,00,000 per year

Responsibilities:

  • Install, configure, upgrade, and maintain DB2 subsystems on z/OS.
  • Perform DB2 system programming tasks including subsystem initialization, buffer pool tuning, logging setup, and storage management.
  • Manage and support IBM IDAA (IBM Db2 Analytics Accelerator) including integration, performance tuning, workload configuration, and problem resolution.
  • Architect and implement DB2 and IMS database solutions for high availability, resilience, and scalability.
  • Oversee IMS DB/DC and IMS DB2 integration environments.
  • Troubleshoot system-level issues related to DB2, IMS, z/OS, IDAA, RACF, and related middleware.
  • Plan and execute DB2 migration, version upgrades, maintenance, PTFs, and APARs.
  • Perform performance analysis using RMF, OMEGAMON, Mainview, and DB2 performance tools.
  • Work closely with application teams for SQL analysis, query optimization, and schema design.
  • Manage backup/restore, disaster recovery, and system recovery processes.
  • Ensure compliance with security, audit, and regulatory requirements on mainframe systems.
  • Support capacity planning and infrastructure architecture for DB2 and IMS environments.

Required Skills:

  • Strong experience in DB2 System Programming on z/OS.
  • Hands-on expertise with IDAA administration and workload setup.
  • Deep understanding of IMS DB, IMS TM, IMS DB2 interdependencies.
  • Proficiency in JCL, REXX, SMP/E, z/OS utilities, and automation tools.
  • Experience with data sharing, sysplex, performance tuning, buffer pool management.
  • Knowledge of Mainframe security (RACF) and storage management (SMS).
  • Strong problem-solving skills in high-availability mainframe environments.

Experience Required:

  • 815+ years in Mainframe DB2 / IMS / IDAA system programming or architecture.
  • Prior experience in enterprise-level mainframe modernization, optimization, or migration projects.

Preferred:

  • IBM Certified DB2 for z/OS Database Administrator or System Administrator.
  • Experience with Cloud Pak for Data (CP4D) or Db2 Analytics Accelerator enhancements.

  • Senior Database Administrator

    1 week ago

    Chennai, India Ensono Technologies LLP Full time

    About the Role :We are seeking a highly skilled Senior Database Administrator (DB2 Logical) to join our team. The ideal candidate will bring deep technical expertise, strong analytical capabilities, and leadership qualities to support and optimize enterprise-level database environments. This role involves working on complex assignments, mentoring junior team...

  • DB2 Specialist

    2 weeks ago

    Bengaluru, India Kyndryl Full time

    DB2 Specialist - IDAA Systems Programmer Key Responsibilities: IDAA Installation & Management: Install, configure, and maintain IDAA using tools like GUI Management Console, Data Studio, and Admin Services. Data Synchronization: Manage and troubleshoot Db2-IDAA data sync for optimized query performance. IDAA Loader Administration: Install, configure, and...

  • DB2 Specialist

    2 weeks ago

    Bengaluru, India Kyndryl Full time

    DB2 Specialist - IDAA Systems Programmer Key Responsibilities: - IDAA Installation & Management: Install, configure, and maintain IDAA using tools like GUI Management Console, Data Studio, and Admin Services. - Data Synchronization: Manage and troubleshoot Db2-IDAA data sync for optimized query performance. - IDAA Loader Administration: Install, configure,...

  • DB2 Specialist

    2 weeks ago

    Bengaluru, India Kyndryl Full time

    DB2 Specialist - IDAA Systems Programmer Key Responsibilities: IDAA Installation & Management: Install, configure, and maintain IDAA using tools like GUI Management Console, Data Studio, and Admin Services. Data Synchronization: Manage and troubleshoot Db2-IDAA data sync for optimized query performance. IDAA Loader Administration: Install, configure, and...

  • DB2 Specialist

    2 weeks ago

    Bengaluru, India Kyndryl Full time

    DB2 Specialist - IDAA Systems ProgrammerKey Responsibilities:- IDAA Installation & Management: Install, configure, and maintain IDAA using tools like GUI Management Console, Data Studio, and Admin Services.- Data Synchronization: Manage and troubleshoot Db2-IDAA data sync for optimized query performance.- IDAA Loader Administration: Install, configure, and...

  • DB2 Specialist

    2 weeks ago

    Bengaluru, India Kyndryl Full time

    DB2 Specialist - IDAA Systems ProgrammerKey Responsibilities:IDAA Installation & Management: Install, configure, and maintain IDAA using tools like GUI Management Console, Data Studio, and Admin Services.Data Synchronization: Manage and troubleshoot Db2-IDAA data sync for optimized query performance.IDAA Loader Administration: Install, configure, and...

  • DB2 Specialist

    2 weeks ago

    Bengaluru, India Kyndryl Full time

    DB2 Specialist - IDAA Systems ProgrammerKey Responsibilities:IDAA Installation & Management: Install, configure, and maintain IDAA using tools like GUI Management Console, Data Studio, and Admin Services.Data Synchronization: Manage and troubleshoot Db2-IDAA data sync for optimized query performance.IDAA Loader Administration: Install, configure, and...

  • DB2 Database Admin

    6 days ago

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

    Job Description:As part of the Infosys delivery team your primary role would be to ensure effective Design Development Validation and Support activities to assure that our clients are satisfied with the high levels of service in the technology domainYou will gather the requirements and specifications to understand the client requirements in a detailed manner...

  • Mainframe DB2 Database administrator

    1 week ago

    Bengaluru, Chennai, India Iatocs Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Role & responsibilitiesInstall, configure, upgrade, and maintain DB2 subsystems on z/OS.Perform database performance monitoring and tuning (buffer pool tuning, SQL optimization, etc.).Administer DB2 utilities (REORG, RUNSTATS, LOAD, UNLOAD, COPY, etc.).Manage schema changes, object creation, and DDL/DML execution.Collaborate with application developers to...

  • DB2 Specialist

    2 weeks ago

    Bengaluru, Karnataka, India Kyndryl Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    DB2 Specialist - IDAA Systems ProgrammerKey Responsibilities:IDAA Installation & Management: Install, configure, and maintain IDAA using tools like GUI Management Console, Data Studio, and Admin Services.Data Synchronization: Manage and troubleshoot Db2-IDAA data sync for optimized query performance.IDAA Loader Administration: Install, configure, and...