Description

You will manage and maintain high-availability, high-performance DB2 environments, ensuring 24x7 availability for production and test systems.

Responsibilities

• Execute DBA functions including SQL code reviews, performance monitoring, and security enforcement.
• Manage backup/recovery strategies and coordinate Disaster Recovery planning.
• Resolve service and change requests, including DB2 Connect configuration issues.
• Collaborate with Data Center, Operations, Database, and Development teams on tuning.

Required Skills

• 10+ years of experience in DB2 z/OS Database Support (DB2 12 or higher in high-transaction production).
• Expertise in high-availability 24x7 designs and managing large data stores.
• Proficiency with DB2 attachments/interfaces: DRDA and DB2 Connect.
• Strong command of z/OS Mainframe skills: TSO & ISPF, JCL, REXX.
• Experience with DB2 tools: IBM Data Studio, Administration Tool, Query Monitor, OPTIM Workload Query Tuner.
• Capability in complex SQL coding, tuning, and Logical & physical Data Modeling.
• Knowledge of Data Warehouse & OLAP design/query solutions.
• Familiarity with DB2 V10 utilities setup and execution.

Preferred Skills

• DB2 V9 or V10 Certification.
• Experience with IMS Database & Utilities or ETL tools like Informatica.

Key Skills

Education

Any Gradute