Database Administrator

Queen Square

Glasgow, United Kingdom

3 days ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Intermediate

Compensation

£ 130K

Job location

Glasgow, United Kingdom

Tech stack

Amazon Web Services (AWS)

Azure

Bash

Cloud Computing

Databases

ETL

Database Security

Disaster Recovery

Greenplum

JSON

Python

PostgreSQL

Performance Tuning

Ansible

SQL Databases

Data Streaming

Talend

Backup and Restore

XML

Data Processing

Scripting (Bash/Python/Go/Ruby)

Google Cloud Platform

Data Ingestion

System Availability

Snowflake

Data Lake

Job description

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., * 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.