Senior Snowflake Administrator

Responsibilities: Database Administration: o Deploy, configure, and administer Snowflake environments o Monitor and optimize Snowflake performance, storage, and query execution o Automate maintenance and administration tasks using SQL, Python, or Shell scripting o Integrate Snowflake with AWS S3, Glue, Lambda, Airflow, DBT and other cloud services o Manage external stages and storage integrations for seamless data movement o Monitor security logs and implement audit controls for data protection o Identify and resolve performance bottlenecks, query performance, and connectivity issues o Establish monitoring, alerts, and proactive issue resolution strategies o Create, manage, and maintain Snowflake databases, warehouses, and roles. o Implement and enforce data governance policies and procedures. o Monitor database performance and identify optimization opportunities. o Perform regular database backups and recoveries. o On-call rotation duties and weekend support activities where needed. o Participate in CICD deployments and other planned activities where needed. Security: o Implement and maintain robust security measures to protect sensitive data. o Manage user access controls and privileges. o Monitor for security threats and respond to incidents promptly Performance Optimization: o Analyze database performance and identify bottlenecks. o Tune database configurations to improve query performance. o Implement indexing strategies and data partitioning techniques. Data Loading and Migration: o Develop and execute data loading and migration strategies. o Ensure data integrity and accuracy during the migration process Troubleshooting: o Diagnose and resolve database-related issues and errors. o Provide technical support to data analysts and engineers Documentation: o Maintain comprehensive documentation of database architecture, procedures, and standards. Must Have: 6+ years of proven experience as a database administrator with Snowflake. 5+ years of Strong understanding of SQL and database concepts 5+ years of experience in deployments and on-call support activities 5+ years of experience in supporting and troubleshooting batch, streaming and real time data loads. 4+ years of experience in Snowflake applications (big data cloud database), writing efficient queries, as well as reading and understanding the query plans and writing stored procedures and functions 4+ years of experience in cloud native technologies including AWS Apply tot his job Apply To this Job