Talent.com
Sun Life
Mainframe DBASun Life • Waterloo, Ontario
Mainframe DBA

Mainframe DBA

Sun Life • Waterloo, Ontario
30+ days ago
Job type
  • Full-time
Job description

Job Description

:

The candidate will be a member of the Mainframe Database Services team within the Data Management Services department. The primary goal of the team is to provide Db2 for z/OS and IMS database administration support to various Canadian and US applications. The role will also provide the opportunity to work on infrastructure projects and other peripheral technologies.

We are looking for a dynamic and motivated individual to play an integral part in our team's mission to provide high quality database administration support to Sun Life clients. Our clients depend on mainframe databases for several key applications and the dependency is expected to continue well into the future.

  • Provide application-level database administration and support for Db2 for z/OS and IMS databases
  • Execute and manage Db2 utilities
  • Perform SQL tuning and optimization to improve application query performance
  • Support IMS application DBA tasks including DBD (Database Descriptor) changes and modifications
  • Maintain and execute IMS utilities (Database Image Copy, Database Recovery, Database Reorganization)
  • Create new database objects or modify existing ones as requested by clients
  • Ensure databases are available as per service level agreements, meet database integrity and recoverability
  • Ensure database performance meets client demands through pro-active and reactive monitoring
  • Manage database storage allocation, space management, and growth monitoring
  • Execute database refresh and cloning activities for non-production environments
  • Recommend ways to improve processes, exploit new database features/related tools and reduce cost
  • Take steps to ensure proper capacity planning, assist with security setup and audit requirements
  • Assist with data archiving, data masking and test data creation
  • Database design involvement and recommendations regarding logical to physical model implementations
  • Support developers with regards to database topics (SQL-queries, IMS DLI calls, tools usage etc.)
  • Participate in on-call rotation for Db2 for z/OS database support
  • Excellent communication skills and experience assisting clients with connectivity, permission and access issues
  • Analytical, problem-solving, detailed skills and ability to produce high-quality deliverables
  • Organizational, monitoring, multi-tasking skills and ability to escalate to manager when issues arise
  • Work independently on multiple tasks and priorities simultaneously under high-pressure workloads
  • Work with team members, technical/team leads, management, IT areas and application support teams to ensure consistent delivery and quality of database services
  • Ability to evaluate functionality and features with newer versions of the IMS and Db2 DBMS as part of a readiness program
  • Collaborate with infrastructure teams on cross-functional tasks when needed
  • Document database configurations, procedures, and best practices

What you need to succeed:

  • Degree in Computer Science or Technology degree/diploma
  • 5+ years knowledge of IMS and/or Db2 for z/OS (administration, performance, security etc.)
  • 5+ years of Experience with RACF or ACF2
  • 5+ years of JCL skills
  • Strong experience with DB2 utilities and IMS utilities
  • Proven experience with SQL query tuning and performance optimization
  • Proficient in IMS application DBA tasks including DBD maintenance
  • Experience with peripheral tools and technologies (IBM HP IMS utilities, Broadcom Db2 tools, File Aid, CA-7, ZEKE, REXX etc.)
  • Knowledge of Mainframe programming languages and MQ and/or Db2 Connect
  • Scripting experience with REXX (Python scripting highly preferred)
  • Demonstrated ability to work independently and handle high-pressure workloads
  • Strong problem-solving and analytical skills
  • Flexibility to handle multiple concurrent tasks and shifting priorities

Preferred Qualifications:

  • Experience with Optim data masking and data archive tools
  • Familiarity with insurance industry applications
  • Experience with data warehouse environments
  • Experience with mainframe modernization initiatives
  • Proficiency with zDevOps tools including:ZoweIBM Db2 Admin FoundationAnsible
  • Experience with database automation and scripting
  • Understanding of ITIL or similar service management frameworks

Note: As a condition of the role, the successful candidate must obtain a Government of Canada Reliability Status security clearance through Sun Life.

What's in it for you:

  • Flexible hybrid work model including in-country work-from-home
  • Pension, stock and savings programs to help build and enhance your future financial security
  • An environment of continuous learning and improvement
Create a job alert for this search

Mainframe DBA • Waterloo, Ontario

Similar jobs

Senior IT Business Analyst

Manulife FinancialWaterloo, Region of Waterloo, CA
Full-time

Join our Manulife Bank Technology Team!.This role offers the opportunity to play a pivotal part in the evolution of our Core Banking Platform, supporting critical capabilities across Deposits, Mort... Show more

 • Promoted

Azure Databricks Engineer

Tredence Inc.waterloo, on, ca
Full-time

We are seeking a skilled Azure Databricks Engineer with strong experience in Azure Data Factory (ADF) to design, develop, and maintain scalable data pipelines and analytics solutions on the Azure c... Show more

 • Promoted

Software Engineering Manager - Desktop and Embedded Linux Optimisation

CanonicalWaterloo, Ontario, Canada
Full-time

Software Engineering Manager - Desktop and Embedded Linux Optimisation.Software Engineering Manager - Desktop and Embedded Linux Optimisation.Canonical Software Engineering Manager - Desktop and Em... Show more

 • Promoted

Housekeeper Wanted - Housekeeper Wanted In Elmira, On — Earn $20/Hour Cleaning & Organizing Homes

Housekeeper.comElmira, Ontario, Canada
CA$20.00 hourly
Full-time

