IT & Software

L3 Database Administrator (Postgresql/Snowflake/Greenplum) - 12 Months - Glasgow - £400/Day

Hamilton Barnes

Glasgow · Scotland · United Kingdom

L3 Database Administrator (PostgreSQL/Snowflake/Greenplum) - 12 months - Glasgow - £400/day

We are seeking an experienced L3 Database Administrator to join a leading global banking and financial services organisation on a 12-month hybrid contract based in Glasgow (3 days on-site). The role covers database administration across PostgreSQL, Snowflake, and Greenplum, with two sub-focuses: a Snowflake DBA track, and a Greenplum/PostgreSQL DBA track (with Snowflake knowledge also valued).

Key Responsibilities:

  • Manage day-to-day database provisioning, maintenance, and upgrades in PostgreSQL
  • Perform data migrations using gpcopy, minimising downtime and data loss
  • Manage database bloat, leverage statistics for optimisation, and use GPTEXT for troubleshooting
  • Leverage Greenplum utilities such as gpload, pxf, and GP Spark for data loading and integration
  • Work with Snowflake internals, data lakes, and data models, including Snowflake modelling (roles, schemas, databases)
  • Build data ingestion pipelines using tools such as Informatica or Talend
  • Apply Patroni expertise for HADR and streaming replication
  • Develop and maintain backup/recovery strategies and implement monitoring solutions
  • Develop automation scripts in Shell, Python, or Ansible
  • Ensure database security, compliance, and best practices

What You Will Ideally Bring:

  • Extensive hands‑on DBA experience across PostgreSQL , Snowflake , and Greenplum
  • For Postgres: provisioning, maintenance, upgrades
  • For Greenplum: gpcopy migrations, performance optimisation, bloat management, GPTEXT, gpload/pxf/GP Spark
  • For Snowflake: data lake/model design, Snowflake modelling, strong SQL/complex query writing
  • Scripting in Shell, Python, or Ansible
  • Patroni expertise for HADR and streaming replication
  • ETL and data ingestion pipeline tools (Informatica, Talend) desirable
  • Cloud experience with AWS, Azure, or GCP desirable

Contract Details

  • Duration: 12 months
  • Day Rate: £400 per day
  • Determination: Inside IR35
  • Location: Hybrid, 1 day per week onsite, Glasgow
  • Start Date: ASAP
#J-18808-Ljbffr

Reference: WJ-766_22624187

Apply now

Continue on the employer's official application - the same link they use for every candidate.

More jobs

This role is listed on GigBlows for discovery and search. Hiring decisions and applications are handled by the employer or their chosen application system.