Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the management and optimisation of a secure Snowflake environment.
- Company: Join a leading organisation in IT Services and Consulting.
- Benefits: Enjoy a hybrid work model and competitive daily rates.
- Why this job: Be part of a dynamic team, enhancing data security and performance.
- Qualifications: Expertise in Snowflake, SQL, and cloud platforms like AWS required.
- Other info: This is a 6-month rolling contract with on-site presence in Norwich.
The predicted salary is between 40000 - 60000 £ per year.
Cyber Security Consultant at Hamilton Barnes Snowflake DBA – 6 months – Inside IR35 – Hybrid in Norwich
An experienced Snowflake Database Administrator is required to lead the management, optimisation, and governance of a secure, high-performing Snowflake environment for a leading organisation. This is a 6-month rolling contract, operating inside IR35, with on-site presence required several times per week in Norwich.
Key Responsibilities:
Administer and manage Snowflake environments: Oversee user accounts, roles, and permissions in Snowflake.
Implement and maintain data security and governance: Ensure secure access, data masking, and compliance with policies.
Optimize database performance and storage: Monitor and tune performance, manage virtual warehouses, and storage costs.
Manage database objects and workflows: Create and maintain schemas, tables, views, and procedures.
Support disaster recovery and data replication strategies: Implement back-up, restore, and cross-region replication plans.
What you will ideally bring:
Deep expertise in Snowflake setup, configuration, and best practices.
Proficiency in SQL & Snowflake SQL, including standard ANSI SQL and Snowflake-specific extensions.
Experience with Cloud Platforms, preferably AWS, including services like S3, IAM, EC2.
Hands-on experience with traditional databases such as SQL Server, Teradata, or Exadata.
Knowledge of security and governance practices, including role-based access control, data masking, and auditing in Snowflake.
Additional Details:
Duration: 6 months
Location: Hybrid in Norwich
Daily Rate: Up to £500 Per Day (Inside IR35)
Seniority level Mid-Senior level
Employment type Contract
Job function Administrative and Consulting
Industries IT Services and IT Consulting
#J-18808-Ljbffr
Snowflake DBA employer: Hamilton Barnes ?
Contact Detail:
Hamilton Barnes ? Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Snowflake DBA
✨Tip Number 1
Familiarise yourself with Snowflake's features and best practices. Understanding how to optimise performance and manage user roles will give you a significant edge during interviews.
✨Tip Number 2
Network with professionals in the field, especially those who work with Snowflake. Engaging in discussions on platforms like LinkedIn can help you gain insights and potentially get referrals.
✨Tip Number 3
Stay updated on the latest trends in cloud platforms, particularly AWS services that integrate with Snowflake. This knowledge can set you apart as a candidate who is proactive and informed.
✨Tip Number 4
Prepare for technical interviews by practising SQL queries and Snowflake-specific scenarios. Being able to demonstrate your problem-solving skills in real-time will impress potential employers.
We think you need these skills to ace Snowflake DBA
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Snowflake, SQL, and any relevant cloud platforms like AWS. Use specific examples to demonstrate your expertise in database administration and optimisation.
Craft a Strong Cover Letter: In your cover letter, explain why you are the perfect fit for the Snowflake DBA role. Mention your hands-on experience with Snowflake and traditional databases, and how you can contribute to the company's data security and governance efforts.
Showcase Relevant Skills: Clearly list your skills related to Snowflake setup, configuration, and performance tuning. Highlight your knowledge of security practices and any experience with disaster recovery strategies to align with the job requirements.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a DBA role.
How to prepare for a job interview at Hamilton Barnes ?
✨Showcase Your Snowflake Expertise
Make sure to highlight your deep knowledge of Snowflake setup and configuration during the interview. Be prepared to discuss specific projects where you've optimised Snowflake environments, as this will demonstrate your hands-on experience and understanding of best practices.
✨Demonstrate SQL Proficiency
Since proficiency in SQL and Snowflake SQL is crucial for this role, brush up on your SQL skills before the interview. Be ready to answer technical questions or even solve problems on the spot to showcase your command over both standard ANSI SQL and Snowflake-specific extensions.
✨Discuss Security and Governance Knowledge
Given the importance of data security and governance in this position, prepare to discuss your experience with role-based access control, data masking, and auditing in Snowflake. Providing examples of how you've implemented these practices in past roles will strengthen your candidacy.
✨Prepare for Cloud Platform Questions
As familiarity with cloud platforms, particularly AWS, is a key requirement, be ready to talk about your experience with services like S3, IAM, and EC2. Highlight any relevant projects where you integrated Snowflake with these services to illustrate your capability in managing cloud-based environments.