Mainframe Senior Sys Prog / Database Administrator - Db2

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
• 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.
• Cross Functional Partnering & Planning: Facilitates collaboration, communication, coordination, and planning with individuals and teams from different functions within the organization, and who have different areas of expertise, to achieve common goals.
• Learning Agility & Critical Thinking: Pursues learning and obtains knowledge continuously in relevant fields, methods, or technologies in current and future practices; continuously utilizes critical thinking to identify opportunities, execute solutions, and measure impact to cons

Additional Information

Mainframe Senior Sys Prog / Database Administrator - Db2

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at northwesternmutual? Share your experience