Install, maintain, and support mainframe DB2 software. Conduct system improvements, manage data migrations, and ensure disaster recovery plans are executed. Provide training and technical assistance to teams.
Description
At CDW, we make it happen, together. Trust, connection, and commitment are at the heart of how we work together to deliver for our customers. It's why we're coworkers, not just employees. Coworkers who genuinely believe in supporting our customers and one another. We collectively forge our path forward with a level of commitment that speaks to who we are and where we're headed. We're proud to share our story and Make Amazing Happen at CDW. Job Summary The primary purpose of this position is to install and maintain mainframe DB2 software. This position will also estimate and plan for installation and upgrade activities as well as new customer transition projects
What you will do:
* Ensures system improvements and/or modifications are implemented
* Provides technical assistance regarding Disaster Recovery exercises and Business Continuity Processes Develops, enhances, and supports technical approaches that allow audits and scalable implementations of large, complex mainframe environments
* Identifies and resolves performance issues
* Maintain mainframe DB2 database objects such as tables, indexes, views, schemas, and constraints.
* Tune SQL statements, analyze access paths, and recommend index or query changes.
* Identify and resolve performance, locking, and concurrency issues across DB2 and related online environments (CICS/IMS).
* Manage data migrations using DB2 utilities including LOAD, UNLOAD, and REORG.
* Serve as the primary liaison to application teams regarding DB2 logical design and best practices.
* Implement and manage DB2 GRANT/REVOKE structures to ensure secure and compliant access.
* Support Disaster Recovery activities, validate recovery procedures, and align with customer RTO/RPO needs.
* Participate in project planning, estimating work, meeting milestones, and coordinating with project managers.
* Provide training, guidance, and mentoring to team members.
* Support audit and compliance needs by supplying logs, reports, and documentation.
* Participates in ongoing development and improvement of installation standards
* Works with project managers in the development and implementation of project plans and timelines
* Addresses and updates customer incident tickets and changes orders providing internal management and customer account managers with status information
* Provides team members with technical training and/or mentoring
* All CDW employees are responsible to safeguard the information and information systems that they use or handle in the execution of their duties. Employees are obligated to know and perform their duties in accordance with CDW policies, standards, and procedures related to security and report security violations to the appropriate CDW authority.
* Participate at hire and annually in the Information Security Awareness training as well as other required training identified by the Human Resources department. Other data privacy and data security related regulatory training may be required based on your role or assignment
What we expect of you:
* Bachelor's degree and at least 5 years of IT engineering work experience performing DB2 system management functions (software installations, version upgrades, product maintenance, configuration and administration management) . Provide primary support for reported problems related to DB2, QMF and related OEM software products. Fulfill service requests (SRs) for mainframe z/OS customers as they pertain to DB2, QMF, and related OEM software products to include:
* Experience installing, maintaining, and supporting mainframe software products for IBM mainframes and performing system management functions (software installations, version upgrades, product maintenance, and configuration management), OR
* 9 years IT Engineering experience, including 5 years of IT engineering work experience performing DB2 system management functions (software installations, version upgrades, product maintenance, configuration and administration management). Provide primary support for reported problems related to DB2, QMF and related OEM software products. Fulfill service requests (SRs) for mainframe z/OS customers as they pertain to DB2, QMF, and related OEM software products
* Ability to analyze and resolve DB2 logical and data-related issues including performance and query behavior.
* Demonstrated ability to install, maintain, and support mainframe products from vendors such as IBM, Computer Associates, Compuware, BMC, etc.
* Demonstrated ability to manage customer transitions, ensuring technical readiness and smooth onboarding.
* Demonstrated ability to execute tasks associated with any customer's disaster recovery plans
* Demonstrated communication and documentation skills for working with technical and business teams.
* Knowledge of DB2 security models (GRANT/REVOKE).
* Knowledge of IBM IMS, a plus.
* Knowledge of Assembler, a plus. Pay range: $104,550 - $148,190 depending on experience and skill set Annual bonus target of 10% subject to terms and conditions of plan Benefits overview: https://cdw.benefit-info.com/ Salary ranges may be subject to geographic differentials #LI-TP1
* We make technology work so people can do great things.
* CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index, CDW helps its customers to navigate an increasingly complex IT market and maximize return on their technology investments. Together, we unite. Together, we win. Together, we thrive. CDW is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law. CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, CDW's goal is to get to know you as an applicant and understand your experience, strengths, skills, and qualifications. While AI can help you present yourself more clearly and effectively, the essence of your application should be authentically yours. To learn more, please review [CDW's AI Applicant Notice](https://www.cdwjobs.com/pages/ai-applicant-notice).
At CDW, we make it happen, together. Trust, connection, and commitment are at the heart of how we work together to deliver for our customers. It's why we're coworkers, not just employees. Coworkers who genuinely believe in supporting our customers and one another. We collectively forge our path forward with a level of commitment that speaks to who we are and where we're headed. We're proud to share our story and Make Amazing Happen at CDW. Job Summary The primary purpose of this position is to install and maintain mainframe DB2 software. This position will also estimate and plan for installation and upgrade activities as well as new customer transition projects
What you will do:
* Ensures system improvements and/or modifications are implemented
* Provides technical assistance regarding Disaster Recovery exercises and Business Continuity Processes Develops, enhances, and supports technical approaches that allow audits and scalable implementations of large, complex mainframe environments
* Identifies and resolves performance issues
* Maintain mainframe DB2 database objects such as tables, indexes, views, schemas, and constraints.
* Tune SQL statements, analyze access paths, and recommend index or query changes.
* Identify and resolve performance, locking, and concurrency issues across DB2 and related online environments (CICS/IMS).
* Manage data migrations using DB2 utilities including LOAD, UNLOAD, and REORG.
* Serve as the primary liaison to application teams regarding DB2 logical design and best practices.
* Implement and manage DB2 GRANT/REVOKE structures to ensure secure and compliant access.
* Support Disaster Recovery activities, validate recovery procedures, and align with customer RTO/RPO needs.
* Participate in project planning, estimating work, meeting milestones, and coordinating with project managers.
* Provide training, guidance, and mentoring to team members.
* Support audit and compliance needs by supplying logs, reports, and documentation.
* Participates in ongoing development and improvement of installation standards
* Works with project managers in the development and implementation of project plans and timelines
* Addresses and updates customer incident tickets and changes orders providing internal management and customer account managers with status information
* Provides team members with technical training and/or mentoring
* All CDW employees are responsible to safeguard the information and information systems that they use or handle in the execution of their duties. Employees are obligated to know and perform their duties in accordance with CDW policies, standards, and procedures related to security and report security violations to the appropriate CDW authority.
* Participate at hire and annually in the Information Security Awareness training as well as other required training identified by the Human Resources department. Other data privacy and data security related regulatory training may be required based on your role or assignment
What we expect of you:
* Bachelor's degree and at least 5 years of IT engineering work experience performing DB2 system management functions (software installations, version upgrades, product maintenance, configuration and administration management) . Provide primary support for reported problems related to DB2, QMF and related OEM software products. Fulfill service requests (SRs) for mainframe z/OS customers as they pertain to DB2, QMF, and related OEM software products to include:
* Experience installing, maintaining, and supporting mainframe software products for IBM mainframes and performing system management functions (software installations, version upgrades, product maintenance, and configuration management), OR
* 9 years IT Engineering experience, including 5 years of IT engineering work experience performing DB2 system management functions (software installations, version upgrades, product maintenance, configuration and administration management). Provide primary support for reported problems related to DB2, QMF and related OEM software products. Fulfill service requests (SRs) for mainframe z/OS customers as they pertain to DB2, QMF, and related OEM software products
* Ability to analyze and resolve DB2 logical and data-related issues including performance and query behavior.
* Demonstrated ability to install, maintain, and support mainframe products from vendors such as IBM, Computer Associates, Compuware, BMC, etc.
* Demonstrated ability to manage customer transitions, ensuring technical readiness and smooth onboarding.
* Demonstrated ability to execute tasks associated with any customer's disaster recovery plans
* Demonstrated communication and documentation skills for working with technical and business teams.
* Knowledge of DB2 security models (GRANT/REVOKE).
* Knowledge of IBM IMS, a plus.
* Knowledge of Assembler, a plus. Pay range: $104,550 - $148,190 depending on experience and skill set Annual bonus target of 10% subject to terms and conditions of plan Benefits overview: https://cdw.benefit-info.com/ Salary ranges may be subject to geographic differentials #LI-TP1
* We make technology work so people can do great things.
* CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index, CDW helps its customers to navigate an increasingly complex IT market and maximize return on their technology investments. Together, we unite. Together, we win. Together, we thrive. CDW is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law. CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, CDW's goal is to get to know you as an applicant and understand your experience, strengths, skills, and qualifications. While AI can help you present yourself more clearly and effectively, the essence of your application should be authentically yours. To learn more, please review [CDW's AI Applicant Notice](https://www.cdwjobs.com/pages/ai-applicant-notice).
Top Skills
Bmc
Computer Associates
Compuware
Db2
Db2 Qmf
Ibm
SQL
Z/Os
Similar Jobs at CDW
Information Technology
The Sales Manager leads a team of Field Account Managers to achieve sales goals, develop strategies, manage resources, and enhance customer loyalty. Responsibilities include coaching, hiring, strategic management, and ensuring superior customer experiences.
Information Technology
This role drives complex, services-led opportunities, manages the sales process from origination to closure, and engages with executive stakeholders to shape outcome-based technology solutions.
Top Skills:
It TransformationManaged ServicesProfessional Services
Information Technology
The Sales Manager leads a team of Field Account Managers, driving sales performance and customer loyalty while developing strategies for growth and managing relationships.
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
