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.
