JPMorgan Lead Data Engineer - Mainframe DBA/IMS/DB2 

United States, Delaware, Wilmington 

398214891

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 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, 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

• Experience providing 24x7 rotational support.
• Understanding of Distributed and Static SQL workloads
• Familiar with IDAA (Data Analytics Accelerators)