Sr. Snowflake Administrator​/Platform Engineer

Position: Sr. Snowflake Administrator / Platform Engineer
Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.
** What you'll do**
* ** Snowflake Administration:**  + Administer and manage the Snowflake cloud data platform, ensuring optimal performance, security, and reliability.  + Implement and configure Snowflake solutions, including data warehousing, data integration, and data migration.  + Optimize Snowflake performance through query tuning, resource management, and data modeling.  + Monitor and troubleshoot Snowflake environments to ensure high availability and performance.  + Implement cost optimization strategies, such as right-sizing virtual warehouses, reducing auto-suspend times, and consolidating workloads.  

+ Utilize Snowflake's cost insights to identify and act on opportunities for cost savings.
* ** AWS Integration:**  + Integrate Snowflake with AWS services such as S3, Glue, Lambda, EC2, and RDS.  + Design and implement scalable data pipelines using AWS Glue, Lambda, and Step Functions.  + Manage AWS RDS (Postgre

SQL, MySQL, etc.) including backups, performance tuning, and security.  + Ensure secure and efficient data movement between Snowflake and AWS data sources.
* ** CI/CD and Automation**:  + Implement and manage CI/CD pipelines using Bitbucket, Jenkins, Azure Dev Ops, or similar tools.  + Use Terraform or other infrastructure-as-code tools to automate Snowflake and AWS resource provisioning.  + Collaborate with Dev Ops teams to integrate database changes into deployment pipelines.
* ** Performance Tuning:**  + Optimize query performance by leveraging techniques such as clustering, query pruning, and result caching.  + Conduct regular performance assessments and implement improvements to enhance query execution times and overall system efficiency.  + Use Snowflake's Query Acceleration Service and other advanced features to improve performance for complex queries.
* ** On-Prem to Cloud Migration:**  + Lead and manage the migration of on-premise databases to cloud platforms, ensuring minimal downtime and data integrity.  + Develop migration strategies and plans, including data transfer, schema conversion, and application integration.  + Collaborate with stakeholders to ensure seamless transition and address any migration-related issues.
* ** Collaboration and Support:**  + Collaborate with data engineering, analytics, and IT teams to ensure effective communication and integration.  + Provide technical support and guidance to team members and stakeholders.  + Participate in on-call rotations to provide 24/7 support for critical issues.
* ** Documentation and Best Practices:**  + Maintain comprehensive documentation of Snowflake and Postgre

SQL configurations, processes, and procedures.  + Develop and enforce best practices for database management, security, and compliance.
** What you'll bring
***
* Preferred Qualifications:

*** Experience with other cloud platforms like AWS.
* Knowledge of Python, Terraform or other scripting languages for automation.
* Familiarity with CI/CD pipelines and Dev Ops practices.
* Certification in Snowflake, AWS, or Postgre

SQL.
** What you’ll get
*** Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.
* Outstanding Career Development opportunities.
* We’ll support your professional development education.
* Competitive vacation package with the option to purchase 5 extra days off per year.
* Employee driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion.
* Corporate wellness programs to support our employees’ physical and mental health.
* Hybrid flexible work model.

Please note that we may use AI tools to help us through the recruitment process. This is an existing position which has been posted both internally & externally.

Aviva Canada has an accommodation process in place to provide accommodations for employees with disabilities. If upon commencement of employment you require a specific accommodation because of a disability, please contact your Talent…