Talent.com
Mainframe DBA
Mainframe DBASun Life • Sun Life Toronto One York
Mainframe DBA

Mainframe DBA

Sun Life • Sun Life Toronto One York
Il y a 4 jours
Type de contrat
  • Temps plein
Description de poste

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
Créer une alerte emploi pour cette recherche

Mainframe DBA • Sun Life Toronto One York

Offres similaires

Oracle 11g DBA

ROSSMarkham, York Region, CA
Temporaire

Our client is a medium sized software vendor.They are located in Markham and looking for an Oracle 11g DBA for a three month contract to ideally start immediately.Part of your work will be onsite a...Voir plus

 • Offre sponsorisée

Associate, Systems Management (Mainframe)

360trainingToronto, Canada
Temps plein

Projects Delivery -** Act as Subject Matter Expert (SME) you will be providing inputs to database standards, designs and best practices ensuring compliance with relevant organizational standards.Re...Voir plus

 • Offre sponsorisée

Mainframe Architect

Avanciers Inc.Toronto, Canada
Temps plein

Role Summary Avanciers is a premier IT Staffing/Consulting organization recruiting for a long-term contract role for one of our premier clients in Canada, for a Mainframe Architect position.Respons...Voir plus

 • Offre sponsorisée

Lead Mainframe Programmer - Endevor Skills

Info-WaysToronto, Canada
Temps plein

Installs and customizes ISV software tools in a z/OS mainframe environment, provides support, and ensures system availability and readiness.Responsible for problem resolution, monitoring, and capac...Voir plus

 • Offre sponsorisée

Mainframe z/OS Administrator & Programmer — 24x7 On-Call

DXC TechnologyToronto, Ontario, Canada
Temps plein

A leading enterprise technology provider is seeking an experienced Mainframe z/OS System Administrator/Programmer in Toronto, Ontario.This role involves supporting z/OS environments, performing sof...Voir plus

 • Offre sponsorisée

Senior PostgreSQL DBA — HA & Performance Leader

GalentMarkham, York Region, CA
Temps plein

A technology company is seeking a Senior PostgreSQL System Administrator with 5 to 7 years of hands-on experience managing large-scale PostgreSQL environments.Responsibilities include leading insta...Voir plus

 • Offre sponsorisée

Mainframe Programmer

LanceSoft, Inc.Toronto, Canada
Temps plein

OverviewResponsible for designing and maintaining the operating environment that powers the Firm's z-platform computing infrastructure.This role ensures high availability, performance, and scalabil...Voir plus

 • Offre sponsorisée

Mainframe Developer

Compunnel, Inc.Markham, York Region, CA
Temps plein

We are seeking an experienced Mainframe Developer with a strong background in COBOL and Informatica, particularly within the insurance industry.The ideal candidate will be responsible for developin...Voir plus

 • Offre sponsorisée

Mainframe Software Engineer – Payments & Core Banking

ScotiabankToronto, Ontario, Canada
Temps plein

A leading Canadian bank is seeking an experienced Full Stack Developer located in Toronto, Ontario.The role involves collaborating with teams, providing software solutions, and ensuring compliance ...Voir plus

 • Offre sponsorisée

Mainframe Architect - Remote

Avanciers Inc.Toronto, Canada
Télétravail
Temps plein

Seeking a Mainframe Architect for a long-term contract in Canada.Responsibilities include designing and implementing application development and architecture solutions within the mainframe environm...Voir plus

 • Offre sponsorisée

Senior Mainframe Developer - Payments Systems

TDToronto, Canada
Temps plein

Ce poste vise à recruter un développeur mainframe expérimenté pour concevoir et développer des applications, tout en encadrant une équipe.Voir plus

 • Offre sponsorisée

Expert Senior Mainframe Network Programmer

Lorven Technologies Inc.Toronto, Canada
Temps plein

Become a Mainframe Engineer in Payment Systems and shape the Payments Workflow Platform.Lead technical design and collaborate with vendors to deliver high-quality solutions.In this role, you'll hav...Voir plus

 • Offre sponsorisée

Remote Mainframe Architect – Modernization & Migration Lead

Avanciers Inc.Toronto, Canada
Télétravail
Temps plein

A premier IT staffing and consulting organization in Canada is seeking a Mainframe Architect for a long-term contract role.The successful candidate will design and implement application development...Voir plus

 • Offre sponsorisée

Senior Mainframe Cics Consultant - C$150,000 - C$175,000 A Year

Tech Talent InternationalToronto, Canada
Permanent +1

Senior Mainframe CICS Consultant This is a Permanent or 12 month renewable contract for a Senior Mainframe CICS Consultant with a large consulting client, working on a long term project for one of ...Voir plus

 • Offre sponsorisée

Expert Database Specialist for Mainframe to Cloud Transition

Randstad DigitalToronto, Ontario, Canada
Temporaire

Elevate your career as a Database Specialist focusing on mainframe to cloud transitions in a hybrid work model.Utilize your extensive knowledge in managing legacy systems and modernization strategi...Voir plus

 • Offre sponsorisée

Senior Mainframe Architect – Transformation & Dr Lead

Rubicon PathToronto, Canada
Temps plein

A technology consulting company in Toronto is seeking an experienced Senior Technology Architect.The successful candidate will provide operational support for Mainframe systems, manage hardware ins...Voir plus

 • Offre sponsorisée

Mainframe Z/Os Systems Programmer

BMOToronto, Canada
Temps partiel

As a Mainframe z/OS Systems Programmer, you will be responsible for developing and implementing IT mainframe infrastructure and platform strategies.Your role will involve ensuring the reliability a...Voir plus

 • Offre sponsorisée

Senior Mainframe System Automation Consultant

Tech Talent InternationalToronto, Canada
Temps plein

Seeking a Mainframe System Automation Consultant to provide technical expertise for stable and reliable environments.Responsibilities include analyzing performance data, capacity planning, and coll...Voir plus