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.