Mainframe DB2 DBA
BCforward · New York, New York, United States
FULL TIME
Job Description
BCforward is seeking a highly motivated and experienced DB2 Database Operations (Ops) Engineer
Make sure to apply quickly in order to maximise your chances of being considered for an interview Read the complete job description below.
Note: Candidate must be local to any of these locations: Phoenix, AZ / New York, NY / Sunrise, FL.
Job Title: Mainframe DB2 DBALocation: (Phoenix, AZ / New York, NY / Sunrise, FL) - HybridDuration: Long-term contract Experience Level: Min 3–5+ Years
Position OverviewWe are seeking a highly skilled DB2 Database Operations (Ops) Engineer with strong application database management and modern IBM mainframe analytics architecture experience. In this role, you will bridge the gap between traditional database administration and agile application development. You will optimize, maintain, and support high-volume DB2 environments.The ideal candidate brings specific expertise in Q-Replication (QRE), IBM DB2 Analytics Accelerator (IDAA), and Datagate technologies to ensure seamless data movement and near-zero latency analytics. Prior experience working within an American Express (AMEX) environment or similar large-scale financial services infrastructure is preferred.
Key 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 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 QualificationsAmerican Express Experience: 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. xzbcwsv Certifications - like IBM Certified DBA, preferred scripting languages - a plus.
Make sure to apply quickly in order to maximise your chances of being considered for an interview Read the complete job description below.
Note: Candidate must be local to any of these locations: Phoenix, AZ / New York, NY / Sunrise, FL.
Job Title: Mainframe DB2 DBALocation: (Phoenix, AZ / New York, NY / Sunrise, FL) - HybridDuration: Long-term contract Experience Level: Min 3–5+ Years
Position OverviewWe are seeking a highly skilled DB2 Database Operations (Ops) Engineer with strong application database management and modern IBM mainframe analytics architecture experience. In this role, you will bridge the gap between traditional database administration and agile application development. You will optimize, maintain, and support high-volume DB2 environments.The ideal candidate brings specific expertise in Q-Replication (QRE), IBM DB2 Analytics Accelerator (IDAA), and Datagate technologies to ensure seamless data movement and near-zero latency analytics. Prior experience working within an American Express (AMEX) environment or similar large-scale financial services infrastructure is preferred.
Key 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 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 QualificationsAmerican Express Experience: 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. xzbcwsv Certifications - like IBM Certified DBA, preferred scripting languages - a plus.
Details
| Company | BCforward |
| Location | New York, New York, United States |
| Type | FULL TIME |
| Niche | tech |

