×
Register Here to Apply for Jobs or Post Jobs. X

Mainframe Senior Sys Prog​/Database Administrator Db

Job in Franklin, Milwaukee County, Wisconsin, 53132, USA
Listing for: Northwestern Mutual
Full Time position
Listed on 2026-06-13
Job specializations:
  • IT/Tech
    Systems Engineer, IT Support, Database Administrator, Systems Administrator
Job Description & How to Apply Below
Position: 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, DSNJU
    004, DSNJU
    003, 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 interpersonal skills to think critically about situations from multiple perspectives and consistently seeks ways to improve processes.

  • 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.

  • Infrastructure Development: Applies the knowledge of…

Position Requirements
10+ Years work experience
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
 
 
 
Search for further Jobs Here:
(Try combinations for better Results! Or enter less keywords for broader Results)
Location
Increase/decrease your Search Radius (miles)
0
200
Filters
Education Level
Experience Level (years)
Posted in last:
Salary