Mainframe DB2 DBA

Job Title: Mainframe DB2 DBA Location: Phoenix, AZ / New York, NY / Sunrise, FL Duration: Long-Term ContractResponsibilitiesDatabase 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 QualificationsExperience: 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 QualificationsDirect 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.