Data Engineer III - Mainframe IMS & DB2 Database Administrator - JPMorgan Chase
Columbus, OH
About the Job
Be part of a dynamic team where your distinctive skills will contribute to a winning culture and team.
As a Data Engineer III at JPMorgan Chase within the Consumer & Community Banking and Firmwide Core Deposits Platform, you serve as a seasoned member of an agile team to design and deliver trusted data collection, storage, access, and analytics solutions in a secure, stable, and scalable way. You are responsible for developing, testing, and maintaining critical data pipelines and architectures across multiple technical areas within various business functions in support of the firm's 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 Database replications.
+ 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 Recovery management etc.
Required qualifications, capabilities, and skills
+ Formal training or certification on Database design/development concepts and 3+ years applied experience.
+ Database design/development, integration, performance monitoring & tuning, systems re-engineering and Operations support.
+ Expert knowledge of DB2 for z/OS along with mainframe related tools such as BMC, CA Platinum for monitoring, SMPE, ISPF, SMS, SMF.
+ Hands-on experience of IMS Full Function/Fast Path database implementation.
+ 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, automation, monitoring, performance engineering design and 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
+ 5+ years' experience in IMS and DB2 database administration.
+ Nice to have skills in REXX programming & MQ.
+ Knowledge on replication tools like QREP, CDC.
+ Should be open to provide 24x7 support.
+ Proven background on database engineering, automation, monitoring, performance engineering design and implementations.
+ Ability to communicate technical information clearly.
+ Ability to manage risk appropriately.
Chase is a leading financial services firm, helping nearly half of America's households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs.
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.
Equal Opportunity Employer/Disability/Veterans
As a Data Engineer III at JPMorgan Chase within the Consumer & Community Banking and Firmwide Core Deposits Platform, you serve as a seasoned member of an agile team to design and deliver trusted data collection, storage, access, and analytics solutions in a secure, stable, and scalable way. You are responsible for developing, testing, and maintaining critical data pipelines and architectures across multiple technical areas within various business functions in support of the firm's 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 Database replications.
+ 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 Recovery management etc.
Required qualifications, capabilities, and skills
+ Formal training or certification on Database design/development concepts and 3+ years applied experience.
+ Database design/development, integration, performance monitoring & tuning, systems re-engineering and Operations support.
+ Expert knowledge of DB2 for z/OS along with mainframe related tools such as BMC, CA Platinum for monitoring, SMPE, ISPF, SMS, SMF.
+ Hands-on experience of IMS Full Function/Fast Path database implementation.
+ 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, automation, monitoring, performance engineering design and 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
+ 5+ years' experience in IMS and DB2 database administration.
+ Nice to have skills in REXX programming & MQ.
+ Knowledge on replication tools like QREP, CDC.
+ Should be open to provide 24x7 support.
+ Proven background on database engineering, automation, monitoring, performance engineering design and implementations.
+ Ability to communicate technical information clearly.
+ Ability to manage risk appropriately.
Chase is a leading financial services firm, helping nearly half of America's households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs.
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.
Equal Opportunity Employer/Disability/Veterans
Source : JPMorgan Chase