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.

Snowflake / Database Administration