L3 Database Administrator - Glasgow - 6 Month Initial Contract - Inside IR35

L3 Database Administrator - Glasgow - 6 Month Initial Contract - Inside IR35

We are seeking an experienced L3 Database Administrator to join a leading UK 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). The successful candidate will manage day-to-day database operations, performance tuning, data migrations, and automation across these platforms.

Key Responsibilities:

• Manage day-to-day database provisioning, maintenance, and upgrades in PostgreSQL
• Perform data migrations using gpcopy and other tools, minimising downtime and data loss
• Manage database bloat, leverage statistics for performance optimisation, and use GPTEXT for troubleshooting complex issues
• Leverage Greenplum utilities such as gpload, pxf, and GP Spark for efficient data loading and integration
• Work with Snowflake internals, data lakes, data structures, 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 and recovery strategies to ensure data integrity and availability
• Implement monitoring solutions to proactively identify and resolve issues
• Develop automation scripts in Shell, Python, or Ansible to improve operational efficiency
• Ensure database security, compliance, and adherence to best practices

What You Will Ideally Bring:

• Extensive hands-on database administration experience across PostgreSQL, Snowflake, and Greenplum
• For Postgres: database provisioning, maintenance, and upgrade experience
• For Greenplum: data migration via gpcopy, performance optimisation using statistics, bloat management, GPTEXT troubleshooting, and experience with gpload/pxf/GP Spark
• For Snowflake: data lake/model design, Snowflake modelling (roles, schemas, databases), and strong SQL/complex query writing
• Scripting expertise in Shell, Python, or Ansible
• Expertise in Patroni for HADR and streaming replication
• Knowledge of ETL processes and data ingestion pipeline tools (Informatica, Talend) desirable
• Cloud computing experience with AWS, Microsoft Azure, or Google Cloud desirable

Contract Details:

• Rate: £400 per day Inside IR35
• Location: Glasgow(Hybrid)
• Duration: 6 months