Senior Snowflake DBA

Job title: Senior Snowflake DBA

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.

Job Description:

About the Role

The candidate will be a member of a team within Data Management Services (DMS) called Alternative Database Technologies. Alternative Database Technologies is responsible for database infrastructure architecture and operation support to teams using various cloud based and on-prem database platforms. The successful candidate will have a passion for database related technologies and is a proven fast learner. This is an opportunity for someone who is expert in data warehouse technologies, preferably in Snowflake, Redshift. A minimum of 7+ year of experience in Information Technology is required as well as experience in relational and non-relational database technologies such as Oracle, PostgreSQL, Redshift, MySQL, Graph DBs and Time series.

This role requires Canadian Enhanced Reliability Security clearance [a minimum of 5 years of consecutive residency in Canada].

What will you do?

• Setup, deploy and maintain snowflake cloud platform and administration, including but not limited to perform user & role management in Snowflake, backup/restore etc.
• Monitor the cost/credit consumption reports and take the effective measures for cost optimization
• Participate in projects throughout the entire project lifecycle, and define, manage, and track project deliverables using defined technologies
• Maintain up-to-date documentation and procedures for Snowflake and other supported database platforms
• Keep up to date on current and upcoming technology innovations for use within Sunlife
• Develop scripts to support the database operations on Linux, Unix or cloud-based platforms
• Support project development following documented standards, policies and procedures (Change Management Process)
• Evaluate functionality and features within related database products, suggest process improvements and innovative solutions
• Contribute and participate in continuous improvement and efficiency ideas in Snowflake administrations via DevOps

What need to succeed:

• University degree in Computer Science or related information technology degree/diploma
• 2+ years of hands-on experience in Snowflake administration/development
• 3+ years of experience in cloud native database technologies, i.e.: AWS Redshift, databricks, Oracle ADW and other
• 3+ years of experience working with multiple platforms and types of data repositories (Relational, NoSQL, Datawarehouse, OLAP, OLTP etc.)
• Proven Linux/Unix experiences, including expert shell scripting experiences
• Experience/familiarity with the operations and maintenance of production database systems
• Understanding and explaining of schema design (relational and data warehouse), index design, operation optimization and query plans
• Experienced in performance tuning, query optimization, client/server connectivity, and database consistency checks using different utilities
• Expertise in snapshot, import/export, database optimization and explanation plans
• Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of Database using different project development models like: SDLC, Agile, SCRUM etc.
• Problem solving, technical and conceptual skills with experience to lead technical discussions and self manage workloads
• Excellent interpersonal communication skills and strong organizational skills with the ability to multitask efficiently
• Ability to contribute solutions that meet or exceed business requirements

Preferred Skills:

• SnowPro Advanced certifications, i.e.: SnowPro Advanced Administrator etc.
• Developer background or experience working closely with development teams
• Data Modeler or schema design experience
• Experiences in any of the NoSQL (DynamoDB, Neptune or other), Redshift, MySQL, Oracle or SQL Server
• Understanding or experience working with Cloudwatch, Cloudtrail, AWS Config, AWS Backup and/or AWS DMS
• CloudFormation, Glue and/or Lambda scripting experience
• Understanding or experience with DevOps or Agile methodologies
• Experience with Security Architecture(s)

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

#LI-Hybrid #LI-remote

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 .

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: 15/11/2022

Company: Sun Life Financial

Expected salary: $58700 – 93900 per year

Location: Snowflake, MB

Job date: Fri, 11 Nov 2022 03:46:21 GMT

Job Source: Careerjet.ca

Click Here to Apply