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. We are seeking a highly skilled Senior Snowflake Administrator to manage and optimize our Snowflake cloud data platform. The ideal candidate will have extensive experience in Snowflake implementation, AWS services, PostgreSQL administration, and on-prem to cloud migration. This role involves performance tuning, cost optimization, and collaboration with multi-functional teams to ensure seamless data operations. What you'll do Snowflake Administration: Administer and manage the Snowflake cloud data platform, ensuring efficient 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 solve issues in 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. Apply Snowflake's cost insights for identifying and acting on opportunities for cost savings. AWS Integration: Integrate Snowflake with AWS services such as S3, Glue, Lambda, and EC2 to improve data workflows and analytics. Design and implement data pipelines using AWS services to facilitate seamless data movement and transformation. PostgreSQL Management: Manage PostgreSQL databases, including performance tuning, backups, and recovery. Ensure data integrity and security across PostgreSQL environments. Develop and implement automation scripts for database management tasks. Performance Tuning: Optimize query performance by using techniques like 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. Partner with team members to achieve a smooth transition and resolve any migration-related issues. Collaboration and Support: Collaborate with data engineering, analytics, and IT teams to ensure effective communication and integration. Offer technical support and mentorship to team members and collaborators. 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. Establish and maintain standard processes for database management, security, and compliance. What you'll bring 5+ years of experience as a Snowflake Administrator. Demonstrable experience in implementing and managing Snowflake solutions. Solid understanding of AWS cloud services and integration. Proficiency in PostgreSQL database administration. Experience with cloud computing platforms (e.g., AWS, Azure, GCP). Excellent problem-solving skills and attention to detail. Clear communication and collaboration skills. Ability to work independently and as part of a team in a fast-paced environment. Experience with other cloud platforms like AWS will be nice to have. 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 a new 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 help our 19.5 million customers to save for the future and manage the risks of everyday life. To give these customers the best possible products and service we know we must make Aviva the most attractive choice for talented, entrepreneurial people with diverse backgrounds and an evolving range of expertise and insight. So, we’re passionate about helping our 23,000 people to do the best work of their lives, to enable them to make a positive difference to the lives of our customers.
