Database Administrator (Level 3)
6 Month contract initially
Based: Max 3 days Onsite in Glasgow
Rate: £450 - £550 p/d - (via Umbrella company)
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 number of Database Administrators (Level 3) to join the team.
Database Administration of Greenplum/Postgres/Snowflake
o Role 1: Snowflake DBA
o Role 2: 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.
...