2 of 2 Performance Optimisation Jobs in Glasgow

call over weekends Role Overview We are seeking an experienced Database Administrator to manage PostgreSQL, Greenplum or Snowflake databases. The role includes administration, performance tuning, backup and recovery, automation, and supporting data ingestion and integration pipelines. Focus areas: Snowflake DBA – data lakes, architecture, roles, schemas, and databases. Greenplum/… Postgres DBA – database maintenance, migrations, and performance optimisation. Responsibilities Administer and maintain PostgreSQL, Greenplum, and Snowflake databases Design and manage Snowflake data structures, roles, schemas, and databases Build and manage data ingestion pipelines (Informatica, Talend) Manage data from multiple sources (JSON, XML, CSV) Implement Patroni for HADR and streaming ...

etc. * Expertise in Patroni for HADR and streaming replication. * Strong knowledge of Postgres/Greenplum database backup and recovery strategies. * Proven experience in performance tuning and optimization for Postgres/Snowflake and Greenplum. * Develop and maintain backup strategies to ensure data integrity and availability. * Manage day-to-day activities … upgrades in Postgres. * Perform data migrations using gpcopy and other tools, minimizing downtime and data loss. * Manage database bloat and leverage statistics for performance optimization. * Understand and utilize GPTEXT for troubleshooting complex issues. * Leverage Greenplum utilities like gpload, pxf, and GP Spark for efficient data loading and integration. * Ensure ...