Mainframe DB2 DBA – 8+ Years Experience

About the role

We are seeking an experienced Mainframe DB2 DBA to join our IT consulting team. The role focuses on performance optimization, data replication, and modernization of large‑scale DB2 environments supporting critical financial applications.

Key responsibilities

• Analyze and optimize Mainframe DB2 performance, including batch processes and code refactoring.
• Implement and support Q Replication, CDC Replication, and other data integration solutions.
• Tune DDF workloads, manage system behavior, and maintain Accelerated (IDAA) tables.
• Automate repetitive operational tasks and drive modernization strategies for mainframe data systems.
• Provide 24×7 on‑call support, develop runbooks, and ensure operational resilience through root‑cause analysis.
• Maintain database policies for disaster recovery, security, maintenance, and audit compliance.
• Collaborate with cross‑functional teams, vendors, and SMEs to support strategic transformation projects.

Required profile

• 8+ years of experience as a Mainframe DB2 DBA with strong performance‑tuning expertise.
• Proven experience with Q Replication, data‑sharing environments, and large‑scale SysPlex architectures.
• Strong analytical, problem‑solving, and automation/scripting skills.
• Ability to work in a 24×7 support model and lead tasks with a proactive attitude.

Required skills

• Mainframe DB2 administration
• Q Replication and CDC Replication
• Performance tuning and DDF workload management
• Automation/scripting (e.g., shell, REXX)
• SysPlex and data‑sharing environments
• IDAA, IDAA Bulk Loader, Accelerated tables
• Db2 LUW and Db2 client
• Diagnostic and root‑cause analysis tools
• DR, security, and audit compliance policies
• SDLC and Agile methodologies
• Software configuration management systems