Snowflake DBA

Responsibilities :
 

- Must have experience working as a Snowflake Admin/Development in Data Warehouse, ETL, BI projects.
 

- Must have prior experience with end to end implementation of Snowflake cloud data warehouse and end to end data warehouse implementations on-premise preferably on Oracle/Sql server.
 

- Expertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
 

- Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning,
 

- Zero copy clone, time travel and understand how to use these features - Expertise in deploying Snowflake features such as data sharing.
 

- Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
 

- Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
 

- Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
 

- Experience with data security and data access controls and design-
 

- Experience with AWS or Azure data storage and management technologies such as S3 and Blob
 

- Build processes supporting data transformation, data structures, metadata, dependency and workload management-
 

- Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot.
 

- Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface.
 

- Must have experience of Agile development methodologies.
 

Good to have :
 

- CI/CD in Talend using Jenkins and Nexus.
 

- TAC configuration with LDAP, Job servers, Log servers, database.
 

- Job conductor, scheduler and monitoring.
 

- GIT repository, creating user & roles and provide access to them.
 

- Agile methodology and 24/7 Admin and Platform support.
 

- Estimation of effort based on the requirement.
 

- Strong written communication skills. Is effective and persuasive in both written and oral communication.