Mainframe Database Specialist

About Us

At OP, we help you harness the power of technology for maximum impact. A technology consulting and solutions company, we offer advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields including AI, cyber security, enterprise architecture, and beyond. For nearly two decades, we’ve been challenging the status quo of the consulting industry, serving up fresh, ingenious thinking through a radically lean structure. Together, this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward.

Responsibilities

• 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.
• Participate in OP monthly team meetings and participate in team-building efforts.
• Contribute to OP technical discussions, peer reviews, etc.
• Contribute content and collaborate via the OP-Wiki/Knowledge Base.
• Provide status reports to OP Account Management as requested.

Requirements

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

Skills

• Expertise in performing SMP/E and Non-SMPE Installation of ISV products.
• Expertise in IBM and Broadcom Software product installation 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 basics.
• 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.

Benefits

• 401(k).
• Dental Insurance.
• Health insurance.
• Vision insurance.