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