Snowflake Administrator

Hello,

Greetings from Clifyx.

**********************************Visa ()********************************

Title: Snowflake Administrator
Address: Lake Mary, FL (Hybrid-Onsite)
12+Month Contract

Job details
Must Have Skills:
1. Minimum 7+ years of experience
2. Provide L1 and L2 support for Snowflake and associated services, including Oracle database support and Goldengate Replication.
3. Proficiency in SQL language and cloud-based technologies.
4. Advanced knowledge of Snowflake modeling, including roles, databases, and schemas
5. Expertise in performance tuning and creating resource monitors
6. Skilled in evaluating SQL performance, tuning SQL queries, and optimizing databases
7. Comprehensive understanding of Snowflake warehousing, architecture, processing, and administration
8. Strong background in Oracle Database Administration, including performance tuning
9. Expertise in Oracle Goldengate Replication

Key Responsibilities:
• Provide L1 and L2 support for Snowflake and associated services, including Oracle database support and Goldengate Replication.
• Monitor Snowflake production environment and resolve incidents (L2/L3)
• Troubleshoot task, query, Snowpipe, and ingestion failures
• Manage users, roles, warehouses, and access privileges
• Analyze query performance and warehouse credit usage
• Perform root cause analysis (RCA) and preventive actions
• Support production deployments, RFCs, and CTASKs
• Coordinate with application and ETL teams
• Prepare incident reports and documentation