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.
- Other info: Exciting opportunity for career growth in a fast-paced industry.
- 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.
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
As a Senior Cybersecurity Engineer at Queen Square Recruitment, you will be part of a dynamic team within a leading financial services environment that prioritises innovation and security. The company fosters a collaborative work culture, offering extensive professional development opportunities and a commitment to employee growth, ensuring you can advance your career while making a meaningful impact on cybersecurity practices. Located in a vibrant area, the role provides unique advantages such as access to industry-leading resources and a network of experts dedicated to excellence in engineering and security.
StudySmarter Expert Advice🤫
We think this is how you could land Snowflake DBA in Glasgow
✨Tap into Local Tech Meetups
Get yourself to local tech meetups or database management conferences. It's a really great way to meet industry professionals and potentially uncover unadvertised full-time roles. When chatting with people, mention your skills and interests in database management; you never know who might be looking for someone just like you!
✨Contribute to Open Source Projects
Diving into open-source projects can not only sharpen your database skills but also get you noticed by employers. Many companies look for candidates who actively contribute to projects – it shows initiative and a real passion for the field. Plus, it's a perfect excuse to connect with other developers and expand your professional network.
✨Utilise Professional Bodies
Sign up for professional bodies related to database management, like the British Computer Society. They often host events and networking opportunities that can lead directly to job openings in the full-time market. Plus, it adds a nice touch to your professional profile!
✨Showcase Your Skills in a Public Portfolio
As you’re on the hunt for that full-time role, make sure to have a public portfolio that displays your best database projects. This can easily set you apart from the competition. And when you apply for roles, definitely mention it – it shows employers you mean business and are proud of your work!
We think you need these skills to ace Snowflake DBA in Glasgow
Some tips for your application 🫡
Show off your database skills:When applying for a full-time role in database management, it’s super important to highlight your skills with specific database technologies like SQL, NoSQL, or any relevant data visualisation tools. We want to see how you've used these tools in real projects, so don't shy away from detailing your hands-on experience!
Tailor your CV for data:Make sure your CV is structured clearly, focusing on your previous experience in database management. Use specific metrics to demonstrate your impact, like how you improved data retrieval times or reduced errors. This isn't just about what you've done; it’s about what you’ve achieved with your skills!
Craft a compelling cover letter:In your cover letter, share what excites you about database management and how you can contribute to Queen Square Recruitment. Mention any relevant projects where you tackled challenges or implemented new solutions. Let us know why you want to join our team and how your passion aligns with our goals.
Document your projects:If you've worked on interesting database projects—maybe during your studies or in previous roles—be sure to include those in your application. If you can, link to a portfolio or GitHub repo where we can see examples of your work. Having a tangible showcase of your skills will really make your application stand out!
How to prepare for a job interview at Queen Square Recruitment
✨Brush Up on Database Tools
Make sure you're well-versed with popular database management systems like MySQL, PostgreSQL, or MongoDB. Incorporating real-world examples of how you've used these tools in past projects will show that you can put theory into practice, which is something Queen Square Recruitment will definitely appreciate.
✨Know Your SQL Inside Out
Get ready for some technical questions focused on SQL queries and database design. We should anticipate coding challenges where you might need to optimise queries or design a database schema on the spot. Practising these problems will build our confidence to impress in the interview.
✨Demonstrate Problem-Solving Skills
Besides just technical know-how, be prepared to answer scenario-based questions that test your critical thinking and problem-solving abilities. Think about how you would approach data integrity issues or handle performance bottlenecks — Queen Square Recruitment will want to see your analytical side!
✨Show Your Collaboration Spirit
Since this is a full-time role, it's crucial to highlight how you've collaborated with cross-functional teams or contributed to team projects in the past. Emphasising our interpersonal skills will demonstrate that you’re not just a tech wizard, but also a team player who fits well with Queen Square Recruitment's culture.