Data Platform Administrator - Snowflake

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 fast-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.