[Remote] Mainframe Senior Sys Prog / Database Administrator – Db2

Note: The job is a remote job and is open to candidates in USA. Northwestern Mutual is a leading financial services company, and they are seeking a Mainframe Senior Sys Prog / Database Administrator specializing in Db2. The role involves deploying and supporting z/OS Db2 infrastructure, providing leadership in technical projects, and ensuring the performance and reliability of system and application infrastructure.

Responsibilities

• 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

Skills

• 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

Company Overview

Company H1B Sponsorship