Job Description

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. : Knowledge of Oracle, PostgeSQL [Unix and Redhat] is a requirement for this role The candidate will be a member of the Oracle practice within Data Management Services (DMS). The primary role for this position will be as an Oracle Database Administrator supporting Canadian and US requirements with current versions of Oracle Database. A minimum of 3 to 5 year of experience in Information Technology is required as well as experience in relational and non-relational database technologies such as PostgreSQL, Redshift, Microsoft SQL Server,and MongoDB to be able to support various teams within DMS. The DMS group has members in Canada, the US and India supporting a wide range of distributed and mainframe application who handle 7X24 rotational on-call duties, after hour change and disaster recovery support. This role requires Canadian Enhanced Reliability Security clearance [a minimum of 5 years of consecutive residency in Canada]. What will you do?

• Administrative support of Oracle 12c and 19c and PostgreSQL databases including many of it’s sub-components
• Maintain up-to-date documentation and procedures for all supported database related platforms
• Infrastructure support of Oracle including server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research and development (as needed by Infrastructure manager)
• Work with other Database Administrators or Developers in defining requirements
• Working on ways to automate and improve infrastructure as code release processes
• Support Oracle Advanced Security features such as TDE
• Performance analysis, monitoring, troubleshooting and resolution of issues
• Support project development following documented standards, policies and procedures (Change Management Process)
• Manage regular reviews of database vulnerability scan and remediation of open vulnerabilities
• Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
• Working closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services
• Define, document and implement consistent standards and procedures
• Contribute ideas for best practice improvements, process improvement, and innovative solutions

What you need to succeed:

• 5+ Years of Technical experience working with Oracle 12c and 19c hosted on Unix and Linux platforms.
• 3+ years of Technical experience working with PostgreSQL version 9+ up till latest version 12.3 hosted on Linux platforms University level degree in Computer Science or Information technology
• Strong PLSQL skills that including a strong understanding of system tables, stored procedures, functions, triggers, and SQL tuning
• Participation in database upgrade, cloning, platform migration, installations and patching
• Experience with Oracle database monitoring and tuning using native Oracle or other third-party tools
• Technical knowledge of AWS Cloud computing architecture/design/best practices
• Knowledge with Oracle Key Vault, Veritas clustering software and AIX and Linux operating systems
• Working experience with DevOps automation tooling such as Ansible, Terraform or Continuous Delivery Director
• Knowledge of Oracle Enterprise Manager or GRID Control, RMAN backup and recovery strategies, Oracle replication, mirroring, log shipping, maintenance plans and DR recovery strategies
• Excellent interpersonal and communication skills
• Willingness to provide on-call support and trouble shooting
• Strong organizational skills with the ability to handle several tasks efficiently
• Willingness to share ideas and contribute solutions, take initiative and speak up in groups
• Bilingualism (French, English) required- immediate manager is a unilingual Anglophone outside Quebec

What’s in it for you:

• Great Place to Work® Certified in Canada and the US - 2022
• Great Place to Work® award for Best Workplaces for #HybridWork
• 2022 Named “Best Places to Work” by Glassdoor - 2021
• Canada Award for Excellence for Mental Health at Work
• 2021 Flexible hybrid work model including in-country work-from-home if you prefer.
• Pension, stock and savings programs to help build and enhance your future financial security

#remote #Hybrid 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: 56,300/56 300 - 92,900/92 900 Job Category: IT - Technology Services Posting End Date: 30/08/2022