Snowflake DBA

Queen Square Recruitment; Glasgow; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

A prominent recruitment agency is looking for a skilled Snowflake Database Administrator for a contract role in Glasgow. You will manage and optimize Snowflake databases, implement data models, and ensure high availability. The ideal candidate has extensive DBA experience, strong SQL skills, and proficiency in scripting languages such as Shell and Python. This hybrid role offers the opportunity to work with cutting-edge technologies and a dynamic team focused on data excellence.

Qualifications

• Extensive DBA experience with Snowflake.
• Strong SQL and complex query writing skills.
• Expertise in Shell, Python, and Ansible scripting.
• Knowledge of Patroni for HADR and streaming replication.
• Experience with ETL processes.
• Hands-on experience with Informatica and Talend.
• Familiarity with PostgreSQL and Greenplum.

Responsibilities

• Administer and maintain Snowflake databases.
• Implement Snowflake modeling and integrate with data processing technologies.
• Design and manage data lakes and structures for Snowflake architecture.
• Build data ingestion pipelines using Informatica and Talend.
• Manage data from multiple sources.
• Ensure high availability and disaster recovery.
• Perform backup, recovery, performance tuning, and optimization.
• Execute data migrations with minimal downtime.
• Utilize Greenplum utilities for data loading.
• Develop automation scripts.
• Implement monitoring solutions and ensure security.
• Work with cloud platforms (AWS, Azure, GCP).
• Provide on-call availability over weekends.

Skills

DBA experience with Snowflake

SQL skills

Shell scripting

Python scripting

Ansible scripting

Knowledge of Patroni

ETL processes

Experience with Informatica

Experience with Talend

PostgreSQL familiarity

Greenplum familiarity

Job description

Senior Delivery Partner – Queen Square Recruitment

Contract Opportunity: Snowflake Database Administrator

Location: Glasgow
Mode: Hybrid (3 days in office)
Contract Duration: 6 Months

About the Role

Our client is seeking an experienced Snowflake Database Administrator to join their team on a contract basis. This role involves managing and optimizing Snowflake databases in a hybrid working environment.

Responsibilities

• Administer and maintain Snowflake databases.
• Implement Snowflake modeling (roles, schemas, databases) and integrate with data processing technologies.
• Design and manage data lakes, structures, and models suited for Snowflake architecture.
• Build data ingestion pipelines using tools such as Informatica and Talend.
• Manage data from multiple sources (JSON, XML, CSV).
• Ensure high availability and disaster recovery using Patroni and streaming replication.
• Perform backup, recovery, performance tuning, and optimization for Snowflake.
• Execute data migrations with minimal downtime using tools like gpcopy.
• Utilize Greenplum utilities (gpload, pxf, GP spark) for efficient data loading.
• Develop automation scripts in Shell, Python, and Ansible.
• Implement monitoring solutions and ensure database security and compliance.
• Work with cloud platforms (AWS, Azure, GCP).
• Provide on‑call availability over weekends.

Your Profile

• Extensive DBA experience with Snowflake.
• Strong SQL and complex query writing skills.
• Expertise in Shell/Python/Ansible scripting.
• Knowledge of Patroni for HADR and streaming replication.
• Experience with ETL processes.
• Hands‑on experience with Informatica and Talend.
• Familiarity with PostgreSQL and Greenplum.

Additional Information

Seniority level: Associate
Employment type: Contract
Job function: Information Technology
Industry: IT Services and IT Consulting

Interested? Apply now and be part of a dynamic team driving data excellence!