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