• 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