Northwestern Mutual

Mainframe Senior Sys Prog / Database Administrator - Db2

Northwestern Mutual$108K — $162K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in IT, specifically mainframe technology and Db2 administration
  • Solid knowledge of database tuning and design
  • Experience in performance monitoring and management for systems and application stacks
  • Bachelor's Degree or equivalent experience
  • Proficiency in automation through scripting and modern development languages
  • Solid understanding of security management with RACF
  • Familiarity with CI/CD concepts and methodologies

Responsibilities

  • Deploy and support z/OS Db2 infrastructure across IT levels
  • Lead technical projects and support initiatives, offering innovative suggestions
  • Collaborate to set and maintain database standards
  • Identify and implement improvements for system reliability and performance
  • Conduct performance monitoring and provide recommendations
  • Upgrade and configure Db2 systems, applying necessary fixes
  • Manage database logs and ensure recoverability of components

Benefits

  • Remote work flexibility
  • Opportunities for professional growth and development
  • Access to advanced technology and tools
  • Supportive team environment promoting collaboration
  • Health and wellness resources
  • Potential for performance-based rewards
  • Comprehensive training and onboarding processes
Full Job Description
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.00

Pay Range - End:
$162,240.00

Geographic Specific Pay Structure:

Structure 110:
$118,960.00 USD - $178,440.00 USD

Structure 115:

$124,400.00 USD - $186,600.00 USD

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

About Northwestern Mutual

Northwestern Mutual has been helping people and businesses achieve financial security for more than 160 years. Through a holistic planning approach, Northwestern Mutual combines the expertise of its financial professionals with a personalized digital experience and industry-leading products to help its clients plan for what's most important. Northwestern Mutual delivers financial security to millions with life, disability income and long-term care insurance, annuities, and brokerage and advisory services. The company manages billion of dollars of investments owned by its clients and held or managed through its wealth management and investment services businesses. Northwestern Mutual is the marketing name for The Northwestern Mutual Life Insurance Company (NM), Milwaukee, WI (life and disability insurance, annuities, and life insurance with long-term care benefits) and its subsidiaries. Subsidiaries include Northwestern Mutual Investment Services, LLC (NMIS) (securities), broker-dealer, registered investment adviser, member FINRA and SIPC; the Northwestern Mutual Wealth Management Company® (NMWMC) (fiduciary and fee-based financial planning services), federal savings bank; and Northwestern Long Term Care Insurance Company (NLTC) (long-term care insurance).

Northwestern Mutual Careers

Joining Northwestern Mutual presents a unique opportunity to be part of a team that is dedicated to empowering personal and professional growth, innovation, and leadership in the financial services industry. As a company renowned for its commitment to excellence and a culture that values diversity and inclusion, Northwestern Mutual offers unparalleled job opportunities for both seasoned professionals and those at the start of their careers.

Work You’ll Do

At Northwestern Mutual, we believe in building strong relationships not only with our clients but also among our team members. By joining our team, you will collaborate with some of the most talented professionals in the industry, all united in their commitment to leadership and innovation. Our employees are equipped with top-tier benefits and diversity training that ensure their career journey is both rewarding and inclusive.

Explore Professional Growth and Development

Northwestern Mutual is committed to fostering an environment where career growth is not just a possibility but a priority. With a variety of positions available, from financial representatives to internships for budding professionals, our company is a place where your skills and passion can thrive. We provide extensive training programs and leadership development opportunities that prepare you for success in your current role and beyond.

Innovative Work Environment

Our team at Northwestern Mutual is at the forefront of integrating cutting-edge technology and innovative financial strategies to provide exceptional service to our clients. This focus on innovation is not just about staying current; it's about leading the way in the financial sector. Employees at all levels are encouraged to contribute ideas and take initiative, driving the company forward as a leader in the financial industry.

Be Part of Our Diverse and Inclusive Team

Diversity and inclusion are more than just buzzwords at Northwestern Mutual; they are integral to our company culture and business strategy. We are committed to creating a workplace where all employees can flourish. Our diversity training programs are designed to enhance understanding and foster an inclusive environment for all team members.

Networking and Career Advancement

Networking within Northwestern Mutual opens doors to expansive career advancement opportunities. We encourage our employees to engage in internal networking events, which often lead to mentorship and further career development. Whether you are looking to enhance your resume, prepare for an interview, or step into a leadership role, Northwestern Mutual provides the resources and support to help you achieve your professional goals.

Join Our Team

Search open positions that match your skills and interests. We are looking for passionate, curious, and solution-driven team players who are ready to take their career to the next level. Explore the job opportunities and internships available at Northwestern Mutual and find out how you can contribute to our legacy of innovation and leadership.

Stay Connected

Keep up to date with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who work here. Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities that await at Northwestern Mutual.

SEARCH NORTHWESTERN MUTUAL JOBS

Join us and start your journey at Northwestern Mutual today, where your career is nurtured, your skills are honed, and your achievements are celebrated.
Learn more about Northwestern Mutual
Size
7,000 employees
Industry

Similar Jobs

More Jobs at Northwestern Mutual

  • Northwestern Mutual
    Financial Advisor
    $61K — $250K *
    Atlanta, GA 30349 (Fulton County)
    Finance & Insurance
    In-Person
  • Northwestern Mutual
    Financial Advisor
    $61K — $250K *
    Charlottesville, VA 22903 (Charlottesville City County)
    Finance & Insurance
    In-Person
  • Northwestern Mutual
    Financial Advisor
    $61K — $250K *
    Indianapolis, IN 46227 (Marion County)
    Finance & Insurance
    In-Person
  • Northwestern Mutual
    Financial Advisor
    $61K — $250K *
    Crown Point, IN 46307 (Lake County)
    Finance & Insurance
    In-Person
  • Northwestern Mutual
    Field Claims Consultant
    $81K — $121K *
    Remote
    Finance & Insurance
    Remote in Wisconsin, US

More Information Technology Jobs

Find similar Mainframe Senior Sys Prog / Database Administrator - Db2 jobs: