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, 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.
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 endpoint management and infrastructure platforms to analyze, design, implement, secure, and maintain hardware, network, and data storage platforms while ensuring that the infrastructure platforms align with the strategic direction of the organization. Designs, maintains, upgrades, and manages data centers and other operational components to support development operations efforts. Understands impacts on software development from Hardware design review.
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 constantly improve existing practices and processes based on feedback, lessons learned, and market trends.
Monitor System Health: Applies the knowledge of various tools and techniques to monitor the performance of computer systems, networks, applications, and other infrastructure components to identify and diagnose problems, optimize performance, and ensure that the systems meet the established performance standards. Analyzes performance data, identifies trends, establishes performance baselines, sets up alerts and notifications, conducts periodic performance testing, and recommends solutions to improve system performance.
OS Level Knowledge: Leverages the fundamental concepts, principles, and components of an operating system to interact with and manage different operating systems, including installation, configuration, and maintenance. Demonstrates knowledge of how an operating system manages hardware resources, such as memory, processors, and storage, and how software interacts with these resources to design, develop, and maintain software that operates effectively on different platforms and provides the best possible user experience.
Technical Problem Solving: Conducts in-depth analysis of technology needs, issues, and roadblocks within assigned scope, applies best practice based on experience and expertise, explores the “art of possible”. Solves problems effectively and gains alignment on the path forward. Defines, understands, and documents what is being solved for.
#LI-Remote
Compensation Range:
Pay Range - Start:
$108,160.00Pay Range - End:
$162,240.00Geographic Specific Pay Structure:
Structure 110:
$118,960.00 USD - $178,440.00 USDStructure 115:
$124,400.00 USD - $186,600.00 USDWe believe in fairness and transparency. It’s why we share the salary range for most of our roles. However, final salaries are based on a number of factors, including the skills and experience of the candidate; the current market; location of the candidate; and other factors uncovered in the hiring process. The standard pay structure is listed but if you’re living in California, New York City or other eligible location, geographic specific pay structures, compensation and benefits could be applicable, click here to learn more.
Grow your career with a best-in-class company that puts our clients' interests at the center of all we do. Get started now!
Northwestern Mutual is an equal opportunity employer that welcomes talented individuals of all backgrounds. We are committed to creating and maintaining an environment in which each employee can contribute creative ideas, seek challenges, assume leadership and continue to focus on meeting and exceeding business and personal objectives.
Analytical Thinking (NM) - Advanced, Enterprise Architecture (NM) - Intermediate, Customer Centricity (NM) - Advanced, Cloud Infrastructure (NM) - Advanced, Cross Functional Partnering & Planning (NM) - Intermediate, Automation Strategy & Implementation (NM) - Advanced, Infrastructure Development (NM) - Advanced, Strategic Thinking (NM) - Intermediate, Industry Standard Frameworks (NM) - Advanced, Technical Problem Solving (NM) - Advanced, SaaS (Software as a Service) (NM) - Intermediate, OS Level Knowledge (NM) - Advanced, Business Influence (NM) - Intermediate, Adaptive Communication (NM) - Advanced, Project Methodologies (NM) - Intermediate, Monitor System Health (NM) - Advanced, Accountability (NM) - Intermediate, Learning Agility & Critical Thinking (NM) - Advanced, Programming Languages (NM) - Advanced, Container Orchestration (NM) - Intermediate
We’re excited about the potential people bring to Northwestern Mutual. You can grow your career here while enjoying first-class perks, benefits, and our commitment to a culture of belonging.
We believe relationships are built on trust. That our lives and our work matter. And that doing what’s right is good for everyone — our clients, our employees, our financial representatives and our communities.
These beliefs launched our company nearly 160 years ago. Today, they’re just a few of the reasons why people choose to build careers at Northwestern Mutual.
That means we’ll be here for the millions of people who are counting on us—our clients, our employees, our financial representatives and our communities.
We care.We make a positive difference in our communities. Nationally, thousands have benefited from our support of research and programs to fight childhood cancer. Each year, our Foundation, employees and financial representatives donate time, talent and financial support to causes they’re passionate about.
In a company with such a long and storied history, this may be the most exciting and important time to be a part of Northwestern Mutual. We’re strong, innovative and growing. And we want you to grow with us.
We invest in our people.We provide opportunities for employees to grow themselves, their careers, and, in turn, our business. Movement around the company is encouraged and we help our people build meaningful, long-term careers.
Be part of building our future.We’re expanding our campus in downtown Milwaukee overlooking Lake Michigan. The Northwestern Mutual Tower and Commons will include a state-of-the-art employee Learning Institute, and will feature a natural light-filled, 21st century work environment. This signature development reinforces our commitment to job growth, attracting top talent and drawing new business to Milwaukee.
Enjoy Milwaukee.Located on beautiful Lake Michigan, Milwaukee offers a perfect balance of big city and small town living. Home to Summerfest, the world’s largest music festival, Milwaukee has a thriving music scene, a celebrated annual film festival and vibrant performing arts community. Professional sports teams include the Milwaukee Brewers, Milwaukee Bucks and other major teams. And outdoor family fun is easy here. An extensive urban bike path network links our lakefront parks, beaches and other recreational hotspots.
At Northwestern Mutual, our employees, and our business, are always evolving. We are agile and continuously learning and improving. We have a work environment that empowers problem solving and encourages innovation—you will make an impact here.
We do what’s right.Our “do-what’s-right” value is pervasive. We ask ourselves: “Is this in the best interest of our clients? Our employees? Our financial representatives?” Acting on this value improves our clients’ experience, and makes Northwestern Mutual a better place to work.
We recognize and develop possibilities in our people.Onsite training and leadership development programs help employees succeed and grow. We also sponsor learning opportunities outside the company to help employees stay current in their fields, network with peers and gain external perspective.
Diversity makes us better.We believe diversity and inclusion cultivate creativity, innovation and a better experience for our clients. That’s why we recruit and grow people who bring unique perspectives, ideas, beliefs and cultural backgrounds.