Senior DB2 z/OS DBA

3 weeks ago


Toronto, Ontario, Canada RBC Full time

Job Summary

Job Description

What is the opportunity?

We are looking for a DB2 z/OS Application DBA for the Enterprise DBA group to provide DBA support to a list of critical applications that use DB2 z/OS technology:

  • Create databases/tables/indexes, backup/recovery strategies, tune performance of application queries, create and enhance database maintenance/utility jobs.
  • Work on projects and initiatives together with experienced DB2 z/OS and IMS DBAs.
  • Partner with DB2 z/OS System Programmers on DB2 z/OS and tools upgrades.
  • Ensure that databases are optimally designed, so that applications meet their defined SLAs, maximize reuse of existing database structures, and minimize operational costs.
  • Ensure that all database and environmental changes are appropriately tested and implemented in such a manner that there is no impact to RBC systems and clients.
  • Provide database-related technical support for development and production environment including required level of 7X24 on call support for production systems.

What will you do?

  • Help application teams with database changes/new releases. Partner with application teams on database design, changes, new application releases.
  • Partner with RBC infrastructure teams with DB2 z/OS version upgrades, maintenance and enhancement of database products, etc.
  • Create and maintain DB2 z/OS databases for application testing, pre-production verification, and production operation.
  • Provide technical support for transaction processing, data access, utilities, performance tuning, security, and database recovery.
  • Help application teams with the best use of DB2 technology and new features.
  • Perform analysis required to resolve complex technical issues/problems.
  • Research, analyze and make recommendations on software/utility usage.
  • Serve as the technical lead for projects.

What do you need to succeed?

Must Have

  • Excellent technical knowledge of database and transaction management technologies and z/OS operating system. Experience supporting critical applications that use DB2 z/OS databases.
  • High level of proven competence with data manipulation languages, data definition languages, physical database design, and application performance analysis & tuning.
  • Experience with DB2 z/OS and Tools upgrade projects.
  • Strong interpersonal and communication skills; ability to communicate with people in a wide variety of areas and at various levels from technical specialists to project managers.
  • Ability to learn and absorb quickly new concepts (in DBMS technology and infrastructure), apply new knowledge as appropriate and transfer knowledge to others.
  • Customer/service oriented and teamwork mindset.
  • Good coaching/mentoring skills.

Nice to Have

  • REXX/CLIST programming.
  • Experience supporting applications that use IMS databases. Additional training/learning might be required at RBC.

What's in it for you?

  • A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.
  • Leaders who support your development through coaching and managing opportunities.
  • Ability to make a difference and lasting impact.
  • Work in a dynamic, collaborative, progressive, and high-performing team.
  • Flexible work/life balance options.
  • Opportunities to do challenging work.
  • Opportunities to take on progressively greater accountabilities.

Job Skills

CLIST (Programming Language), Critical Thinking, Database Backup, Databasing, Decision Making, Detail-Oriented, IBM z/OS, IMS Databases, Information Security, Rexx

Additional Job Details

Address: RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

City: TORONTO

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2024-08-07

Application Deadline: 2025-03-31

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above.

Inclusion and Equal Opportunity Employment

At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.

We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.

