Lead DB2 LUW Database Administrator

1 month ago


Mississauga, Ontario, Canada Intact Financial Corporation Full time

Position Overview

At Intact Financial Corporation, our mission revolves around empowering individuals, businesses, and communities to thrive in both prosperous and challenging times. Our workforce is a vibrant community of professionals dedicated to this purpose.

We prioritize your personal and professional development, valuing the unique contributions you bring to our diverse environment. Our commitment to your growth is reflected in the resources, opportunities, and flexibility we provide.

Our hybrid work model strikes a balance between remote work and valuable in-person collaboration.

Role Summary

We are in search of a seasoned DB2 LUW Database Administrator. Our DB2 systems are predominantly hosted on AIX, with a minor presence on Linux. You will be responsible for overseeing a total of 55 DB2 instances, primarily supporting Enterprise Document systems.

The ideal candidate will work in a hybrid setting (2 days in the office) within a compact DB2 team, integrated into a larger DBA group that manages various database management systems, including Oracle, SQL Server, Postgres, and MongoDB.

Key Responsibilities:

  • Install, design, and maintain DB2 database system software while implementing robust database security measures.
  • Monitor and evaluate database performance to ensure optimal utilization of systems and processes.
  • Maintain essential DB2 support tools.
  • Develop and uphold comprehensive system documentation.
  • Contribute to the strategic, architectural, and tactical planning for database systems.
  • Stay informed about future system directions and their implications for the organization, leveraging current and future database systems for maximum benefit.
  • Provide technical leadership in DB2 database systems and solutions.
  • Offer individual mentoring and training on database technologies and tools.
  • Assess, test, and recommend new technologies and software tools.
  • Implement and advocate for improvements in database operations.
  • Establish and maintain a Business Continuity solution for the DB2 environment, including software installation and replication processes.
  • Create and sustain high-value scripts to automate database administration tasks, such as installations and security patch deployments, primarily using KSH (Korn shell).
  • Share on-call responsibilities in a 24/7 operational environment.

Qualifications:

  • A minimum of 10 years of IT experience.
  • 5 to 10 years of experience working with DB2 LUW.
  • Proficiency in AIX/Linux environments.
  • Strong scripting skills, particularly in Korn shell.
  • Ability to work independently and effectively.
  • Familiarity with Windows desktop tools.
  • Bilingualism is required for candidates located in Quebec due to regular interactions with English-speaking colleagues.
  • Eligibility to work in Canada is necessary, though Canadian work experience is not mandatory.

What We Offer:

