Mainframe Senior Sys Prog / Database Administrator – Db2

Mainframe Senior Sys Prog / Database Administrator – Db2     What You'll Do 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       What You'll Bring to the Role 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. 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. Determines objectives, sets priorities, delegates work to direct reports, and accepts responsibility for mistakes. Adaptive Communication: Formulates strategies to be used to convey complex information about services, products, systems, or processes to targeted audiences; communicates and liaises between technical and non-technical audiences. Analytical Thinking: Organizes and compares various aspects of a situation to comprehend and identify key or underlying complex issues through the use of quantitative data and analysis; leverages strong business acumen, problem solving, and