Snowflake Administrator
| Company | Aviva |
|---|---|
| Location | Markham, ON, Canada |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | |
| Experience Level | Senior |
Requirements
- 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.
Responsibilities
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Maintain comprehensive documentation of Snowflake and PostgreSQL configurations, processes, and procedures.
- Establish and maintain standard processes for database management, security, and compliance.
Preferred Qualifications
- 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.