[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