Snowflake DBA
Queen Square, Blythswood New Town, Glasgow City
Snowflake DBA
Salary not available. View on company website.
Queen Square, Blythswood New Town, Glasgow City
- Full time
- Temporary
- Onsite working
Posted today, 27 Aug | Get your application in now to be one of the first to apply.
Closing date: Closing date not specified
Job ref: c32c5484a9be4e48a9d0c54e946dae9e
Location ref: Blythswood New Town, Glasgow City
Full 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!
- 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.