Skills

Python SQL PostgreSQL Monitoring Ansible Architecture Databases Azure AWS Shell cloud platforms GCP Snowflake Talend Spark PostGres

Job Specifications

Contract Opportunity: 2x L3 Database Administrators (Snowflake OR Greenplum/PostgreSQL)

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 experienced L3 Database Administrators to join their team on a contract basis. This role involves managing and optimizing Greenplum, PostgreSQL, and/or Snowflake databases in a hybrid working environment.

Open Positions:

Role 1: Snowflake DBA
Role 2: Greenplum/Postgres DBA (Snowflake knowledge is a plus)

Key Responsibilities

Administer and maintain PostgreSQL, Snowflake, and Greenplum 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 Postgres/Snowflake/Greenplum.
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 PostgreSQL, Snowflake, Greenplum.
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).

Interested? Apply now and be part of a dynamic team driving data excellence!

About the Company

We are an independent recruitment consultancy driven to provide an excellent service to our clients and candidates. We take pride in our service and delivery and have built strong, transparent relationships with all our customers. How we can help you: If you're looking to resource an entire project or to fill one strategic position, please get in touch on 020 3887 8700 / 0117 403 8888 or email your requirements to hello@macleanmoore.com - we pride ourselves on our speed of response and are looking forward to hearing from... Know more