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!
#J-18808-Ljbffr