Snowflake DBA Architect.
Hiring manager (located in Atlanta, GA but team is spread across Chicago and NJ) - Can be fully remote (first preference to local to Atlanta, GA then to other MS Offices)
Interview Process – mostly 2 rounds
1St round – discussing prior expertise and
2nd round – technical round with coding.
3rd round – May happen depending on 2nd rounds panel availability of the decision maker.
Open for remote
- Experience: 7+ years as a Snowflake DBA Architect.
- Role Focus: Primarily architectural (80%) with some administration (20%). Not purely a development role.
- Domain Flexibility: Open to candidates from any domain.
- Platform Expertise: Strong experience with the Snowflake Data Cloud platform on AWS or Azure.
- Additional Skills: Experience as an SAP IQ DBA is a valuable bonus, though not required.
- Core Responsibilities: Building and maintaining the Snowflake Data Cloud platform.
- Development Understanding: Must be capable of guiding code development using Snowflake utilities such as SnowSQL, SnowPipe, SnowPark, Python, Tasks, Streams, Time Travel, Optimizer, Metadata Manager, Data Sharing, and Stored Procedures.
- Automation Skills: Proficiency in Python for writing automation scripts.
Can be fully remote. Preference to have candidate local to Alpharetta, Chicago, New York, New Jersey, or California MS offices.
Description:
Database Platforms Services - Analytics team is looking for a proactive, enthusiastic, and knowledgeable individual who is a self-starter and is passionate about Engineering Database solutions.
This position will be focused on building automation pipelines around database platforms (on-prem and cloud) which will require programming skills (Shell scripting/Python) and Database knowledge.
Primary Responsibilities:
- Design and Architect database solution on Snowflake data cloud platform, AWS, Azure 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 Azure 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.