Database Administrator - Snowflake - 2830

Duration: Until 30 Sep 2026 (possibility of extension)

Location: Hybrid - Markham office a minimum of three days per week.

Top skills required:

1. Snowflake Admin

2. AWS Services (Glue, Lambda, SNS, Airflow, S3 etc)

3. Terraform

Position Title: Data Platform Administrator - Snowflake

Job 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:

o Administer and manage the Snowflake cloud data platform, ensuring optimal performance, security, and reliability.

o Implement and configure Snowflake solutions, including data warehousing, data integration, and data migration.

o Optimize Snowflake performance through query tuning, resource management, and data modeling.

o Monitor and troubleshoot Snowflake environments to ensure high availability and performance.

o Implement cost optimization strategies, such as right-sizing virtual warehouses, reducing auto-suspend times, and consolidating workloads.

o Utilize Snowflake's cost insights to identify and act on opportunities for cost savings.

• AWS Integration:

o Integrate Snowflake with AWS services such as S3, Glue, Lambda, and EC2 to enhance data workflows and analytics.

o Design and implement data pipelines using AWS services to facilitate seamless data movement and transformation.

o PostgreSQL Management:

o Manage PostgreSQL databases, including performance tuning, backups, and recovery.

o Ensure data integrity and security across PostgreSQL environments.

o Develop and implement automation scripts for database management tasks.

•Performance Tuning:

o Optimize query performance by leveraging techniques such as clustering, query pruning, and result caching.

o Conduct regular performance assessments and implement improvements to enhance query execution times and overall system efficiency.

o Use Snowflake's Query Acceleration Service and other advanced features to improve performance for complex queries.

• On-Prem to Cloud Migration:

o Lead and manage the migration of on-premise databases to cloud platforms, ensuring minimal downtime and data integrity.

o Develop migration strategies and plans, including data transfer, schema conversion, and application integration.

o Collaborate with stakeholders to ensure seamless transition and address any migration-related issues.

• Collaboration and Support:

o Collaborate with data engineering, analytics, and IT teams to ensure effective communication and integration.

o Provide technical support and guidance to team members and stakeholders.

o Participate in on-call rotations to provide 24/7 support for critical issues.

• Documentation and Best Practices:

o Maintain comprehensive documentation of Snowflake and PostgreSQL configurations, processes, and procedures.

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