Job Title:  Consultant | Snowflake | Bengaluru | Engineering

Role Overview 

We are seeking a skilled Snowflake Application Database Administrator (DBA) to support our Data Engineers and AIML team. The ideal candidate will play a crucial role in managing and optimizing our Snowflake data environment, ensuring seamless data flow, and enabling advanced analytics and machine learning solutions. 

Key Responsibilities 

• Snowflake Administration: 
• Manage and maintain Snowflake databases, including performance tuning, resource optimization, and query optimization. 
• Oversee database access control, security, and compliance measures. 
• Collaboration with Data Engineers: 
• Partner with Data Engineers to design, implement, and optimize data pipelines and ETL/ELT processes. 
• Support data modeling efforts, ensuring efficient storage and retrieval of structured and unstructured data. 
• Performance Monitoring and Tuning: 
• Monitor Snowflake workloads and recommend enhancements for query and storage performance. 
• Troubleshoot and resolve database-related issues to minimize downtime. 
• Data Security and Governance: 
• Implement and enforce best practices for data security, privacy, and governance in alignment with organizational policies. 
• Assist with regulatory compliance and audits related to data management. 
• Documentation and Training: 
• Maintain detailed documentation for database configurations, standards, and procedures. 
• Train team members on Snowflake best practices and database usage. 

Required Qualifications: 

• Proven experience as a Snowflake DBA or Application DBA in a similar role. 
• Strong understanding of Snowflake architecture, including role hierarchy, warehouse design, and schema management. 
• Proficiency in SQL for handling database operations and privileges. 
• Familiarity with Snowflake user and role administration, including troubleshooting login and permission issues. 
• Ability to manually execute administrative tasks with precision, following best practices. 
• Knowledge of data governance and security principles, including access controls and auditing. 
• Experience collaborating with DevOps teams to support deployments and manage database-related configurations. 

Soft Skills: 

• Strong analytical and problem-solving abilities. 
• Excellent communication and collaboration skills. 
• Ability to work in a fast-paced, dynamic environment.