Infrastructure Engineer III - Mainframe Db2
📍 Job Overview
- Job Title: Infrastructure Engineer III - Mainframe Db2
- Company: JPMorgan Chase
- Location: Columbus, Ohio, United States
- Job Type: Full time
- Category: Infrastructure Engineer
- Date Posted: 2025-06-25
- Experience Level: 5-10 years
- Remote Status: On-site
🚀 Role Summary
- Key Infrastructure Engineering Aspects: Mainframe Db2 systems programming, IBM Db2 environment management, cloud infrastructure, and cross-functional collaboration.
- Key Technical Responsibilities: Install, maintain, and upgrade IBM Db2 subsystems, manage SMP/E libraries, and troubleshoot production issues.
- Key Collaboration Aspects: Work with mainframe z/OS system programming teams, Db2 database administrators, and IBM vendors.
📝 Enhancement Note: This role requires a strong background in IBM Db2 systems programming and experience working in a mainframe z/OS environment. Familiarity with cloud infrastructure and multiple cloud technologies is also crucial for success in this position.
💻 Primary Responsibilities
- IBM Db2 Environment Management: Install, configure, and maintain IBM Db2 V12 & V13 subsystems, manage SMP/E target/distribution libraries, and develop automated maintenance jobs and scripts.
- Production Issue Resolution: Collaborate with Db2 database administrators to triage, mitigate, and permanently resolve day-to-day production issues.
- On-Call Duties: Provide daily turnover and management updates during on-call shifts, supporting a global and diverse team.
- Vendor Collaboration: Work with IBM and other infrastructure software vendors on high-priority incidents, abnormal system behaviors, and tuning opportunities.
- Project Management: Drive workstreams or projects consisting of one or more infrastructure engineering technologies, working with other platforms to architect and implement changes.
- Problem-Solving: Execute creative solutions for the design, development, and technical troubleshooting of problems of moderate complexity.
📝 Enhancement Note: This role requires strong problem-solving skills and the ability to work effectively in a team environment. The ideal candidate will be comfortable working in a dynamic and fast-paced environment and have a proven track record of delivering results.
🎓 Skills & Qualifications
Education: Bachelor's degree in Computer Science, Information Technology, or a related field.
Experience: At least 7 years of IBM Db2 systems programming experience in a mainframe z/OS operating system, with a strong focus on IBM Db2 V12 & V13 subsystems, SMP/E, and continuous delivery function levels.
Required Skills:
- Deep knowledge of infrastructure engineering concepts and 3+ years of applied experience.
- Strong scripting skills (e.g., Python, REXX) and familiarity with SQL.
- Experience with Db2 buffer pool tuning, dump analysis, and performance optimization.
- Knowledge of cloud infrastructure and multiple cloud technologies.
- Strong problem-solving skills and the ability to work effectively in a team environment.
Preferred Skills:
- Experience with IBM Db2 Analytics Accelerator, Data Studio, and Admin Foundation for z/OS.
- Knowledge of Db2 Replication tools like IBM QREP, IBM Change Data Capture, and IBM Db2 Integrated Synchronization.
- Experience with Db2 ISV products and IBM tools such as Db2 Sort and High Performance Unload.
📝 Enhancement Note: Candidates with experience in software engineering and a strong understanding of infrastructure engineering principles will be highly sought after for this role. Familiarity with IBM Db2-specific tools and technologies is also highly desirable.
📊 Web Portfolio & Project Requirements
Portfolio Essentials:
- Demonstrate experience with IBM Db2 systems programming, including installation, configuration, and maintenance of IBM Db2 V12 & V13 subsystems.
- Showcase problem-solving skills and the ability to troubleshoot complex production issues.
- Highlight experience with cloud infrastructure and multiple cloud technologies.
Technical Documentation:
- Provide examples of automated maintenance jobs and scripts developed for IBM Db2 environments.
- Demonstrate familiarity with Db2 buffer pool tuning, dump analysis, and performance optimization techniques.
- Showcase experience with Db2 Replication tools and IBM Db2-specific tools and technologies.
📝 Enhancement Note: Candidates should be prepared to discuss their experience with IBM Db2 systems programming and cloud infrastructure in detail during the interview process. Specific examples of successful projects and problem-solving scenarios should be highlighted in the portfolio.
💵 Compensation & Benefits
Salary Range: $120,000 - $160,000 per year (based on regional market data and experience level)
Benefits:
- Competitive health, dental, and vision insurance plans.
- Retirement savings plans with company matching contributions.
- Generous time-off policies, including vacation, sick leave, and holidays.
- Employee discounts on various products and services.
- Opportunities for professional development and career growth.
Working Hours: 40 hours per week, with on-call duties required for a global and diverse team.
📝 Enhancement Note: The salary range provided is an estimate based on regional market data and experience level. Actual compensation may vary depending on factors such as skills, experience, and internal equity.
🎯 Team & Company Context
🏢 Company Culture
Industry: Financial Services
Company Size: Large (over 10,000 employees)
Founded: 1799
Team Structure:
- The Infrastructure Platforms Mainframe Midrange Compute team is responsible for managing and maintaining the mainframe Db2 environment.
- The team consists of experienced infrastructure engineers, system programmers, and database administrators.
- The team works closely with other platforms and technology teams to ensure the smooth operation of the organization's technology processes.
Development Methodology:
- The team follows Agile development methodologies, with a focus on continuous improvement and collaboration.
- Regular sprint planning and stand-up meetings are held to ensure progress and address any obstacles.
- Code reviews, testing, and quality assurance practices are integral to the development process.
Company Website: JPMorgan Chase
📝 Enhancement Note: JPMorgan Chase is a global financial services firm with a strong commitment to diversity, equity, and inclusion. The company offers a collaborative and supportive work environment, with opportunities for professional growth and development.
📈 Career & Growth Analysis
Web Technology Career Level: Senior Infrastructure Engineer
Reporting Structure: This role reports directly to the Infrastructure Platforms Mainframe Midrange Compute team lead and works closely with other platform teams and technology stakeholders.
Technical Impact: The Infrastructure Engineer III - Mainframe Db2 role has a significant impact on the organization's technology processes and infrastructure. The successful candidate will be responsible for maintaining the health and security of the IBM Mainframe Db2 environment and driving projects that improve the organization's technology capabilities.
Growth Opportunities:
- Technical Skill Development: Opportunities to develop expertise in emerging technologies and gain experience with new tools and platforms.
- Leadership Development: Opportunities to mentor junior team members and take on leadership roles within the team.
- Architecture Decision-Making: Opportunities to influence the organization's technology strategy and make decisions that impact the overall technology architecture.
📝 Enhancement Note: This role offers significant opportunities for career growth and development within the organization. Candidates should be prepared to discuss their long-term career goals and how this role can help them achieve those objectives.
🌐 Work Environment
Office Type: On-site, with a collaborative and modern workspace designed to foster innovation and creativity.
Office Location(s): Columbus, Ohio, United States
Workspace Context:
- The workspace is equipped with state-of-the-art technology, including multiple monitors and testing devices.
- The team works closely together in an open-plan office, with opportunities for collaboration and knowledge sharing.
- The workspace is designed to be flexible and adaptable, with the ability to accommodate changing team dynamics and project requirements.
Work Schedule: Standard business hours, with on-call duties required for a global and diverse team.
📝 Enhancement Note: The on-site work environment at JPMorgan Chase is designed to be collaborative and supportive, with opportunities for professional growth and development. Candidates should be prepared to discuss their preferences for work arrangements and how they can best contribute to the team's success.
📄 Application & Technical Interview Process
Interview Process:
- Phone Screen: A brief phone call to discuss the candidate's qualifications and experience with the role.
- Technical Assessment: A hands-on assessment of the candidate's technical skills, focusing on IBM Db2 systems programming and cloud infrastructure.
- Behavioral Interview: A discussion of the candidate's problem-solving skills, teamwork, and communication abilities.
- Final Interview: A meeting with the hiring manager and other team members to discuss the candidate's fit for the role and the team.
Portfolio Review Tips:
- Highlight experience with IBM Db2 systems programming and cloud infrastructure.
- Provide specific examples of successful projects and problem-solving scenarios.
- Be prepared to discuss technical challenges and how you overcame them.
Technical Challenge Preparation:
- Brush up on your IBM Db2 systems programming skills, with a focus on installation, configuration, and maintenance.
- Familiarize yourself with cloud infrastructure and multiple cloud technologies.
- Prepare for questions about your problem-solving skills and teamwork abilities.
ATS Keywords: IBM Db2, Mainframe z/OS, SMP/E, SQL, REXX, Cloud Infrastructure, Automation, Performance Tuning, Problem Solving, Technical Troubleshooting, Diversity, Equity, Inclusion, Collaboration, Scripting.
📝 Enhancement Note: The interview process for this role is designed to assess the candidate's technical skills and cultural fit with the team. Candidates should be prepared to discuss their experience and qualifications in detail and provide specific examples of their problem-solving abilities.
🛠 Technology Stack & Web Infrastructure
Backend & Server Technologies:
- IBM Db2 V12 & V13 subsystems
- SMP/E (Software Management Program/Extended)
- Mainframe z/OS operating system
Development & DevOps Tools:
- Scripting languages (e.g., Python, REXX)
- SQL
- Cloud infrastructure and multiple cloud technologies
📝 Enhancement Note: The technology stack for this role is focused on IBM Db2 systems programming and cloud infrastructure. Candidates should be familiar with the relevant technologies and have experience working with them in a production environment.
👥 Team Culture & Values
Web Development Values:
- Expertise: Demonstrate deep knowledge of IBM Db2 systems programming and cloud infrastructure.
- Collaboration: Work effectively with other team members and stakeholders to achieve shared goals.
- Innovation: Continuously seek out new technologies and approaches to improve the organization's technology capabilities.
- Quality: Ensure that all work is of the highest standard and meets the organization's quality expectations.
Collaboration Style:
- Cross-functional Integration: Work closely with other teams and stakeholders to ensure that technology decisions align with business objectives.
- Code Review Culture: Regularly review and provide feedback on team members' work to ensure that it meets the organization's quality expectations.
- Knowledge Sharing: Share expertise and experience with other team members to foster a culture of continuous learning and improvement.
📝 Enhancement Note: The team culture at JPMorgan Chase is focused on collaboration, innovation, and continuous learning. Candidates should be prepared to discuss their experience with these values and how they can contribute to the team's success.
⚡ Challenges & Growth Opportunities
Technical Challenges:
- IBM Db2 Systems Programming: Maintain a secure and healthy IBM Mainframe Db2 environment, including installation, configuration, and maintenance of IBM Db2 V12 & V13 subsystems.
- Cloud Infrastructure: Work with multiple cloud technologies and ensure that the organization's infrastructure is optimized for performance, scalability, and security.
- Problem-Solving: Troubleshoot complex production issues and drive projects that improve the organization's technology capabilities.
Learning & Development Opportunities:
- Technical Skill Development: Gain experience with new technologies and tools, and develop expertise in emerging areas of infrastructure engineering.
- Conference Attendance: Attend industry conferences and events to stay up-to-date with the latest trends and best practices in infrastructure engineering.
- Technical Mentorship: Provide guidance and support to junior team members, helping them to develop their skills and advance their careers.
📝 Enhancement Note: This role offers significant opportunities for technical skill development and career growth. Candidates should be prepared to discuss their long-term career goals and how they can best contribute to the team's success.
💡 Interview Preparation
Technical Questions:
- IBM Db2 Systems Programming: Describe your experience with IBM Db2 systems programming and how you have maintained a secure and healthy IBM Mainframe Db2 environment.
- Cloud Infrastructure: Explain your experience with cloud infrastructure and how you have optimized infrastructure for performance, scalability, and security.
- Problem-Solving: Provide specific examples of complex production issues you have troubleshot and how you approached the problem-solving process.
Company & Culture Questions:
- JPMorgan Chase: Describe what you know about JPMorgan Chase and why you are interested in working for the company.
- Team Fit: Explain how your skills and experience align with the team's values and how you can contribute to the team's success.
- User Experience Impact: Discuss how your work impacts the user experience and how you ensure that technology decisions align with business objectives.
Portfolio Presentation Strategy:
- Live Demonstration: Prepare a live demonstration of your experience with IBM Db2 systems programming and cloud infrastructure, highlighting specific projects and problem-solving scenarios.
- Code Explanation: Be prepared to explain your code and approach to technical challenges, demonstrating your expertise and attention to detail.
- User Experience Showcase: Showcase your understanding of user experience principles and how you ensure that technology decisions align with business objectives.
📝 Enhancement Note: The interview process for this role is designed to assess the candidate's technical skills and cultural fit with the team. Candidates should be prepared to discuss their experience and qualifications in detail and provide specific examples of their problem-solving abilities.
📌 Application Steps
To apply for this Infrastructure Engineer III - Mainframe Db2 position:
- Submit your application through the application link: JPMorgan Chase Career Portal
- Customize your resume: Highlight your experience with IBM Db2 systems programming, cloud infrastructure, and problem-solving skills.
- Prepare for the technical assessment: Brush up on your IBM Db2 systems programming skills and familiarize yourself with cloud infrastructure and multiple cloud technologies.
- Research JPMorgan Chase: Learn about the company's history, culture, and values, and be prepared to discuss your fit for the team.
⚠️ Important Notice: This enhanced job description includes AI-generated insights and infrastructure engineering industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.
Application Requirements
Candidates should have at least 7 years of IBM Db2 systems programming experience and formal training in infrastructure engineering concepts. A deep understanding of cloud technologies and scripting languages is also required.