Eswar

• Overall 6 + Year(s) of professional experience in IT industry as SQL Developer &Supporter and Snowflake Admin and Developer.
• Having 2.5 year(s) of Professional Experience in working with Snowflake cloud data warehouse as Admin.
• 1 + year(s) cloud (Postgresql & Snowflake) DBA experience.
• Having very good Experience in Aws & Azure Clouds and good Exposure in S3 & Blog storage
• Have good experience in Creating New User and Assigning the Role to Users and Creating the Resource Monitor Continuously Monitoring the warehouses.
• Administrative experience with PostgreSQL and Ability to create dynamic views from PostgreSQL & Snowflake.
• Experience with SnowFlake Datawarehouse, deep understanding of Snowflake architecture and processing Experience with performance tuning of SnowFlake data warehouse with Query Profiler, Caching and Virtual data warehouse scaling
• Created Clone concepts to maintain zero copies in Snowflake.
• Handling large and complex data sets like TSV, JSON, CSV files from various sources like AWS S3 and Hands on very good experience Bulk Loading and Unloading data from Snowflake.
• Used COPY/INSERT, PUT, and GET commands for loading data into Snowflake tables from internal/external stage and Experience in Dynamic SQL as well.
• Good exposure in Snowflake Cloud Architecture, SnowSQL, and SNOWPIPE for continuous data loading and creating the Reader Account and providing privileges as per Admin.

·        Experience in Creating Roles and assigning Role to Role and user to user in Snowflake.

·        Creating Roles with Access control privileges (DML/DDL/DCL) to access the database to work on.

·        Creating Multi-Cluster warehouses depending on Stakeholders requirement.

·        Adding Servers /Clusters to warehouses when needed to improve performance.

·        Creating Multi Factor Authentication for zero security compliance.

·        Creating users to access snowflake warehouses from both UI and SNOWSQL.

• Having good Knowledge on Job scheduling tools like Auto Sys and windows scheduling and Good knowledge on Service now ticketing tool.
• In-depth knowledge of Snowflake Database, Schema and Table structures.
• Good Knowledge in Core Python and Bit bucket.
•