Mainframe Senior Systems Programmer / Database Administrator - Db2

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