Snowflake/MS Azure Database Admin

Ecloud Labs - Dallas, TX

Full-time

Dallas, TX

Professional, Scientific, and Technical Services

About the position

The Snowflake/MS Azure Database Administrator is responsible for ensuring high availability of database systems both on-premise and in the cloud. This role involves leading database design, development, and support processes, while also maintaining and enhancing existing Snow Pipes, Tasks, and Stored Procedures to support critical customer processes. The administrator will leverage Snowflake's internal views for insightful alerts and drive continuous improvement initiatives to enhance operational efficiency. Collaboration with Internal IT Security is essential to implement and review key database controls.

Responsibilities

• Ensure high availability for database systems hosted on premise and on the cloud
• Lead database design, development & support processes
• Maintain existing Snow Pipes, Tasks, Stored Procedures and help with building new ones
• Leverage Snowflake internal views to implement insightful alerts
• Drive and support continuous improvement initiatives to enhance operational efficiency
• Collaborate with Internal IT Security to implement/review key database controls

Requirements

• Around 10 years of experience in Database Operations
• Minimum 5 years in Snowflake and MS SQL Server/Azure SQL/Azure Synapse
• Strong knowledge of Snowflake utilities such as Snow SQL, Snow Pipe, Snow Park, Python, Tasks, Streams, Time Travel, Network Rules, Network Policy, Data sharing, and Stored procedures
• Strong knowledge of data warehouse systems and MPP database architecture
• Hands on experience with SQL and DB performance tuning
• Skilled in scripting languages such as PowerShell, Python
• Ability to create automation for provisioning and administration tasks

Nice-to-haves

• Relevant database/cloud certifications preferred
• Knowledge of Azure Data Factory, Analysis Service and Microsoft Fabric