L3 Database Administrator; Postgresql​/Snowflake​/Greenplum

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).

• 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

• 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

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