#J-18808-Ljbffr
  • Senior DB2 z/OS DBA

    1 week ago


    Toronto, Ontario, Canada Royal Bank of Canada> Full time

    Job Summary Job DescriptionWhat is the opportunity? We are looking for a DB2 z/OS Application DBA for the Enterprise DBA group to provide DBA support to a list of critical applications that use DB2 z/OS technology:Create databases/tables/indexes, backup/recovery strategies, tune performance of application queries, create...


  • Toronto, Ontario, Canada DXC Technology Inc. Full time

    About DXC Technology Inc.DXC Technology Inc. is the world's leading independent, end-to-end IT services company, helping clients harness the power of innovation to thrive on change.We serve nearly 6,000 private and public sector clients across 70 countries.About the JobThis is a critical role within our organization, requiring a strong background in z/OS...


  • Toronto, Ontario, Canada HCLTech Full time

    Working Location: Mississauga, ON - Hybrid 3 days at office Role Responsibilities: - Upgrade/Migrate DB2 Versions to newer versions Regularly applying PTFS/APARS if required. Manage DB2 IVS Products and upgrade to supported versions if required. Managing system catalogs Manage application data and database environments, performing reorganizations when...


  • Toronto, Ontario, Canada Tata Consultancy Services Full time

    Inclusion without ExceptionTata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our...


  • Toronto, Ontario, Canada Software International Full time

    About the Role:We are looking for an experienced Senior Mainframe z/OS Storage System Programmer to join our team at Software International. In this role, you will be responsible for providing technical direction and subject matter expertise to ensure stable, reliable environments for complex sharing initiatives.You will collaborate with senior management,...


  • Toronto, Ontario, Canada Software International Full time

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US.We have a Permanent or 12 month renewable contract as a Senior Mainframe z/OS System Programmer with our large consulting client, working on a long term project for one of Canada's largest...


  • Toronto, Ontario, Canada Software International Full time

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US.We have a Permanent or 12 month renewable contract as a Senior Mainframe z/OS System Programmer with our large consulting client, working on a long term project for one of Canada's largest...


  • Toronto, Ontario, Canada Software International Full time

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US.We have a Permanent or 12 month renewable contract as a Senior Mainframe z/OS Hardware Programmer with our large consulting client, working on a long term project for one of Canada's...


  • Toronto, Ontario, Canada Cognizant Full time

    We are seeking an experienced Mainframe Tester to join our team of professionals dedicated to delivering exceptional quality in mainframe applications. As a member of our team, you will be responsible for designing, developing, and executing comprehensive testing strategies to ensure the highest level of quality.About Cognizant's Quality Engineering...


  • Toronto, Ontario, Canada Dacaro Services Full time

    TorontoCAD 100,000 - 125,000This range is provided by Dacaro Services. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Base pay rangeCA$70.00/hr - CA$100.00/hrAs a Sr. Mainframe z/OS System Programmer, you will provide technical direction and subject matter expertise to maintain stable and reliable...


  • Toronto, Ontario, Canada Software International Full time

    About UsSoftware International supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US.We are seeking a highly experienced Senior Mainframe RACF Security Administrator to join our team, working on a long term project for one of Canada's largest banks.Job DescriptionAs a...


  • Toronto, Ontario, Canada Experis Full time

    Job OverviewWe are seeking a highly skilled Mainframe z/OS Specialist to join our team in Toronto, ON.This role involves providing primary zOS support for IBM commercial mainframe accounts, installing and maintaining Mainframe z/OS and related ISVs, and engaging in problem determination and resolution to ensure high customer satisfaction.


  • Toronto, Ontario, Canada BMO Financial Group Full time

    BMO Financial Group is seeking a Z/OS Application Support Lead to join its team. In this role, you will be responsible for leading the support of the bank's Z/OS applications, ensuring they operate efficiently and effectively.Key Responsibilities:Provide technical leadership and support for Z/OS applicationsAnalyze and resolve complex application...

  • Lead Mainframe DBA

    3 days ago


    Toronto, Ontario, Canada Sun Life Full time

    Job Description : What will you do? Be an integral part of the DBA team with expanded responsibilities towards all aspects of mainframe modernization. Help expand usage of mainframe DevOps tools for database administration. Investigate and implement solutions that can produce cost reductions and/or improve performance. Market and communicate strategy...


  • Toronto, Ontario, Canada Software International Full time

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US.We have a Permanent or 12 month renewable contract as a Senior Mainframe z/OS Storage System Programmer with our large consulting client, working on a long term project for one of Canada's...


  • Toronto, Ontario, Canada Software International Full time

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US.We have a Permanent or 12 month renewable contract as a Senior Mainframe z/OS Storage System Programmer with our large consulting client, working on a long term project for one of Canada's...


  • Toronto, Ontario, Canada Experis Full time

    Our client, a leader in technology solutions, is seeking a Mainframe z/OS Specialist to join their team. As a Mainframe z/OS Specialist, you will be part of the IT department supporting complex network and systems environments. The ideal candidate will have strong problem-solving skills, excellent communication abilities, and a proactive approach to...

  • z/OS System Architect

    3 hours ago


    Toronto, Ontario, Canada SML Inox Full time

    SML Inox is seeking a highly skilled Senior Mainframe Security Architect to join our team.The ideal candidate will have a strong understanding of Mainframe security, specifically 8 years' experience as a z/OS System Programmer.Main Responsibilities:Design and implement secure solutions for mainframe environments.Collaborate with clients and sales teams to...


  • Toronto, Ontario, Canada BMO Financial Group Full time

    Job SummaryWe are seeking an experienced IBM z/OS Network Expert to join our team at BMO Financial Group. As a key member of our infrastructure operations team, you will provide technical leadership and expertise to ensure the smooth operation of our mainframe network platforms.Your primary responsibilities will include providing real-time production support...


  • Toronto, Ontario, Canada Software International Full time

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US.We have a Permanent or 12 month renewable contract as a Senior Mainframe RACF Security Administrator with our large consulting client, working on a long term project for one of Canada's...