Mainframe Infra-DB2 LUW

Chief Mainframe Infra DB2 LUW

Key Responsibilities:

• Manage support and operations of

  DB2 LUW, QREP, and CDC

  database solutions implemented within the bank.
• Handle

  Incident, Change, and Problem Management

  for DB2 LUW, QREP, and CDC environments as per

  ITIL

  framework.
• Proactively monitor database performance and capacity trends, initiating improvements as needed.
• Apply and automate

  fix packs, cumulative updates, and hotfixes

  to ensure systems remain up-to-date.
• Perform regular

  health checks, monitoring, backup, space management, and maintenance

  activities.
• Follow up on

  CIRATS (Compliance, Issue, Risk)

  related to database systems.
• Manage

  user access and BAU (Business As Usual)

  database activities.
• Setup and maintain

  data replication services

  (QREP, CDC) ensuring data consistency and availability.
• Plan and execute

  disaster recovery and business continuity

  processes, including backup and point-in-time recovery.
• Perform

  database performance tuning and troubleshooting

  to optimize system responsiveness.
• Participate in a

  24x7 on-call support rotation

  for DB2 LUW, QREP, and CDC portfolios and related applications.
• Provide

  best-in-class solutions

  to meet evolving business needs.
• Identify opportunities and lead initiatives to implement

  best technical practices

  to reduce technical debt and operational costs.
• Manage physical database infrastructure including storage management, access procedures, security, monitoring, and tuning.
• Analyze

  system storage capacity

  and recommend improvements for efficiency and scalability.
• Assist in designing and implementing the

  physical framework

  of databases.
• Support

  Operational DBAs

  with database tuning and performance optimization when required.

Required Skills and Experience:

• Extensive experience managing

  DB2 LUW

  environments with strong operational and support background.
• Proven expertise with

  QREP (Query Replication)

  and

  CDC (Change Data Capture)

  technologies.
• Strong knowledge of

  ITIL

  processes for Incident, Change, and Problem Management.
• Experience in

  database performance tuning, capacity planning, and disaster recovery

  .
• Hands-on experience applying patches, fix packs, and automating update processes.
• Familiarity with

  backup/recovery strategies

  , including point-in-time recovery.
• Knowledge of

  data replication setup and maintenance

  .
• Excellent troubleshooting and root cause analysis skills.
• Ability to work in a

  24x7 on-call rotation

  environment.
• Strong leadership and collaboration skills to work with multiple stakeholders and teams.
  

Preferred Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
• Certifications in DB2, ITIL, or relevant database technologies.
• Experience in banking or financial services domain is a plus.