JPMorgan Data Engineer III - Mainframe IMS & DB2 Database Administrator 

United States, Ohio 

823065074

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.