Position: Data Platform Administrator - Snowflake

> Location : Markham (Need to visit 3 days a week in office mandatorily)
>
> Summary: 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 cross-functional teams to ensure seamless data operations. Key Responsibilities:
>
> - 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, and EC2 to enhance 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 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.
>
> Requirements:
>
> - 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).
> - 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 quick-paced environment.
>
> 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.

📌 Data Platform Administrator - Snowflake (Toronto)
🏢 Recutify
📍 Toronto