Snowflake DBA

Hamilton Barnes ?; Norwich; Hybrid; GBP 100,000 - 130,000; Full time

Job summary

A leading organisation is seeking an experienced Cyber Security Consultant to manage and optimize a secure Snowflake environment. This role involves overseeing user accounts, implementing data security, and optimizing database performance. The position is a 6-month contract requiring hybrid work in Norwich, offering a competitive daily rate.

Qualifications

• Deep expertise in Snowflake setup and configuration.
• Experience with Cloud Platforms, preferably AWS.

Responsibilities

• Administer and manage Snowflake environments.
• Implement and maintain data security and governance.
• Optimize database performance and storage.

Skills

SQL

Snowflake SQL

Data Security

Governance Practices

Tools

AWS

SQL Server

Teradata

Exadata

Job description

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:

1. Administer and manage Snowflake environments: Oversee user accounts, roles, and permissions in Snowflake.
2. Implement and maintain data security and governance: Ensure secure access, data masking, and compliance with policies.
3. Optimize database performance and storage: Monitor and tune performance, manage virtual warehouses, and storage costs.
4. Manage database objects and workflows: Create and maintain schemas, tables, views, and procedures.
5. 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