L3 Database Administration
12 Month contract initially + Extensions
Based: 3 days p/w onsite in Glasgow
Rate - £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/Snowflake
o 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 activi...