Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Manage and optimise Snowflake databases while collaborating in a hybrid work environment.
- Company: Join a dynamic IT services company focused on data excellence.
- Benefits: Competitive contract pay, flexible working, and opportunities for skill development.
- Why this job: Be at the forefront of data technology and make a real impact.
- Qualifications: Extensive DBA experience with Snowflake and strong SQL skills required.
- Other info: Exciting opportunity for career growth in a fast-paced industry.
The predicted salary is between 45000 - 75000 £ per year.
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!
Snowflake DBA in Glasgow employer: Queen Square Recruitment
Contact Detail:
Queen Square Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Snowflake DBA in Glasgow
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with Snowflake or in similar roles. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio or GitHub repository showcasing your Snowflake projects and any automation scripts you've developed. This gives potential employers a taste of what you can do beyond just a CV.
✨Tip Number 3
Prepare for interviews by brushing up on common DBA scenarios and Snowflake-specific challenges. Practise explaining your thought process and solutions clearly, as this will demonstrate your expertise and problem-solving skills.
✨Tip Number 4
Don't forget to apply through our website! We have a range of opportunities that might be perfect for you. Plus, applying directly shows your enthusiasm and commitment to joining our team.
We think you need these skills to ace Snowflake DBA in Glasgow
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Snowflake and relevant technologies. We want to see how your skills match the job description, so don’t be shy about showcasing your DBA expertise!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this role. We love seeing enthusiasm and a clear understanding of what we do at StudySmarter.
Showcase Your Technical Skills: Don’t forget to mention your SQL prowess and scripting skills in Shell, Python, and Ansible. We’re looking for someone who can hit the ground running, so make those skills pop in your application!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates from our team!
How to prepare for a job interview at Queen Square Recruitment
✨Know Your Snowflake Inside Out
Make sure you brush up on your Snowflake knowledge before the interview. Understand its architecture, features, and best practices. Be ready to discuss how you've managed and optimised Snowflake databases in previous roles.
✨Show Off Your Scripting Skills
Since scripting in Shell, Python, and Ansible is crucial for this role, prepare examples of automation scripts you've developed. Be ready to explain the challenges you faced and how you overcame them using these tools.
✨Demonstrate Your Data Handling Expertise
Be prepared to talk about your experience with data ingestion pipelines and ETL processes. Highlight specific projects where you’ve worked with tools like Informatica and Talend, and how you managed data from various sources.
✨Discuss High Availability Strategies
Since ensuring high availability and disaster recovery is key, come equipped with examples of how you've implemented solutions like Patroni and streaming replication. Discuss any challenges you faced and how you ensured minimal downtime during migrations.