DescriptionJoin us as we embark on a journey of collaboration and innovation where your unique skills and talents will be valued and celebrated. Together we will create a brighter future and make a meaningful difference.
As a Lead Data Engineer - Mainframe DBA/IMS/DB2 at JPMorgan Chase within the Consumer & Community Banking - Card Platform Services Team you are an integral part of an agile team that works to enhance build and deliver database requirements to meet product business deliverables by ensuring the data is always available accessible reliable and recoverable. As a core technical contributor you are responsible for maintaining the critical database and architectures across multiple technical areas within various business functions in support of the firms business objectives.
Job responsibilities
- Administer design implement and support highly available and scalable Mainframe DB2 & IMS database solutions
- Implement data models database designs data access and table maintenance codes.
- Implement and maintaining the DB2/IMS Databases with High Availability features using Data Partitioning and Databasereplications.
- Resolve database performance issues database capacity issues replication and other data issues.
- Work with Information Architects and Database Designers to implement the physical data model.
- Develop the database performance monitoring process and analyze data for optimization opportunities.
- Provide up to Level 2 on call support for the 24/7 DB2/IMS database environment.
- Manage on-site backup and recovery process.
- Plan for and execute required database upgrades or migrations.
- Work with database admin tools like CA Platinum/ BMC/ IBM Admin tools Mainview IBM Data Studio BMC Recoverymanagement etc.
Required qualifications capabilities and skills
- Formal training or certification on software engineering concepts and 5 years applied experience
- Database design/development integration performance monitoring & tuning systems re-engineering and Operations support.
- Knowledge of DB2 for z/OS along with mainframe related tools such as BMC CA Platinum for monitoring SMPE ISPF SMS SMF.
- Expertise with IMS Full Function/Fast Path database implementation REXX programming and MQ
- Experience in IBM Replication CDC QREP.
- Capable of creating the roadmap processes best practices standards and strategies for continuous improvement resiliency and scalability.
- Experience with Atlassian tools like Jira Confluence.
- Proven background on database engineering automationmonitoring performance engineeringdesignand implementations.
- Strong execution mind-set to manage and track progress against transformation goals.
- Knowledge of industry-wide technology trends and best practices.
Preferred qualifications capabilities and skills
- Experience providing 24x7 rotational support.
- Understanding of Distributed and Static SQL workloads
- Familiar with IDAA (Data Analytics Accelerators)