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). Experience with PostgreSQL & Greenplum. Interested? Apply now and be part of a dynamic team driving data excellence!