Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Manage and optimise Snowflake databases while working in a hybrid environment.
- Company: Join a dynamic team in Glasgow with a focus on innovation.
- Benefits: Competitive daily rate, flexible work arrangements, and valuable experience.
- Why this job: Be at the forefront of data management and make a real impact.
- Qualifications: Extensive DBA experience with Snowflake and strong SQL skills required.
- Other info: Opportunity for professional growth and on-call availability over weekends.
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.
Snowflake DBA employer: Queen Square Recruitment
Contact Detail:
Queen Square Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Snowflake DBA
✨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 tangible look at what you can do.
✨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 make it easy for you to find and apply for roles that match your skills. Plus, it shows you're serious about joining our community.
We think you need these skills to ace Snowflake DBA
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Snowflake DBA role. Highlight your experience with Snowflake, SQL skills, and any relevant cloud computing expertise. We want to see how your background fits perfectly with what we're looking for!
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 contract opportunity. Share specific examples of your past work with Snowflake and how you’ve tackled challenges in database management.
Show Off Your Skills: Don’t hold back on showcasing your technical skills! Mention your experience with scripting in Shell, Python, and Ansible, as well as your knowledge of tools like Informatica and Talend. We love seeing candidates who can hit the ground running!
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates. Let’s get your journey started!
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. Be ready to discuss your experience with database administration, including how you've managed and optimised Snowflake databases in the past. Highlight specific projects where you've implemented Snowflake modelling or built data ingestion pipelines.
✨Show Off Your Scripting Skills
Since scripting in Shell, Python, and Ansible is essential for this role, prepare to showcase your skills. Bring examples of automation scripts you've developed and be ready to explain how they improved efficiency or solved problems in previous roles.
✨Demonstrate Your Problem-Solving Abilities
Be prepared to discuss scenarios where you've had to troubleshoot issues related to database performance or availability. Use the STAR method (Situation, Task, Action, Result) to structure your answers and show how you effectively managed challenges using tools like Patroni for high availability and disaster recovery.
✨Familiarise Yourself with Cloud Platforms
Since cloud computing expertise is a desirable skill, make sure you can talk about your experience with AWS, Azure, or GCP. Discuss any relevant projects where you integrated Snowflake with these platforms, and be ready to answer questions about cloud architecture and best practices.