L3 Database Administration

L3 Database Administration 12 Month contract initially + ExtensionsBased: 3 days p/w onsite in GlasgowRate - £400 - £450 p/d (via Umbrella)We have a great opportunity with a world leading organisation where you will be provided with all of the support and development to succeed. A progressive organisation where you can really make a difference. We have a great opportunity for a Database Administrator on a long term program of work. Key Responsibilities:Database Administration of Greenplum/Postgres/Snowflakeo Snowflake DBA* 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 ..... full job details .....