Sr. Snowflake Administrator

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 (PostgreSQL, 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 DevOps, or similar tools. + Use Terraform or other infrastructure-as-code tools to automate Snowflake and AWS resource provisioning. + Collaborate with DevOps 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 PostgreSQL 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 DevOps practices.* Certification in Snowflake, AWS, or PostgreSQL.**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 Acquisition Partner so that an appropriate accommodation can be arranged. This process applies throughout your career with Aviva Canada.We are seeking a highly skilled Senior Snowflake Administrator to manage and optimize our Snowflake cloud data platform. The ideal candidate will have deep expertise in Snowflake implementation, AWS data services (including RDS), PostgreSQL administration, and cloud migration. This role also emphasizes performance tuning, cost optimization, and DevOps practices using CI/CD pipelines and infrastructure-as-code tools.* 5+ years of experience as a Snowflake Administrator.* Proven experience in implementing and managing Snowflake solutions.* Strong knowledge of AWS cloud services and integration.* Proficiency in PostgreSQL database administration.* Experience with cloud computing platforms (e.g., AWS, Azure, GCP).* Experience with CI/CD tools (Bitbucket, Jenkins, Azure DevOps) and Terraform.* Excellent problem-solving skills and attention to detail.* Strong communication and collaboration skills.* Ability to work independently and as part of a team in a fast-paced environment.
#J-18808-Ljbffr