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

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