Hello! I'm Dale, a homeowner in Elmira, Ontario, and I'm currently seeking a dedicated and reliable housekeeper to help maintain my home.If you have a keen eye for detail and enjoy keeping ... Show more

 • Promoted

Bilingual EDI & AS400/RPG Analyst/Developer

Q1 Technologies, Inc.waterloo, on, ca
Permanent

Role: Bilingual EDI & AS400/RPG Analyst/Developer.Bilingual proficiency in English and French.Experience on AS400 programming- RPGLE, RPG, SQL, CL, CLLE.Proficiency with EDI and experience with Tru... Show more

 • Promoted

Senior Dell Backup Consultant (remote) - Ateko, backed by Bell Canada

Ateko, backed by Bell Canadawaterloo, on, ca
Remote
Full-time

Reliability Status clearance required.Our client is currently seeking a Senior resource to provide support in their backup solutions.Client utilizes the following:.If you possess a secondary skill ... Show more

 • Promoted

Pigment Solution Architect - Brabner Fox

Brabner Foxwaterloo, on, ca
Full-time +1

We are partnering with a rapidly growing, Pigment consultancy (tiered exclusive partner) that is scaling rapidly with a strong pipeline of major wins.The firm specializes in delivering high-impact ... Show more

 • Promoted

Senior Programmer Analyst - $90,000 - $100,000 A Year

Vitran Express (TFI)Woodstock, Canada
Full-time

The programmer analyst will administer IT systems, gather user requirements, and manage projects.Strong SQL and Windows Server admin skills are preferred. Show more

 • Promoted

URGENT: Nanny Wanted - Dedicated Nanny Wanted In Floradale, Ontario $20.00 Per Hour For Caring

CanadianNanny.caFloradale, Ontario, Canada
CA$20.00 hourly
Part-time

We are a loving family based in Floradale, Ontario, seeking a part-time nanny to help care for our daughter before and after school.If you have experience working with primary school-aged children ... Show more

 • Promoted

Algebra Private Tutoring Jobs Conestogo

SuperprofConestogo, CA
Full-time

Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi... Show more

 • Promoted

Manager, IT Infrastructure & Cyber Security

CarePartnersWaterloo, ON, CA
CA$95,000.00 yearly
Full-time

Are you a hands-on IT leader passionate about building secure, scalable, and resilient technology environments? We are seeking a strategic and technically strong.Manager, IT Infrastructure & Cyber ... Show more

 • Promoted

Developer/Analyst - Navacord

Navacordwaterloo, on, ca
Full-time

Navacord is hiring technical talent in the insurance industry! We are accepting applications for a dynamic individual with 5+ years experience in a full stack development environment and with at le... Show more

 • Promoted

Senior Analyst for Banking Technology

Manulife FinancialWaterloo, Region of Waterloo, CA
Full-time

Manulife is looking for a Senior IT Business Analyst in Waterloo, Ontario, to enhance our Core Banking Platform.Offer your expertise in deposits, mortgages, and fraud analysis and help shape bankin... Show more

 • Promoted

Modern Workplace & Cloud Operations Administrator

CarePartnersWaterloo, ON, CA
CA$75,000.00 yearly
Full-time

Modern Workplace & Cloud Operations Administrator.Tier 3 operational role responsible for ensuring the stability, security, and efficiency of Microsoft 365, Intune-managed endpoints, Azure Virtual ... Show more

 • Promoted

Azure Databricks Engineer - Tredence Inc.

Tredence Inc.waterloo, on, ca
Full-time

We are seeking a skilled Azure Databricks Engineer with strong experience in Azure Data Factory (ADF) to design, develop, and maintain scalable data pipelines and analytics solutions on the Azure c... Show more

 • Promoted

Bilingual EDI & AS400/RPG Analyst/Developer - Q1 Technologies, Inc.

Q1 Technologies, Inc.waterloo, on, ca
Permanent

Role: Bilingual EDI & AS400/RPG Analyst/Developer.Bilingual proficiency in English and French.Experience on AS400 programming- RPGLE, RPG, SQL, CL, CLLE.Proficiency with EDI and experience with Tru... Show more

 • Promoted

Engineering Manager(s), Manulife Bank

Manulife FinancialWaterloo, Ontario, Canada
Full-time

Join our Manulife Bank Technology Team! We have 2 Engineering Manager openings for our squads.Squad 1: Backend Data Squad 2: Vendor System production If you have experience leading squads and passi... Show more

 • Promoted

Senior Dell Backup Consultant (remote)

Ateko, backed by Bell Canadawaterloo, on, ca
Remote
Full-time

Reliability Status clearance required.Our client is currently seeking a Senior resource to provide support in their backup solutions.Client utilizes the following:.If you possess a secondary skill ... Show more

 • Promoted

Oracle Developer: PL/SQL & Forms for ERP Integration

Insight GlobalSt. Jacobs, ON, CA
Temporary

A leading staffing agency is seeking an experienced Oracle Developer for a 12-month contract in St.The successful candidate will work on an ERP integration project, collaborating in an agile/scrum ... Show more

 • Promoted

Software Business Analyst - Alpha Bravo Development

Alpha Bravo Developmentwaterloo, on, ca
Full-time

We’re a fast-growing software development agency that helps service-based businesses across the U.Our team values ownership, innovation, and building long-term partnerships with clients.We’re looki... Show more