Snowflake DBA

TCS has been a great pioneer in feeding the fire of young techies like you. We are a global leader in the technology arena and theres nothing that can stop us from growing together.

What we are looking for

Role: Snowflake DBA

Experience Range: 8 to 12 Years

Location: Mumbai

Must Have:

As a Snowflake Administrator, you will manage and optimize the Snowflake data platform, ensuring its reliability, performance, and security, contributing to the organization's data-driven initiatives.

The Snowflake Administrator is responsible for the day-to-day administration, maintenance, and optimization of the Snowflake data warehouse environment, ensuring its stability, performance, and security. This role will involve managing user access, monitoring system performance, troubleshooting issues, and implementing best practices for data management and governance within Snowflake.

• Technical Skills:
• Strong understanding of relational databases and SQL.
• Experience with Snowflake architecture, features, and best practices.
• Familiarity with data warehousing concepts and ETL processes.
• Experience with scripting languages (e.g., Python, Shell) for automation.
• Experience with cloud technologies (e.g., AWS, Azure).
• Knowledge:
• In-depth technical knowledge of Snowflake architecture and operation.
• Solid understanding of Snowflake features: Cloning, Share, secure Views, caches, Warehouse sizes and scaling.

Good to Have:

• System Administration:
• Deploy, configure, and administer Snowflake environments.
• Manage user accounts, roles, and permissions within Snowflake.
• Monitor Snowflake performance, storage, and query execution.
• Troubleshoot and resolve Snowflake-related issues and errors.
• Implement and maintain Snowflake security controls, including data encryption and access controls.
• Ensure compliance with data protection regulations and organizational data governance policies.
• Performance Optimization:
• Identify and address performance bottlenecks within the Snowflake environment.
• Optimize SQL queries and Snowflake configurations for improved performance.
• Monitor and analyze Snowflake usage patterns to identify areas for improvement.
• Data Management:
• Manage Snowflake storage, including staging areas and file formats.
• Implement and maintain data loading and transformation processes within Snowflake.
• Ensure data quality and consistency within the Snowflake data warehouse.
• Monitoring and Maintenance:
• Monitor Snowflake system health and performance using Snowflake's monitoring tools.
• Perform routine maintenance tasks, such as backups and upgrades.
• Stay up-to-date with the latest Snowflake releases and updates.
• Essential:System Administration:
• Deploy, configure, and administer Snowflake environments.
• Manage user accounts, roles, and permissions within Snowflake.
• Monitor Snowflake performance, storage, and query execution.
• Troubleshoot and resolve Snowflake-related issues and errors.
• Implement and maintain Snowflake security controls, including data encryption and access controls.
• Ensure compliance with data protection regulations and organizational data governance policies.
• Performance Optimization:
• Identify and address performance bottlenecks within the Snowflake environment.
• Optimize SQL queries and Snowflake configurations for improved performance.
• Monitor and analyze Snowflake usage patterns to identify areas for improvement.
• Data Management:
• Manage Snowflake storage, including staging areas and file formats.
• Implement and maintain data loading and transformation processes within Snowflake.
• Ensure data quality and consistency within the Snowflake data warehouse.
• Monitoring and Maintenance:
• Monitor Snowflake system health and performance using Snowflake's monitoring tools.
• Perform routine maintenance tasks, such as backups and upgrades.
• Stay up-to-date with the latest Snowflake releases and updates.

Minimum Qualification:

• 15 years of full-time education
• Minimum percentile of 50% in 10th, 12th, UG & PG (if applicable)