3 of 3 Data Lake Jobs in Glasgow

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 ❯

Role Description: To build and maintain the systems that collect, store, process, and analyse data, such as data pipelines, data warehouses and data lakes to ensure that all data is accurate, accessible, and secure. Candidates working for this role will either contribute to strategic deliverables by building data … or support platform modernization efforts by migrating existing AWS components to Databricks, depending on their assessed skill sets. **UI development expereince as must along with AWS Cloudformation.** AWS Data Engineering JD Should lead the project: • Strong hands-on data engineering experience delivering production-grade solutions. • Ability to design, implement and optimise complex data pipelines … with stakeholders, understanding business requirements, and translating them into technical design. • Strong Experience in Databricks development/migration. (this is for Databricks engineer) • Experience with Apache Spark, Databricks Delta Lake, Unity Catalog, and MLflow.( this is for Databricks engineer) Accountabilities • Build and maintenance of data pipelines that enable the transfer and processing of durable, complete and consistent 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 ❯