Senior Engineer – Mainframe DB2 Logical

Role Overview

• Install and maintain mainframe DB2 software
• Estimate and plan for installation and upgrade activities as well as new customer transition projects
• Ensure system improvements and/or modifications are implemented
• Provide technical assistance regarding Disaster Recovery exercises and Business Continuity Processes
• Develop, enhance, and support technical approaches that allow audits and scalable implementations of large, complex mainframe environments
• Identify and resolve 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
• Participate in ongoing development and improvement of installation standards
• Work with project managers in the development and implementation of project plans and timelines
• Address and update customer incident tickets and changes orders providing internal management and customer account managers with status information
• Provide team members with technical training and/or mentoring

Requirements

• 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
• 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)
• 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

Tech Stack

• SQL

Benefits

• Annual bonus target of 10% subject to terms and conditions of plan