Job Description

We are seeking an experienced DB2 Database Administrator to manage, optimize, and support enterprise-level DB2 LUW environments. The role involves overseeing database upgrades, performance tuning, high availability setups, and vendor coordination, while ensuring reliability and scalability of mission-critical systems.

n

Key Responsibilities

n

n
- DB2 LUW Management: Administer DB2 versions 10.1, 10.5, 11.1, and 11.5.
n
- Database Upgrades: Perform version upgrades and patch updates.
n
- Health Monitoring: Conduct regular checks using Reorgchk, reorg, runstats, and backups.
n
- Database Recovery: Execute restores including redirected restore via TSM and disk-level backups.
n
- Performance Monitoring: Utilize db2top, per stats, AppDynamics, and DBI tools.
n
- Database Migration: Lead migrations from AIX to Linux using db2look, db2move, and DB admin move.
n
- Automation & Scripting: Develop automation with shell scripting, Git, Ansible, and Jenkins.
n
- High Availability Setup: Configure DB2 HADR/TSA for high availability.
n
- Capacity Planning: Conduct performance testing and capacity planning.
n
- Stakeholder Management:



Collaborate across DTP for on-prem Enterprise Technology Database services.
n
- Vendor Management: Coordinate with vendors (Unisys, Cenitex, contractors) for infrastructure support.
n
- Incident & Change Management: Represent Enterprise Database changes in CAB meetings.
n
- Inventory Management: Maintain infrastructure and DB inventory, ensuring smooth vendor and stakeholder coordination.
n
- Cost Optimization: Oversee server decommissioning and specification optimization.
n
- Monitoring Improvements: Drive initiatives to enhance monitoring and alerting systems.
n

n

Qualifications

n

n
- Proven experience with DB2 LUW administration across multiple versions.
n
- Solid knowledge of database recovery, migration, and high availability solutions.
n
- Hands‐on expertise with performance monitoring tools and automation frameworks.
n
- Excellent stakeholder and vendor management skills.
n
- Familiarity with ITIL processes including incident, change, and capacity management.
n

#J-18808-Ljbffr

📌 SeniorDatabase Administrator (Victoria)
🏢 Techforce Personnel
📍 Victoria