Contract Opportunity: Snowflake Database Administrator
Location: Glasgow
Mode: Hybrid (3 days in office)
Contract Duration: 6 Months
Rate: £400 – £500 per day inside IR35
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.
Key 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 like Informatica, 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, Ansible.
* Implement monitoring solutions and ensure database security and compliance.
* Work with cloud platforms (AWS, Azure, GCP).
* Additional Conditions: On-call availability over weekends.
Your Profile
Essential Skills:
* 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.
Desirable Skills:
* ETL process implementation.
* Experience with Informatica, Talend.
* Cloud computing expertise (AWS, Azure, GCP).
Interested? Apply now and be part of a dynamic team driving data excellence!