Job Post : Sr. Snowflake Administrator

Location : Boston, MA – Hybrid (NEED LOCAL WITH DL OR ANY PROOF)

Visa: GC-EAD, GC and USC.

MUST have HVR Five Tran experience (not Five Tran SAS)

The major technical skills would include :

•Snowflake Administration/Configuration, HVR/FIVETRAN Replication or just knowledge of replication tasks overall knowledge of DMS, AWS, CDC Concepts, SQL Skills, DRBC and High Availability concepts background and ability to performance tune and monitor areas they are accountable for in a modern automated fashion.

Must Haves:

•             Administrative knowledge of Snowflake, not just etl

•             Manage security and architecture of snowflake

•             HVR | Fivetran– not fivetran sas – they use import processor/operator with hub installation

•             Use connectors and hub-and-spoke architecture within HVR

•             Identify performance issues and monitoring

•             Performance Monitoring on HVR – locations, channels, CDC for certain channels

•             Monitoring tools – Grafana and Prometheus

•             Database management platforms – Not copy command

•             Rds. On prem and moving to the cloud, so need exposure to AWS technology

•             Must know transactional sql – snow sql is key!

•             Python

Plus:

•Exp working with PI data

Day to Day:

• Initially this person will be responsible for HVR, Fivetran, and Snowflake.
• This will be the most senior resource on the team and will be involved in training and developing the skillset of the existing team.
• This resource will need to learn the DBMS technologies – DB2, Oracle, SQL Server, PostgreSQL, etc. – since, when paired with Snowflake, HVR serves as a CDC ingestion layer that captures data from the source and replicates them efficiently into Snowflake.
• They will manage the security and architecture of Snowflake, identify performance issues and monitoring.