Job Title: Database Administrator
Location: Charlotte, NC (Onsite)
Job type: W2
Experience: 6-8 Years
=
*** HIGHLIGHTED SKILLS ***
Primary: Snowflake, SQL, SnowSQL, Cortex Search, Cortex Analyst, Snowflake Cortex AI, Python, Snowpark
Secondary: PL/SQL, Unix Shell Scripting, Cloud Computing, DataOps, DevOps
**************************
--- JOB DESCRIPTION ---
• Experience: 7+ years in Snowflake platform administration or data engineering, with 1+ years specifically on Generative AI solutions.\n
• Snowflake Expertise: Deep knowledge of SQL, SnowSQL, Cortex Search, Cortex Analyst, and Snowflake Cortex AI functions (summarize, extract, translate).\n
• Languages: Strong Python (Snowpark) and SQL proficiency.\n
• Data Governance: Experience implementing security policies (row-level security, masking) within the Snowflake environment.\n
• AI Knowledge: Understanding of Large Language Models (LLMs) and Prompt Engineering.\nRoles & Responsibilities\n
• Cortex AI Implementation: Architect and implement RAG (Retrieval-Augmented Generation) pipelines using Cortex Search and Cortex Analyst to translate natural language into SQL.\n
• Semantic Model Development: Develop and maintain semantic models (YAML files) that map business language to database schemas for accurate, conversational analytics.\n
• Cortex Performance & Cost Tuning: Optimize Cortex query performance and manage credit consumption for LLM functions and Cortex Search.\n• Platform Administration: Manage Snowflake core platform components: virtual warehouses, RBAC (Role-Based Access Control), Snowpipe, Streams & Tasks, and Data Sharing.\n
• Governance & Security: Ensure data security and governance compliance when deploying Cortex solutions, ensuring customer data does not leave the secure boundary.\n
• API & Application Integration: Integrate Cortex APIs into enterprise tools (Streamlit, Power BI, Slack, Teams) to build interactive AI applications.\n
• System Monitoring: Monitor platform health and performant inference to ensure reliability and minimize costs.\n\nGeneric Managerial Skills, If any\n Communication: Ability to work across teams and with stakeholders\nKey Words to search in Resume\nSnowflake platform management, Snowflake, Cortex, DataOps/DevOps\n\nSkills: Digital : SnowflakePL/SQLUnix Shell Scripting and text processing tools~Digital : Cloud Computing (General)\n
Experience Required: 6-8