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
At Northwestern Mutual, our financial advisors are ready to meet you where you are and stay with you long-term. It was founded in 1857, and is headquartered in Milwaukee, Wisconsin, USA, with a workforce of 5001-10000 employees. Its website is https://clinton.nm.com.Company H1B Sponsorship
Northwestern Mutual has a track record of offering H1B sponsorships, with 1 in 2020. Please note that this does not guarantee sponsorship for this specific role.