Role Description - Work closely with all levels of IT to deploy and support z/OS Db2 infrastructure and the associated application stack. - Provide leadership in technical aspects of assigned projects and support issues; bring new ideas to the table when appropriate. - Work with companion teams to set up and enforce database standards. - Identify opportunities to improve availability, reliability, and performance of system and application infrastructure. - Monitor system and application performance & provide performance improvement recommendations. - Upgrade, configure, and migrate new releases of Db2; regularly apply maintenance, and when necessary, apply PTFs/APRS. - Manage Db2 active and archive logs. - Modify Db2 zParms. - Recycle Db2. - Ensure recoverability of the system and applications’ database components. - Support DR activities (RTO/RPO: synchronization methods). - Monitor instances for events and resolutions/escalations. - Ensure the proper alerting is occurring for Db2 messages. - Perform triage and troubleshooting. - Install, upgrade, configure and migrate new releases of Db2 ISV products, apply maintenance, and when necessary, apply fixes. - Support Db2 Independent Software Vendor (ISV) Products. - Develop scripting to automate Db2 systems engineering tasks. Qualifications - Solid knowledge in Db2 subsystems and application tuning. - A keen eye on process improvement and automation. - Competence in Incident, Problem, and Change Management. - In-depth experience in supporting mainframe technology (i.e. z/OS ISPF, JCL, JES2, etc.) specifically SMP/E or ZOSMF. - Experience reviewing HOLDDATA. - Utilize stand-alone utilities (i.e. DSNJLOGF, DSNJU004, DSNJU003, etc.). - Understand logical and physical database design. - Experience as a z/OS DB2 administration, working with DDL, DML/DQL, DCL, DTL, DB2 commands, and SQL. - System and Application Performance tuning; including tuning bufferpools. - Experience in the Db2 Utilities (i.e. COPY, QUIESCE, REPAIR, REORG, LOAD, etc.). - Understand RACF Security. - Understand Db2 managed security using RACF opposed to Db2 security. - Bachelor's Degree or equivalent experience. - 4-5 years professional experience, which may include: - 5 years of professional IT experience. - 5 years’ experience with at least one OS/hosting platform. - 5 years’ experience in performance tuning of application stacks. - 5 years’ experience with monitoring and performance management of systems. - 3-5 years’ experience with identity platform and tools. - 2 years’ experience with modern development and scripting languages. - Experience with CICD concepts, tools, branching strategies, and leveraging knowledge to assist in delivering an infrastructure as a product. - Excellent troubleshooting skills within area of expertise, and solid troubleshooting in adjacent domains. - Solid understanding of traditional or cloud computing technologies including Networking, Compute, Storage, Development, Data, Operations, or Security. - Experience with multiple delivery methodologies such as Agile and Waterfall. Skills You Have - Accountability: Holds self and their direct reports accountable for measurable, high-quality, timely, and cost-effective results, delivery, and execution. - Adaptive Communication: Formulates strategies to convey complex information to targeted audiences; communicates between technical and non-technical audiences. - Analytical Thinking: Organizes and compares various aspects of a situation to identify key issues through quantitative data and analysis. - Cross Functional Partnering & Planning: Facilitates collaboration and planning with individuals and teams from different functions to achieve common goals. - Infrastructure Development: Analyzes, designs, implements, secures, and maintains hardware, network, and data storage platforms. - Learning Agility & Critical Thinking: Pursues continuous learning and utilizes critical thinking to identify opportunities and improve processes. - Monitor System Health: Applies knowledge of tools to monitor performance of systems, networks, and applications. - OS Level Knowledge: Leverages concepts of operating systems to manage different operating systems effectively. - Technical Problem Solving: Conducts in-depth analysis of technology needs and applies best practices to solve problems effectively. Compensation Range - Pay Range - Start: $108,160.00 - Pay Range - End: $162,240.00 - Geographic Specific Pay Structure: - Structure 110: $118,960.00 USD - $178,440.00 USD - Structure 115: $124,400.00 USD - $186,600.00 USD

• Lead client and project engagements to assess requirements and define database design strategies • Analyze user needs and develop technical specifications ensuring performance, security, and data integrity • Design, develop, implement, and maintain database solutions, including automation of data processes and reporting capabilities • Monitor and optimize database performance, manage production support activities (e.g., backup/recovery, archiving), and implement standards • Drive continuous improvement by maintaining documentation, evaluating emerging technologies, and providing guidance to junior team members

• Design, implement, maintain and optimize complex, enterprise-class database systems. • Collaborate with IT teams, business stakeholders, and application developers to ensure optimal database performance, data integrity, and security.

• Lead the administration, configuration, performance tuning, and complex troubleshooting in production environments for MySQL and PostgreSQL. • Manage, monitor, and scale databases hosted on Amazon AWS, primarily utilizing RDS (Relational Database Service). • Design and implement seamless data migration and replication strategies from transactional systems to the Datalake using AWS DMS (Data Migration Service). • Collaborate on the architecture of real-time data pipelines leveraging data streaming tools such as Kafka or Kinesis. • Actively participate in data validation, integrity control, and data discrepancy analysis between source systems and analytical repositories. • Define optimal data modeling and structures that impact the Datalake and satellite systems.