Database Administrator

Job description

Database Administrator

Location: Glasgow - Hybrid (3 days in office)

Day Rate: £510 (Inside IR35)

Contract Duration: 6 Months

Additional Conditions: On-call over weekends

Role Overview

We are seeking an experienced Database Administrator to manage PostgreSQL, Greenplum or Snowflake databases. The role includes administration, performance tuning, backup and recovery, automation, and supporting data ingestion and integration pipelines.

Focus areas:

• Snowflake DBA – data lakes, architecture, roles, schemas, and databases.
• Greenplum/Postgres DBA – database maintenance, migrations, and performance optimisation.

Responsibilities

• Administer and maintain PostgreSQL, Greenplum, and Snowflake databases
• Design and manage Snowflake data structures, roles, schemas, and databases
• Build and manage data ingestion pipelines (Informatica, Talend)
• Manage data from multiple sources (JSON, XML, CSV)
• Implement Patroni for HADR and streaming replication
• Perform database provisioning, maintenance, upgrades, and migrations (gpcopy)
• Optimise performance using statistics and Greenplum utilities (gpload, PXF, GP spark)
• Manage database bloat and troubleshoot issues using GPTEXT
• Develop scripts in Shell, Python, or Ansible to automate routine tasks
• Ensure database security, compliance, and best practices
• Implement monitoring solutions to proactively detect and resolve issues
• Support cloud deployments (AWS, Azure, GCP)

Essential Skills

• Extensive experience with PostgreSQL, Greenplum, and Snowflake administration
• Postgres: provisioning, maintenance, upgrades, and migrations
• Greenplum: migrations, performance tuning, bloat management, GPTEXT, utilities (gpload, PXF, GP spark)
• Snowflake: architecture, data lakes, roles, schemas, SQL, complex queries
• Expertise in Patroni for HADR and streaming replication
• Scripting skills in Shell, Python, or Ansible
• Experience with backup, recovery, and database security

Desirable Skills

• ETL processes and implementation
• Data ingestion pipelines (Informatica, Talend)
• Cloud experience with AWS, Azure, or GCP

Extra information

Status

Open

Education Level

Secondary School

Location

Glasgow

Type of Contract

Casual / Part Time Jobs

Published at

18-12-2025

Profession type

Accountancy

Full UK/EU driving license preferred

No

Car Preferred

No

Must be eligible to work in the EU

No

Cover Letter Required

No

Languages

English