Snowflake Architect/DBA

Candidate Should have experience of snowflake at least 7- 8 years


Primary Responsibilities:
·        Design and Architect database solution on Snowflake data cloud platform, AWS, Clienture and Databricks.
·        Manage and optimize the performance, security, and reliability of databases in the Snowflake Data Cloud platform.
·        Planning and managing disaster recovery strategies and data retention policies.
·        Deploying, right-sizing, and managing Snowflake virtual warehouses.
·        Implement and manage security measures like data encryption, access controls, and network policies.
·        Automate standard Database processes using Unix Shell scripting/Python.
·        Develop new automation scripts in python and write unit cases.
·        Enhance/troubleshoot existing Unix shell scripts.

Skills Required:
·        Expert in programming and has automation mind set.
·        Expert with Snowflake, AWS and Clienture Cloud platforms.
·        7+ years of experience as a Snowflake Architect/DBA.
·        Experience as an SAP IQ DBA.
·        Hands-on expertise with Snowflake utilities such as SnowSQL, SnowPipe, SnowPark, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
·        Snowflake SQL Writing SQL queries against Snowflake Developing scripts Java, Python, Scala, etc. to do Extract, Load, and Transform data
·        In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles
·        Experience with Database design and architecture patterns.
·        Experience in Data warehousing OLAP systems, Dimensions, Facts, and Data modeling.
·        Experience gathering and analyzing system requirements.
·        7+ years of hands-on experience designing and implementing production grade data warehousing solutions on large scale data technologies such as Snowflake, DB2, and SAP IQ.