Snowflake Cloud Administrator

at  Capgemini

JOB DESCRIPTION:

Capgemini Canada is hiring a Snowflake Cloud Administrator.

REQUIRED SKILLS:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Proven experience as a Snowflake Administrator or similar role, with hands-on expertise in managing Snowflake environments.
• Strong knowledge of Azure and AWS cloud services, including Azure Data Factory, AWS Glue, Azure/AWS Storage, and Azure/AWS Virtual Networks.
• Proficiency in SQL and experience with performance tuning and query optimization.
• Familiarity with data integration tools and ETL processes.

• Extensive hands-on experience in Snowflake design, implementation and management.
• Manage and maintain Snowflake environments by handling provisioning, configuration, and monitoring, implementing security best practices for data access, user roles, and encryption, and performing regular database maintenance tasks including backups, data purging, and archiving.
• Monitor and optimize Snowflake performance through query tuning, workload management, and storage optimization, identifying and resolving performance bottlenecks to ensure efficient resource utilization.
• Support data integration processes by handling ETL activities using Azure Data Factory, AWS Glue, and Snowflake’s capabilities, collaborating with data engineering teams to design and implement data pipelines and workflows.
• Manage and optimize Azure and AWS cloud resources supporting the Snowflake environment, including virtual networks, storage accounts, and compute resources, ensuring high availability, disaster recovery, and business continuity for Snowflake on both Azure and AWS.
• Ensure compliance with data governance, security policies, and regulatory requirements by implementing and managing data encryption, access controls, and auditing mechanisms.
• Provide technical support for Snowflake-related issues, including incident management and root cause analysis, collaborating with support teams to resolve issues and implement preventive measures.