Snowflake DBA

Job Summary We are seeking an experienced Snowflake DBA / Developer with 4+ years of hands-on experience in designing, developing, administering, and optimizing Snowflake Data Cloud environments. The ideal candidate should possess strong expertise in Snowflake architecture, SQL development, performance tuning, security, and cloud-based data warehouse solutions. Experience with ETL/ELT pipelines and cloud platforms such as AWS, Azure, or GCP is highly desirable. Key Responsibilities Design, develop, and maintain Snowflake data warehouse solutions. Administer and manage Snowflake environments, including database creation, schema design, warehouses, roles, and users. Develop and optimize SQL queries, stored procedures, views, tasks, and streams. Monitor and optimize Snowflake performance, query execution, and warehouse utilization. Implement data security, encryption, masking policies, role-based access control (RBAC), and governance standards. Perform data migration from legacy databases to Snowflake. Design and implement ETL/ELT processes using Snowflake and integration tools. Configure and manage Snowpipe, Tasks, Streams, Time Travel, and Fail-safe features. Troubleshoot production issues, perform root cause analysis, and implement preventive measures. Collaborate with Data Engineers, BI Developers, Architects, and business stakeholders to deliver scalable data solutions. Implement backup, recovery, disaster recovery, and monitoring strategies. Ensure adherence to best practices for database administration, performance tuning, and cost optimization. Support CI/CD deployment processes for Snowflake objects. Maintain technical documentation and operational procedures. Required Technical Skills 4+ years of experience in Snowflake Development and Database Administration. Strong expertise in Snowflake architecture and administration. Advanced SQL programming skills. Hands-on experience with Snowflake features: Virtual Warehouses Snowpipe Streams & Tasks Time Travel Zero-Copy Cloning Data Sharing Secure Views Materialized Views Experience in performance tuning and query optimization. Knowledge of data modeling (Star Schema and Snowflake Schema). Hands-on experience with ETL/ELT tools such as Informatica, Matillion, Talend, Azure Data Factory, or dbt. Experience with cloud platforms (AWS, Azure, or Google Cloud Platform). Good understanding of Python or Shell scripting for automation. Experience with Git and CI/CD pipelines. Knowledge of monitoring and alerting tools. Strong understanding of database security, RBAC, and governance. Preferred Skills Experience with dbt for data transformation. Knowledge of Apache Airflow or similar workflow orchestration tools. Experience with Power BI, Tableau, or other reporting tools. Familiarity with Data Lake architectures. Understanding of DevOps and Infrastructure as Code (Terraform is an added advantage). Exposure to Agile/Scrum development methodologies. Qualifications Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline. Relevant Snowflake certifications such as SnowPro Core Certification are preferred. Cloud certifications (AWS, Azure, or GCP) are an added advantage. Soft Skills Strong analytical and problem-solving abilities. Excellent communication and stakeholder management skills. Ability to work independently as well as in a collaborative team environment. Strong documentation and organizational skills. Ability to manage multiple priorities in a fast-paced environment. Nice to Have Experience working with large-scale enterprise data warehouse implementations. Exposure to data governance and data quality frameworks. Knowledge of data integration with Kafka or REST APIs. Experience with automation and infrastructure provisioning. Exposure to financial services, healthcare, retail, or manufacturing domains is an advantage. .