Lead Data Engineer - Mainframe DB2 DBA

Posted 4 Days Ago
Be an Early Applicant
Plano, TX, USA
Hybrid
Senior level
Financial Services
We’re one of the world’s biggest technology-driven companies
The Role
Lead Data Engineer/DB2 DBA responsible for maintaining and optimizing mainframe Db2 databases and data pipelines. Tasks include troubleshooting DB2 issues, backup/recovery, DDL deployments, environment refreshes, performance tuning, control reviews, and collaborating with application teams. Uses enterprise-authorized AI to accelerate design and operational tasks while ensuring validation, security, and auditability.
Summary Generated by Built In

As a Lead Data Engineer at JPMorgan Chase within the Commercial & Investment Bank - Production Management team, you are an integral part of an agile team that works to enhance, build, and deliver data collection, storage, access, and analytics solutions in a secure, stable, and scalable way. As a core technical contributor, you are responsible for maintaining critical data pipelines and architectures across multiple technical areas within various business functions in support of the firm’s business objectives.

Job responsibilities

  • Maintains and supports Db2 database applications
  • Uses enterprise-authorized AI capabilities within the work environment to accelerate data platform and model design analysis and documentation, validating outputs and handling data according to sensitivity and security requirements.
  • Experienced with mainframe environment and use of TSO / ISPF / JCL
  • Develop rapport with application development teams for collaboration
  • Expertise with troubleshooting / diagnosing mainframe db2 related issues
  • Maintains review of controls to ensure sufficient protection of enterprise data
  • Implements database back-up, recovery, and archiving strategy 
  • DDL Deployment , environment data refreshes, regular health checks
  • Maintains highest levels of stability, integrity, reliability, and availability
  • Experience with SQL and databases utilities including connectivity
  • Adds to team culture of team work , collaboration, and partnership
  • Applies reuse-first, AI-assisted practices within delivery and operational routines (e.g., backup/recovery validation and access control review support), ensuring traceability/auditability and alignment to resiliency and security expectations.

 

Required qualifications, capabilities, and skills

  • Formal training or certification on Data Engineering concepts and 5+ years applied experience
  • Working knowledge of relational databases (RDBMS) and SQL operations
  • Demonstrated experience using enterprise-authorized AI capabilities within the work environment to support data engineering workflows with strong validation habits and awareness of data sensitivity.
  • Ability to review and validate AI-assisted outputs (e.g., model/design summaries or operational checklists) before use, escalating when uncertain and following data handling requirements.
  • Working knowledge of JES2 and JCL, including RACF / ACF2 Security and CA7 / ZEKE 
  • Experience with performance analysis to optimize SQL workloads
  • Knowledge of SYSPlex mainframe configuration including Data Sharing 
  • Knowledge of the data lifecycle and data management functions
  • Working knowledge of mainframe data system components 
  • Strong understanding of data modeling fundamentals (e.g., primary and foreign keys, constraints, indexing, etc.)
  • Ability to work in large, collaborative teams to achieve organizational goals, with a passion to build an innovative culture
  • Knowledge of industry-wide technology trends and best practices 

Preferred qualifications, capabilities, and skills

  • Understanding of general Mainframe Utilities, Database Utilities and Stored Procedures 
  • Familiar with mainframe environment and the use of TSO / ISPF
  • Understanding of Distributed and Static SQL workloads
  • Understanding of plex mainframe configuration including Data Sharing & Stand-In
  • Familiar with IDAA (Data Analytics Accelerators)
About Us
JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world’s most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process. 

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.

JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans

About the TeamJ.P. Morgan’s Commercial & Investment Bank is a global leader across banking, markets, securities services and payments. Corporations, governments and institutions throughout the world entrust us with their business in more than 100 countries. The Commercial & Investment Bank provides strategic advice, raises capital, manages risk and extends liquidity in markets around the world. 

Skills Required

  • Formal training or certification on Data Engineering concepts and 5+ years applied experience
  • Maintains and supports Db2 database applications
  • Working knowledge of relational databases (RDBMS) and SQL operations
  • Experience with SQL and database utilities including connectivity
  • Experienced with mainframe environment and use of TSO / ISPF / JCL
  • Working knowledge of JES2 and JCL, including RACF / ACF2 Security and CA7 / ZEKE
  • Expertise with troubleshooting / diagnosing mainframe db2 related issues
  • Experience with performance analysis to optimize SQL workloads
  • Knowledge of SYSPlex mainframe configuration including Data Sharing
  • Knowledge of the data lifecycle and data management functions
  • Working knowledge of mainframe data system components
  • Strong understanding of data modeling fundamentals (primary/foreign keys, constraints, indexing)
  • Demonstrated experience using enterprise-authorized AI capabilities within the work environment and ability to validate AI-assisted outputs
  • Ability to work in large, collaborative teams and foster an innovative culture
  • Maintains review of controls to ensure sufficient protection of enterprise data
  • Implements database back-up, recovery, and archiving strategy
  • DDL deployment, environment data refreshes, regular health checks

JPMorganChase Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about JPMorganChase and has not been reviewed or approved by JPMorganChase.

  • Healthcare Strength Medical, dental, vision, and mental health coverage are comprehensive, with on-site clinics, preventive care, and specialized supports such as maternity nurse guidance and fertility treatments. Wellness activities can help offset copays and out-of-pocket costs, reinforcing the perceived strength of health benefits.
  • Retirement Support A 401(k) with dollar-for-dollar matching and additional automatic pay credits reflect strong employer-backed retirement savings. An employee stock purchase plan and related financial programs further bolster long-term financial support.
  • Leave & Time Off Breadth Paid time off, sick time, holidays, and generous parental leave are provided alongside family medical leave and adoption/fertility assistance. Additional programs like caregiver support and volunteer time off expand the breadth of time-away options.

JPMorganChase Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
289,097 Employees
Year Founded: 1799

What We Do

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $3.7 trillion and operations worldwide. The firm is a leader in investment banking, financial services for consumers and small businesses, commercial banking, financial transaction processing, and asset management. A component of the Dow Jones Industrial Average, JPMorgan Chase & Co. serves millions of consumers in the United States and many of the world’s most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands. Technology fuels every aspect of our company and is at the heart of everything we do. With over 50,000 technologists globally and an annual tech spend of $12 billion, we are dedicated to improving the design, analytics, development, coding, testing and application programming that goes into creating high quality software and new products. Learn more about technology at our firm, explore resources from our Distinguished Engineers, AI & ML researchers, and other experts; access the latest episode of our TechTrends podcast, and more at www.jpmorgan.com/technology. Information about JPMorgan Chase & Co. is available at www.jpmorganchase.com. ©2023 JPMorgan Chase & Co. All rights reserved. JPMorgan Chase is an Equal Opportunity Employer, including Disability/Veterans.

Why Work With Us

Our technologists work on a diverse range of solutions that include strategic technology initiatives, big data, mobile, electronic payments, machine learning, cybersecurity, enterprise cloud development, and other state-of-the-art technologies.

Gallery

Gallery

Similar Jobs

Boeing Logo Boeing

Industrial Security Manager

Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
In-Office
San Antonio, TX, USA
170000 Employees
140K-190K Annually

Boeing Logo Boeing

Software Engineer

Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
In-Office
Richardson, TX, USA
170000 Employees
106K-183K Annually

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Inside Sales Representative

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
10 Locations
40000 Employees
45K-85K Annually

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Solutions Architect

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
5 Locations
40000 Employees
156K-281K Annually

Similar Companies Hiring

Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account