2 of 2 Contract Data Lake Jobs in Lanarkshire

GP/PSG DBA (good to know Snowflake) Key Responsibilities: * Candidate will have extensive working knowledge on PostgreSQL, Snowflake and Greenplum databases. * Snowflake internals and integration with other data processing technologies. * Data lakes, data structures and data models suited to Snowflake architecture. * Snowflake modelling - roles, schemas and databases. * Experience of building data ingestion pipelines with tools like Informatica, Talend etc. * Effective management of data from various sources like JSON, XML, CSV 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 such as database provisioning, maintenance, and 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 More ❯

Database Administrator (PostgreSQL/Greenplum/Snowflake) - 6 months - Glasgow- Inside IR35 We're looking for skilled DBAs to manage and optimize our enterprise data platforms across PostgreSQL, Greenplum, and Snowflake. If you love performance tuning, automation, and working with cutting-edge data tech, this role is for you. Key Responsibilities: Administer Postgres, Greenplum, and Snowflake … databases. Optimize performance, manage backups, and ensure database security. Build data pipelines (Informatica/Talend) and handle varied data formats. Perform migrations using gpcopy; use Greenplum tools (gpload, pxf, GP Spark). Manage Postgres HA/DR with Patroni and streaming replication. Create automation with Shell, Python, or Ansible. Implement monitoring and troubleshoot complex issues (GPTEXT … platforms: AWS/Azure/GCP What You Will Ideally Bring: Strong DBA experience with Postgres, Greenplum, Snowflake. Solid SQL and complex query writing. Knowledge of Snowflake modelling, data lakes, and architecture. Expertise in performance tuning and stats-based optimization. Understanding of ETL processes and ingestion tools. Bonus: experience with Informatica/Talend and multi-cloud environments. Contract More ❯