Sr Mainframe DBA

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

About the Role:

The candidate will be a member of the Data Sourcing and Mainframe Modernization within Digital Platform Modernization department. The primary goal of the team is to provide DB2 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.

Note:

• As a condition of the role, the successful candidate must obtain a Government of Canada Reliability Status security clearance through Sun Life in advance of the start date and the role will also require Star Compliance. ​
• Must be able to satisfactorily complete applicable background checks prior to the start date and during employment, in accordance with Sun Life's policies and practices.

What you will do:

• Provide operational support for Db2 and IMS database environments.
• Ensure databases are available as per service level agreements, meet database integrity and recoverability.
• Ensure database performance meet client demands (pro-active and reactive monitoring).
• Recommend ways to improve processes, exploit new mainframe features/related tools and reduce cost.
• Take steps to ensure proper capacity planning, assist with security setup and audit requirements.
• Assist with data archiving and batch scheduling.
• Develop automation scripts to reduce manual effort.
• Support application DBAs with regards to database operation topics.
• 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 on projects with minimal direction of multiple tasks and priorities simultaneously.
• 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.

What you need to succeed:

• Degree in Computer Science or Technology degree/diploma
• 1 - 3+ years knowledge of IMS and/or Db2 for Z/OS (administration, performance, security, operations, etc.)
• 1 -3+ years of Experience with RACF or ACF2
• 1 -3 + years of JCL and ISPF development skill
• 1 -3+ years of experience with peripheral tools and technologies (IBM HP IMS utilities, CA DB2 tools, File Master Plus, CA-7, ZEKE, REXX , CLIST, Python, Zowe, Ansible, etc.)

What's in it for you:

• We're honoured to be recognized as a 2024 Best Workplaces in Ontario by Great Place to Work® Canada.
• We are thrilled to be recognized by Excellence Canada with their top-level certification, the Canada Order of Excellence for Mental Health at Work®, for prioritizing employee well-being, fostering a positive work culture, and achieving excellence in mental health.
• We're proud to be recognized as a company with a 2023 Most Trusted Executive team by Great Place to Work® Canada.
• Wellness programs that support the three pillars of your health - mental, physical, and financial
• The opportunity to move along a variety of career paths with amazing networking potential.
• As a hybrid organization, you and your leader use business and Client needs to choose where you work, at home or in the office

#LI - SJ

The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.

Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.

Persons with disabilities who need accommodation in the application process or those needing job postings in an alternative format may e-mail a request to thebrightside@sunlife.com.

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:

Job Category:

Posting End Date: