Description

You will design and architect database solutions across Snowflake, AWS, Cloudera, and Databricks platforms.

Responsibilities

• Design database architectures and manage performance, security, and reliability within the Snowflake Data Cloud.
• Deploy, right-size, and manage Snowflake virtual warehouses and disaster recovery strategies.
• Implement security measures including data encryption, access controls, and network policies.
• Automate database processes and develop new automation scripts using Python and Unix Shell scripting.
• Troubleshoot existing shell scripts and write unit cases for new automation.

Required Skills

• 7+ years of experience as a Snowflake Architect or DBA.
• Expertise in Snowflake, AWS, and Cloudera Cloud platforms.
• Hands-on experience with SnowSQL, SnowPipe, SnowPark, Tasks, Streams, Time Travel, and Metadata Manager.
• Proficiency in writing SQL queries and developing ETL scripts using Java, Python, or Scala.
• Experience with Snowflake data sharing, stored procedures, and the Optimizer.
• Strong background in database design, architecture patterns, and data modeling (Dimensions, Facts, OLAP).
• Experience with SAP IQ and DB2 in large-scale production data warehousing environments.
• In-depth understanding of Data Warehouse/ODS and ETL concepts.
• Ability to gather and analyze system requirements.

Preferred Skills

• Expertise in programming with a focus on automation.

Key Skills

Education

Any Graduate