Principal Consultant - Infrastructure Management | Database Administration | DB2 on Mainframe

Description: Job Title: Principal Consultant

Work Location & Reporting Address: Plano, TX 75024 (Hybrid for now but may be changed to Full onsite in the near future)

Vendor Rate: ***

Contract duration: 6 months

Target Start Date: 01 Sep 2026

Does this position require Visa independent candidates only? Yes

Interview Process (Is face to face required?) No

Job Details:

Minimum years of experience required: 9+

Certification needed: No

Must Have Skills:

• Expertise in performing SMP/E and Non-SMPE Installation of ISV products)
• Expertise in IBM and Broadcom Software product Install and Upgrades
• Mastery of DB2 and IMS Database management and utilities
• DB2 V12 upgrades or later
• IMS V15.5 upgrades or later
• Fluent in JCL and IBM Utilities (IEBGENER/IEBCOPY/AMASPZAP/DFDSS)
• ISPF/TSO and other basic
• Basic knowledge of REXX/CLIST
• Designing project plan(upgrades, maintenance, decom) with task list for all stakeholders and communicating the timelines with delivery and customer.
• Formulate roadmaps with all pre-requisites to achieve a project completion.

Nice to Have Skills:

• Coordinating with application and system teams to implement database enhancements.
• Leading service restoration for issues related to DB2 and associated software products.
• Driving continuous improvement in operational resilience, disaster recovery, and business continuity with measurable KPIs.
• Automating tasks and processes to improve efficiency and reduce manual intervention.
• Maintaining baseline operations for DB2 test and production systems, proactively identifying and resolving issues.
• Participating in disaster recovery exercises to support enterprise system recovery and business continuity.

Detailed Job Description:

Job Responsibilities

• Installation & Upgrades: Installing new DB2 and IMS versions and applying maintenance.
• Configuring DB2 and IMS subsystem parameters to optimize performance.
• Utilizing DB2 and IMS tools to monitor database health and application objects.
• Implementing DB2 and IMS security controls and collaborating with DBAs to manage application access.
• Performing SOX audits on database objects to ensure compliance standards.
• Coordinating with application and system teams to implement database enhancements.
• Leading service restoration for issues related to DB2 and associated software products.
• Driving continuous improvement in operational resilience, disaster recovery, and business continuity with measurable KPIs.
• Automating tasks and processes to improve efficiency and reduce manual intervention.
• Maintaining baseline operations for DB2 test and production systems, proactively identifying and resolving issues.
• Participating in disaster recovery exercises to support enterprise system recovery and business continuity.

Experience level

• 12+ years of professional work experience as a Mainframe System Programmer in zOS & ISVs.

Technical key skills (Mandatory skills)

• Expertise in performing SMP/E and Non-SMPE Installation of ISV products)
• Expertise in IBM and Broadcom Software product Install and Upgrades
• Mastery of DB2 and IMS Database management and utilities
• DB2 V12 upgrades or later
• IMS V15.5 upgrades or later
• Fluent in JCL and IBM Utilities (IEBGENER/IEBCOPY/AMASPZAP/DFDSS)
• ISPF/TSO and other basic
• Basic knowledge of REXX/CLIST
• Designing project plan(upgrades, maintenance, decom) with task list for all stakeholders and communicating the timelines with delivery and customer.
• Formulate roadmaps with all pre-requisites to achieve a project completion.

Custom Fields:

Name: Intake Call Completed

Value: true

Name: Intake Call Requested

Value: true