Lead Data Engineer, Mainframe DB2 DBA

JPMorgan Chase

Confirmed live 2 days ago High trust

Quick summary

Work type
On-site
Location
Plano, TX
Posted
63 days ago
Freshness
Confirmed live 2 days ago

Market check

Salary context

How this pay compares to similar roles

Similar $180k
$137k most similar roles pay here $219k

This listing doesn't post a salary. Most similar roles pay $149,106–$211,200.

Based on 240 similar postings.

Employer

About JPMorgan Chase

JPMorgan Chase & Co. is a global financial services firm and one of the largest banks in the world, offering investment banking, commercial banking, asset management, and consumer financial services.

JPMorgan Chase currently has 1117 open roles on FindRole.

Listed pay typically runs $186,160–$215,000 across 7 roles with salary data.

Most-posted roles

View all roles at JPMorgan Chase

At a glance

TL;DR · Lead Data Engineer, Mainframe DB2 DBA

As a Lead Data Engineer - Mainframe DB2 DBA within the Commercial & Investment Bank - Production Management team, you will serve as a core technical contributor in an agile environment. You are responsible for maintaining critical data pipelines and architectures while ensuring high levels of stability, integrity, and availability for enterprise data. Your daily responsibilities include managing Db2 database applications, implementing backup and recovery strategies, performing DDL deployments, and conducting health checks. You will utilize enterprise-authorized AI capabilities to accelerate platform design and documentation while adhering to strict security protocols. The role requires expertise in SQL, TSO, ISPF, JCL, JES2, RACF/ACF2, and CA7/ZEKE. You must possess deep knowledge of RDBMS, data modeling, SYSPlex configurations, and performance analysis to optimize workloads within a complex mainframe environment involving distributed and static SQL.

What you'll do

  • Maintain and support Db2 database applications across various business functions.
  • Manage critical data pipelines, architectures, and storage solutions for scalability and stability.
  • Troubleshoot and diagnose complex mainframe Db2 related issues.
  • Implement database backup, recovery, and archiving strategies to ensure data integrity.
  • Execute DDL deployments, environment data refreshes, and regular system health checks.
  • Utilize enterprise-authorized AI tools to accelerate data platform design and documentation while ensuring security compliance.
  • Optimize SQL workloads through performance analysis and data modeling best practices.

What we're looking for

  • Formal training or certification in Data Engineering concepts.
  • 5+ years of applied experience in data engineering.
  • Working knowledge of relational databases (RDBMS) and SQL operations.
  • Experience using enterprise-authorized AI capabilities to support data engineering workflows with strong validation habits.
  • Working knowledge of JES2, JCL, RACF/ACF2 Security, and CA7/ZEKE.
  • Knowledge of SYSPlex mainframe configuration including Data Sharing.
  • Strong understanding of data modeling fundamentals such as primary keys, foreign keys, constraints, and indexing.
  • Experience with performance analysis to optimize SQL workloads.

More like this

Similar roles

Lead Data Engineer

JPMorgan Chase

Jersey City, NJ 33 days ago
Python PySpark SQL Apache Airflow AWS Azure Streaming Data Data Warehousing Lakehouse Object-Oriented Programming System Design
5+ yrs exp

Lead Data Engineer

Capital One Financial

McLean, VA 57 days ago $197,300$225,100
Python SQL Scala Java AWS Redshift Snowflake Spark Kafka Hadoop Hive EMR NoSQL Cassandra MySQL Linux Shell Scripting Agile
4+ yrs exp

Lead Data Engineer

Capital One Financial

Plano, TX 88 days ago $179,400$204,700
Python Java TypeScript React Databricks Snowflake Spark Kafka AWS Redshift SQL Scala Flink DynamoDB OpenSearch UNIX Linux CI/CD Agile Microservices
4+ yrs exp

Lead Data Engineer

Capital One Financial

McLean, VA +3 85 days ago $179,400$204,700
Python SQL Scala Java AWS Azure Google Cloud Redshift Snowflake Spark Kafka Hadoop Hive EMR NoSQL Cassandra MySQL UNIX Linux Agile
4+ yrs exp

Lead Data Engineer

Capital One Financial

McLean, VA +3 81 days ago $179,400$204,700
Python SQL Scala Java AWS Redshift Snowflake Spark Kafka Hadoop Hive EMR NoSQL Cassandra MySQL UNIX Linux Agile
4+ yrs exp

Lead Data Engineer

Capital One Financial

Plano, TX +2 59 days ago $179,400$204,700
Python SQL Scala Java AWS Azure Redshift Snowflake Spark Kafka Hadoop Hive EMR NoSQL Cassandra MySQL UNIX Linux Shell Scripting Agile Machine Learning
4+ yrs exp