DB2 Database Operations (Ops) Engineer
- ๐บ๐ธ United States
- Hybrid
- 7 hours ago
- Agile
- DB2
- z/OS
- SQL
- Change Management
- Python
- Devops
Summary:
We are always looking to grow our teams with talented people and achieve great things together. We are seeking a highly skilled professional 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 scientific 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.
Responsibilities:
- Monitor, maintain, and optimize mission-critical DB2 for z/OS and distributed application databases to ensure 24/7 availability and peak performance.
- Configure, manage, and troubleshoot IBM InfoSphere Data Replication via Q-Replication (QRE) to maintain real-time data streaming across systems.
- Administer and tune IBM DB2 Analytics Accelerator (IDAA) workloads, ensuring complex operational reporting queries run at maximum efficiency.
- Implement and manage Db2 Data Gate (Datagate) to securely and efficiently synchronize data from z/OS into cloud-native and distributed analytics environments.
- Collaborate directly with application development teams on schema changes, SQL tuning, indexing strategies, and database deployment pipelines.
- Perform deep-dive root cause analysis on database performance bottlenecks, locking issues, and storage constraints.
- Adhere to strict financial sector compliance, data privacy standards, and change management workflows.
Requirements:
- Minimum of 3 to 5 years (or more) of dedicated experience in DB2 Database Operations, Database Administration, or Application Database Engineering.
- Proven, hands-on experience with IDAA (IBM Db2 Analytics Accelerator) and Db2 Data Gate (Datagate).
- Strong technical expertise in configuring and troubleshooting Q-Replication (QRE).
- Solid understanding of application database design, logical/physical modeling, and deep proficiency in writing and tuning complex SQL.
- Comfortable working in complex, enterprise-grade, high-volume transactional environments.
Required Skills:
- Experience in DB2 Database Operations, Database Administration, or Application Database Engineering.
- Hands-on experience with IDAA and Db2 Data Gate.
- Technical expertise in Q-Replication (QRE).
- Understanding of application database design and proficiency in complex SQL.
- Experience in high-volume transactional environments.
Preferred Skills:
- Direct familiarity with technologies, architectural standards, change control protocols, and infrastructure.
- Prior experience navigating heavily regulated environments with strict audit and compliance frameworks.
- Experience utilizing automated deployment tools, scripting (Python, Rexx, JCL), or DevOps pipelines for database changes.
- Certifications like IBM Certified DBA, preferred scripting languages.
Benefits:
Information about benefits can be provided here, including healthcare, retirement plans, and other perks associated with the position.
DB2 Database Operations (Ops) Engineer ยท Evolutyz