Being part of our organization means you will be empowered to excel in your role. Here’s what you can expect as a permanent member of our team:

  • A financial rewards program recognizing your achievements.
  • An industry-leading Employee Share Purchase Plan with a 50% match on net shares purchased.
  • An extensive pension and benefits package, including access to virtual healthcare.
  • Flexible work arrangements.
  • The option to purchase up to 5 additional days off each year.
  • An annual wellness account promoting a healthy lifestyle.
  • Access to resources supporting physical and mental well-being, fostering connections with colleagues.
  • A dynamic learning environment featuring interactive online content and inspiring programs.
  • Employee-led networks promoting education, inspiration, and development opportunities.
  • Supportive leaders and colleagues committed to your growth.
  • A Community Impact program that encourages unique contributions to your community.


  • Mississauga, Ontario, Canada Intact Financial Corporation Full time

    Position OverviewAt Intact Financial Corporation, our mission is to empower individuals, businesses, and communities to thrive in both prosperous and challenging times. We are committed to fostering a culture where our employees feel valued and supported in their professional growth.Role SummaryWe are currently looking for a seasoned DB2 LUW Database...


  • Mississauga, Ontario, Canada Intact Financial Corporation Full time

    Company OverviewAt Intact Financial Corporation, our workforce is central to our mission: to empower individuals, organizations, and communities to thrive in both prosperous and challenging times. We are committed to fostering a culture where diversity is celebrated and every employee is valued.Work EnvironmentOur hybrid work model strikes a balance between...


  • Mississauga, Ontario, Canada Intact Financial Corporation Full time

    About Intact Financial Corporation At Intact Financial Corporation, we're dedicated to helping individuals, businesses, and communities thrive during both prosperous times and challenging circumstances. Our team of passionate experts is driven by a shared purpose: to empower our customers and make a positive impact on the world. About the Role We're seeking...


  • Mississauga, Ontario, Canada Intact Financial Corporation Full time

    About the RoleWe are seeking an experienced DB2 LUW Database Administrator to join our team at Intact Financial Corporation. As a key member of our database team, you will be responsible for designing, implementing, and maintaining complex database systems that support our Enterprise Document systems.Key ResponsibilitiesInstall, design, and maintain DB2...


  • Mississauga, Ontario, Canada Intact Financial Corporation Full time

    About the RoleWe are seeking an experienced DB2 LUW Database Administrator to join our team at Intact Financial Corporation. As a key member of our database team, you will be responsible for designing, implementing, and maintaining complex database systems that support our Enterprise Document systems.Key ResponsibilitiesInstall, design, and maintain DB2...


  • Mississauga, Ontario, Canada Intact Financial Corporation Full time

    About the RoleWe are seeking an experienced DB2 LUW Database Administrator to join our team at Intact Financial Corporation. As a key member of our database team, you will be responsible for designing, implementing, and maintaining complex database systems that support our Enterprise Document systems.Key ResponsibilitiesInstall, design, and maintain DB2...


  • Mississauga, Ontario, Canada Intact Financial Corporation Full time

    About the RoleWe are seeking an experienced DB2 LUW Database Administrator to join our team at Intact Financial Corporation. As a key member of our database team, you will be responsible for designing, implementing, and maintaining complex database systems that support our Enterprise Document systems.Key ResponsibilitiesInstall, design, and maintain DB2...


  • Mississauga, Ontario, Canada Cognizant Full time

    Unlock Your Potential as a Senior DB2 UDB Database AdministratorCognizant is a global community that sets us apart—an energetic, collaborative, and inclusive workplace where everyone can thrive. With projects at the forefront of innovation, you can build a varied and rewarding career and draw inspiration from dedicated colleagues and leaders.Key...


  • Mississauga, Ontario, Canada Cognizant Full time

    Unlock Your Potential as a Senior DB2 UDB Database AdministratorCognizant is a global community that sets us apart—an energetic, collaborative, and inclusive workplace where everyone can thrive. With projects at the forefront of innovation, you can build a varied and rewarding career and draw inspiration from dedicated colleagues and leaders.Key...


  • Mississauga, Ontario, Canada Intact Financial Corporation Full time

    About the RoleWe are seeking an experienced Database Administrator to join our team at Intact Financial Corporation. As a key member of our database team, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance and security.Key ResponsibilitiesDesign and implement database systems to meet...


  • Mississauga, Ontario, Canada Intact Financial Corporation Full time

    About the RoleWe are seeking an experienced Database Administrator to join our team at Intact Financial Corporation. As a key member of our database team, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance and security.Key ResponsibilitiesDesign and implement database systems to meet...


  • Mississauga, Ontario, Canada Cognizant Full time

    About the RoleCognizant is seeking a highly skilled Senior Database Administrator to join our team. As a key member of our database administration team, you will be responsible for ensuring the smooth operation of our DB2 UDB databases.Key ResponsibilitiesDatabase Upgrades: Perform database upgrades from DB2 UDB versions 10.5 and 11.1 to 11.5, ensuring...


  • Mississauga, Ontario, Canada Cognizant Full time

    About the RoleCognizant is seeking a highly skilled Senior Database Administrator to join our team. As a key member of our database administration team, you will be responsible for ensuring the smooth operation of our DB2 UDB databases.Key ResponsibilitiesDatabase Upgrades: Perform database upgrades from DB2 UDB versions 10.5 and 11.1 to 11.5, ensuring...


  • Mississauga, Ontario, Canada Infosys Limited Full time

    Job SummaryInfosys Limited is seeking a skilled Database Administrator Lead to join our team. As a key member of our IT infrastructure team, you will be responsible for designing, implementing, and maintaining our Peoplesoft system.Key ResponsibilitiesDesign and implement Peoplesoft system architecture to meet business requirements.Develop and maintain...


  • Mississauga, Ontario, Canada Infosys Limited Full time

    Job SummaryInfosys Limited is seeking a skilled Database Administrator Lead to join our team. As a key member of our IT infrastructure team, you will be responsible for designing, implementing, and maintaining our Peoplesoft system.Key ResponsibilitiesDesign and implement Peoplesoft system architecture to meet business requirements.Develop and maintain...


  • Mississauga, Ontario, Canada Infosys Limited Full time

    Job Summary:This is a challenging role for a skilled Database Administrator Team Lead who will be responsible for leading a team of database administrators in the administration of Peoplesoft applications. The successful candidate will have a strong background in database administration, including experience with Peoplesoft administration tools and...


  • Mississauga, Ontario, Canada Infosys Limited Full time

    Job Summary:This is a challenging role for a skilled Database Administrator Team Lead who will be responsible for leading a team of database administrators in the administration of Peoplesoft applications. The successful candidate will have a strong background in database administration, including experience with Peoplesoft administration tools and...


  • Mississauga, Ontario, Canada AG Marketing & Development Group Inc Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at AG Marketing & Development Group Inc. As a key member of our IT department, you will be responsible for designing, developing, and implementing database systems to support our business operations.Key Responsibilities:Design and develop database systems...


  • Mississauga, Ontario, Canada AG Marketing & Development Group Inc Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at AG Marketing & Development Group Inc. As a key member of our IT department, you will be responsible for designing, developing, and implementing database systems to support our business operations.Key Responsibilities:Design and develop database systems...


  • Mississauga, Ontario, Canada Canada Cartage Group Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Canada Cartage Group. As a key member of our IT department, you will be responsible for the administration and support of our Microsoft SQL databases.Key Responsibilities:Administer and support production, development, testing, and staging databases...