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.

**What will you do?**
- Create new database objects or modify existing ones as requested by clients.
- Ensure databases are available as per service level agreements.
- Take appropriate steps to ensure database integrity and recoverability (onsite and offsite)
- Ensure database performance meet client demands (proactive and reactive monitoring)
- Pursue opportunities to reduce processing costs as appropriate.
- Take steps to ensure proper capacity planning and assist with security setup and audit requirements.
- Assist with data archiving, data masking and test data creation.
- Review database design and make recommendations regarding logical to physical model implementations.
- Provide support to developers with regards to database topics (SQL-queries, IMS DLI calls, tools usage etc.).
- Review new database or related tool features and make recommendations for exploitation.
- Assume an active role in improving current processes or finding innovative new solutions to known problems.
- Excellent communication skills and experience in assisting clients with various issues related to connectivity, permissions, access.
- Analytical and problem-solving skills with a keen attention to detail and the ability to consistently produce high-quality deliverables.
- Organizational and monitoring skills, handle several tasks efficiently and escalate to manager when issues arise.
- Work and lead projects with mínimal direction of multiple tasks and priorities simultaneously
- Know when to escalate issues and seek guidance when managing competing priorities and peak workload situations.
- 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
- 3-5 years knowledge of IMS and/or DB2 for Z/OS (administration, performance, security etc.)
- 3-5 years of Experience with RACF or ACF2
- 3-5 years of JCL skills
- 3-5 years of experience with peripheral tools and technologies (IBM HP IMS utilities, CA DB2 tools, File Aid, CA-7, ZEKE, REXX etc.)
- 3-5 years of Windows office (Outlook, Word, Excel, PowerPoint) experience
- Experience with Optim data masking and date archive tools
- Experience with mainframe programming languages
- Experience with MQ and/or DB2-connect.
- Bilingualism (French and English, written and spoken) - For the Montreal office. Asset for the Waterloo and Toronto offices

**What’s in it for you**:

- Competitive salary and bonus structure influenced by market range data.
- Pension, stock and savings programs to help build and enhance your future financial security.
- An environment of continuous learning and improvement
- Flexible hours and periodic work from home options

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**:
58,700/58 700 - 93,900/93 900

**Job Category**:
IT - Technology Services

**Posting End Date**:
22/02/2023