B
Lead Snowflake DBA
Salary undisclosed
Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
Original
Simplified
Job Description
Job Description
Our client is looking for a Lead Snowflake DBA contract-to-hire.
*** US Citizens or Green Card Holders ONLY ***
We would bring on this person ASAP as a contractor and convert to an employee around July 2025 (exact date TBD). This is primarily an individual contributor role but may have 1 direct report at some point (e.g., another DBA).
Start: ASAP
Duration: 9 months CTH
Location: Hybrid NYC (Downtown) 2 days
Lead Snowflake DBA contract-to-hire
Summary
Responsible for managing and optimizing Snowflake data platforms, including performance tuning, security configurations, and data sharing
Handle tasks like user management, resource monitoring, capacity planning, and automating data pipelines
Ensure the platform runs efficiently, adheres to security policies, and is cost-optimized while also enabling seamless scaling of data operations across cloud environments
Responsibilities
Creation & Management of Snowflake Objects like Database/Schema /Tables/Views/MV's /Pipes, Streams, Task Creation & Management
Account level Objects like Warehouse, Resource Monitor, Network Policies, Integration (Storage, Notification), Shares Connectivity issues resolution wrt ODBC, JDBC, Python Connecters.
Snowflake UDF using SQL, Python, JavaScript and Java and help them to tune their SQL/UDF.
Create replication and failover groups and restore data from Fail safe or from time travel data
Troubleshoot data loading issues, connection issues and Snow pipe issues
User management, Implementation of RBAC best practices
Access Rights Management, experience with privileged roles Accountadmin, Sysadmin and Securityadmin
Analysing and Planning the Workload, Warehouses with Multi-clusters, Scaling policies and Application Specific warehouse creation and management for efficient Compute consumption
Generate, manage and analyze Cost/credits Consumption reports and identify cost optimization areas
ETL batch Support and issues resolution
Secure Data Sharing using managed accounts Creation, Reader Account provisioning and managing resource monitor, credit Quota, IP whitelisting
In depth knowledge of Micro partition, Caching, Table Clustering, Recommendation for Cluster key, Analysing the SQLs using query profile, identifying gaps, patterns and trends, recommendation to BI team based upon the analysis
Must Have
Snowflake Datawarehouse Administration
Snowflake Utilities SnowSql, SnowPipe
Time travel, Fail safe, Clustering, Cloning, Metadata management
Scripting - Java Script, Unix shell Scripting, Basic of Python
Cloud Platform - Aws Storage (S3), Azure Blob Storage and Containers
Snowflake Unique features use case and implementation (Time Travel, Un-drop, Zero Copy Clone) as per the requirement
Worked on thorough testing and implementation of Dev-ops Pipeline for Objects Promotion using GitHub, Jenkins
Working with Snowflake Support, handling P1 , P2 incidents, Engaging Support for technical issue on all the Snowflake Accounts under organization including Readers Account
Good To Have
Expertise in SQL, Snowflake procedures, UDF's using JavaScript
Automation- CI/CD using Jenkins Pipeline (Code promotion), Github for version control
Scheduling- ESP Jobs Scheduling, AWX Ansible Tower
Familiarity with JIRA, ServiceNow / GLPI
Experience with ITIL process, Change management, Incident handling, JIRA , Development using Agile methodology
Start: ASAP
Duration: 9 months CTH
Location: Hybrid NYC (Downtown) 2 days
Lead Snowflake DBA contract-to-hire
Summary
Responsible for managing and optimizing Snowflake data platforms, including performance tuning, security configurations, and data sharing
Handle tasks like user management, resource monitoring, capacity planning, and automating data pipelines
Ensure the platform runs efficiently, adheres to security policies, and is cost-optimized while also enabling seamless scaling of data operations across cloud environments
Responsibilities
Creation & Management of Snowflake Objects like Database/Schema /Tables/Views/MV's /Pipes, Streams, Task Creation & Management
Account level Objects like Warehouse, Resource Monitor, Network Policies, Integration (Storage, Notification), Shares Connectivity issues resolution wrt ODBC, JDBC, Python Connecters.
Snowflake UDF using SQL, Python, JavaScript and Java and help them to tune their SQL/UDF.
Create replication and failover groups and restore data from Fail safe or from time travel data
Troubleshoot data loading issues, connection issues and Snow pipe issues
User management, Implementation of RBAC best practices
Access Rights Management, experience with privileged roles Accountadmin, Sysadmin and Securityadmin
Analysing and Planning the Workload, Warehouses with Multi-clusters, Scaling policies and Application Specific warehouse creation and management for efficient Compute consumption
Generate, manage and analyze Cost/credits Consumption reports and identify cost optimization areas
ETL batch Support and issues resolution
Secure Data Sharing using managed accounts Creation, Reader Account provisioning and managing resource monitor, credit Quota, IP whitelisting
In depth knowledge of Micro partition, Caching, Table Clustering, Recommendation for Cluster key, Analysing the SQLs using query profile, identifying gaps, patterns and trends, recommendation to BI team based upon the analysis
Must Have
Snowflake Datawarehouse Administration
Snowflake Utilities SnowSql, SnowPipe
Time travel, Fail safe, Clustering, Cloning, Metadata management
Scripting - Java Script, Unix shell Scripting, Basic of Python
Cloud Platform - Aws Storage (S3), Azure Blob Storage and Containers
Snowflake Unique features use case and implementation (Time Travel, Un-drop, Zero Copy Clone) as per the requirement
Worked on thorough testing and implementation of Dev-ops Pipeline for Objects Promotion using GitHub, Jenkins
Working with Snowflake Support, handling P1 , P2 incidents, Engaging Support for technical issue on all the Snowflake Accounts under organization including Readers Account
Good To Have
Expertise in SQL, Snowflake procedures, UDF's using JavaScript
Automation- CI/CD using Jenkins Pipeline (Code promotion), Github for version control
Scheduling- ESP Jobs Scheduling, AWX Ansible Tower
Familiarity with JIRA, ServiceNow / GLPI
Experience with ITIL process, Change management, Incident handling, JIRA , Development using Agile methodology
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job Similar Jobs
