Db2 Database Administrator

Job Title: Senior DB2 Database Administrator (QREP Specialist)Job Overview
Seeking a Senior DB2 DBA with Q Replication (QREP) expertise for Mainframe DB2 (z/OS) and LUW DB2 environments. This remote contract role focuses on administering, supporting, and optimizing multiple subsystems for high availability, security, and performance in mission-critical applications. Involves troubleshooting, system enhancements, and stakeholder collaboration.
Contract Duration: 6-12 months (potential extension).Start Date: Within 2 weeks of offer.Hours: Mon-Fri, 9:00 AM - 5:00 PM EST (overtime for critical issues with approval).
Key Responsibilities
Administer/support DB2 on Mainframe/LUW, monitoring multiple subsystems for 99.9% uptime.
Manage QREP setup, maintenance, and troubleshooting, including MQ subscriptions and capture/apply processes.
Build/modify DB2 objects (tables, indexes, etc.) per client/internal requests.
Analyze DB2 versions for improvements; implement upgrades with minimal disruption.
Execute test data refreshes and DR recovery for application objects.
Process DB2 security requests; review for risks and compliance (e.g., SOX/GDPR).
Tune buffer pools, SQL code, and reorganize data for optimal performance.
Perform space calculations; consult vendors (e.g., IBM) for issue resolution.
Resolve replication/MQ/subsystem incidents with root-cause analysis.
Expected Deliverables
Weekly Reports: Subsystem health, replication status, incidents (Fridays, 5:00 PM EST).
Monthly Audits: Performance/security reports with metrics/recommendations (last Friday monthly).
QREP Docs: Setup/upgrade guides, tests, rollbacks (within 5 business days).
Refresh/DR Reports: Validation logs, recovery proofs (<4-hour SLA; within 3 business days post-event).
Risk Summaries: Quarterly security assessments/remediations (5th business day next quarter).
Object Builds: Deployed scripts/tests (2-3 business days per request).
Use internal templates; peer-review production changes.
Requirements
Technical (Required):
8+ years DB2 DBA; 4+ years QREP on Mainframe/LUW.
Expertise in multi-subsystem support, MQ integrations, object management, tuning (e.g., IBM Optim), DR, security audits.
DB2 versioning, REORG, app integrations (CICS/WebSphere).
Other:
Strong analytical/communication skills for incidents/stakeholders.
BS in CS/IT or equivalent.
US work authorization; EST availability.

 ... Show more