Snowflake / Database Administration

Key Responsibilities:

• Administer and manage Snowflake data warehouse environments, ensuring high performance, availability, and security.
• Design, implement, and maintain Snowflake architecture and database models.
• Perform routine database maintenance tasks such as backups, restores, and patching.
• Optimize Snowflake queries and data storage for performance and cost efficiency.
• Monitor database performance, troubleshoot issues, and ensure uptime for critical business applications.
• Collaborate with data engineers, analysts, and other stakeholders to optimize ETL/ELT pipelines and data processes.
• Provide support for data migration, integration, and replication between Snowflake and other databases/systems.
• Implement security policies for Snowflake, including user roles, permissions, and access control mechanisms.
• Troubleshoot and resolve database-related issues, including query performance, data consistency, and system outages.
• Perform database upgrades and manage Snowflake lifecycle, ensuring that the environment is up-to-date with the latest features and patches.
• Assist with the development and deployment of automated data processes, including monitoring and alerting.
• Create and maintain technical documentation for Snowflake architecture, best practices, and operational procedures.
• Participate in database and infrastructure design reviews, providing expertise on Snowflake-related solutions.
• Perform regular database health checks and proactive maintenance to prevent potential issues.

Required Qualifications & Skills:

• 2-4 years of hands-on experience in

  Snowflake

  database administration or working with cloud-based data warehousing technologies.
• Strong knowledge of

  SQL

  and experience with writing optimized queries and stored procedures.
• Experience with

  Snowflake architecture

  ,

  clustering

  , and

  data partitioning

  strategies.
• Familiarity with Snowflake's

  data loading

  and

  ETL/ELT processes

  , including staging, transformation, and loading data.
• Experience with data

  integration

  between Snowflake and other platforms like

  AWS

  ,

  Azure

  , or

  Google Cloud

  .
• Solid understanding of

  database performance tuning

  techniques, including query optimization and indexing.
• Knowledge of

  data security

  , including user roles, data encryption, and compliance requirements (e.g., GDPR, HIPAA).
• Familiarity with Snowflake's

  native features

  like

  Time Travel

  ,

  Zero Copy Cloning

  , and

  Data Sharing

  .
• Experience with

  Cloud Infrastructure

  (AWS, Azure, or Google Cloud) and database monitoring tools.
• Knowledge of

  data replication

  and

  backup strategies

  in Snowflake.
• Experience with

  automation tools

  for database monitoring, alerting, and operational tasks.
• Strong troubleshooting and problem-solving skills, with the ability to work under pressure in production environments.