Mediabistro logo
job logo

Snowflake Admin

Diverse Lynx, San Jose, CA, United States


ONSITE ROLE - San Jose CA or RTP NC

Snowflake Admin

1. Working on day-to-day Snowflake Admin activities like, Storage Integration (AWS & GCP buckets), Integration setup (Notification, API & Email) 2. Setup of Inbound & Outbound Data shares as per the project requirements.
3. IP Allow listing as per the Project requirements, after review/approval of Platform Manager.
4. New Application Onboarding guidance and provide in-depth knowledge around the costing & billing aspects as per the standards.
5. Analyzing the Snowflake Warehouse Usage and provide best recommendations as per the trend and cost optimization.
6. Providing guidance around the usage of Cloud Toolkit API's and reading the secrets and manage the passwords in the Keeper Vault Services.
7. Configure and optimize Snowflake accounts, virtual warehouses, databases, schemas, and user roles.
8. Monitor platform performance and ensure optimal configuration and scaling of compute resources.
9. Implement and manage data security measures including role-based access control, data encryption, and user authentication.
10. Monitor query performance and optimize SQL queries for better efficiency, Analyze and resolve performance bottlenecks and resource contention issues, Utilize Snowflake's advanced features such as clustering keys, materialized views, and result caching to enhance performance.
11. Implement backup and recovery strategies to ensure data durability and availability, Manage data archiving, replication, and failover processes.
12. Develop and maintain scripts for automating administrative tasks and workflows, Utilize tools and frameworks for continuous integration and deployment (CI/CD).
13. Provide technical support and troubleshooting for Snowflake-related issues, collaborate with Snowflake support to resolve platform-specific issues

. Knowledge in any RDBMS database like Teradata or Oracle 2. Knowledge of programming languages such as Python or JavaScript.
3. Experience with data visualization tools (e.g., Tableau, Power BI).
4 . 24*7 support model experience

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.