Source description
About the role
Role: Snowflake DBA Location- 100% Remote Duration: 6-12 Months Status- Must be GC or US Citizen and on our W2.Must haves- Must have Snowflake Certification (Might be open to letting someone get it after they get the job) Must have administered an existing Snowflake environment. Must have experience with AWS and Snowflake environment. Responsibilities: Manage snowflake utilities such as SnowSQL, SnowPipe, Big Data model techniques using Python Setting up resource monitors, deploying RBAC controls, virtual warehouse sizing and query performance tuning Deploy snowflake features such as data sharing Configure Storage integration to access AWS S3 and create stage objects Work with version control tools (Github) Configure AWS PrivateLink to access Snowflake account Applies SME knowledge to solve common & complex data issues within established guidelines & recommends appropriate actions Supports Cloud migration teams projects with AWS Cloud expertise Supports operation of the programs Cloud AWS environment Provide user access/security/release/schedules management Work with federal and contractor staff to identify cloud migration requirements Follow established client standards for implementing cloud configurations Collaborate and coordinates with the other contract Gov task leads as directed Requirements: Bachelor’s degree with 8 years of relevant experience or Masters’ and 6 years, or PhD and 3 years. An additional 4 years of experience may be substituted in lieu of a degree. Must have an active Snowflake certification Experience with ETL concepts & DWH Experience using Snowflake SQL and implementing stored procedures Understanding of Snowflake TimeTravel concepts and zero copy cloning, network policies, clustering, and tasks Experience with advanced concepts setting up RBAC Controls, Resource Monitors, Virtual Warehouse sizing, and Query performance tuning Experience with Python connector & Spark connector for Snowflake, as well as Apache Experience with AWS S3 data storage, privatelink, VPC, EC2 Experience administering/sizing clusters such as Redshift/Snowflake/Databricks/Hadoop Experience with version control tools (ideally GitHub) Experience in CI/CD pipelines, agile methodologies and DevOps styled deployments Must have a background managing Agile teams / projects (Scrum preferred) Excellent organizational, communication (written & verbal), and time management skills Preferred experience: Holds and active Public Trust clearance Experience in consulting to CMS (Centers of Medicare & Medicaid), or Federal Health, or Enterprise Health companies Experience migrating enterprise level data warehouses from Teradata to Snowflake / AWS Cloud, as well as On-Premises to Cloud Thanks & Regards Syam B, 630-923-6952 syam@thoughtwavesoft.com
More at Thoughtwave Software and Solutions