Job Title: Mainframe DB2 DBA
Location: Phoenix, AZ / New York, NY / Sunrise, FL
Duration: Long-Term Contract
ResponsibilitiesDatabase Operations & Support: Monitor, maintain, and optimize mission-critical DB2 for z/OS and distributed application databases to ensure 24/7 availability and peak performance. Replication & Synchronization: Configure, manage, and troubleshoot IBM InfoSphere Data Replication via Q-Replication (QRE) to maintain real-time data streaming across systems. Analytics Acceleration: Administer and tune IBM DB2 Analytics Accelerator (IDAA) workloads, ensuring complex operational reporting queries run at maximum efficiency. Data Integration: Implement and manage Db2 Data Gate (Datagate) to securely and efficiently synchronize data from z/OS into cloud-native and distributed analytics environments. Application DB Support: Collaborate directly with application development teams on schema changes, SQL tuning, indexing strategies, and database deployment pipelines. Performance Tuning: Perform deep-dive root cause analysis on database performance bottlenecks, locking issues, and storage constraints. Compliance & Security: Adhere to strict financial sector compliance, data privacy standards, and change management workflows.
Required Qualifications
Experience:
Minimum of 3 to 5 years (or more) of dedicated experience in DB2 Database Operations, Database Administration, or Application Database Engineering. Mainframe Analytics Stack: Proven, hands-on experience with IDAA (IBM Db2 Analytics Accelerator) and Db2 Data Gate (Datagate).Data Replication: Strong technical expertise in configuring and troubleshooting Q-Replication (QRE).Application Lifecycle: Solid understanding of application database design, logical/physical modeling, and deep proficiency in writing and tuning complex SQL.Environment: Comfortable working in complex, enterprise-grade, high-volume transactional environments.
Preferred Qualifications:
Direct familiarity with Amex technologies, architectural standards, change control protocols, and infrastructure is a major plus.
Financial Services Background: Prior experience navigating heavily regulated environments with strict audit and compliance frameworks.
Automation: Experience utilizing automated deployment tools, scripting (Python, Rexx, JCL), or DevOps pipelines for database changes.
Certifications: like IBM Certified DBA, preferred scripting languages - a plus.