Contract Opportunity: 2x L3 Database Administrators (Snowflake OR Greenplum/PostgreSQL)
Location: Glasgow
Mode: Hybrid (3 days in office)
Contract Duration: 6 Months
Rate: £400 – £500 per day inside IR35
About the Role
Our client is seeking experienced L3 Database Administrators to join their team on a contract basis. This role involves managing and optimizing Greenplum, PostgreSQL, and/or Snowflake databases in a hybrid working environment.
Open Positions:
* Role 1: Snowflake DBA
* Role 2: Greenplum/Postgres DBA (Snowflake knowledge is a plus)
Key Responsibilities
* Administer and maintain PostgreSQL, Snowflake, and Greenplum databases.
* Implement Snowflake modeling (roles, schemas, databases) and integrate with data processing technologies.
* Design and manage data lakes, structures, and models suited for Snowflake architecture.
* Build data ingestion pipelines using tools like Informatica, Talend.
* Manage data from multiple sources (JSON, XML, CSV).
* Ensure high availability and disaster recovery using Patroni and streaming replication.
* Perform backup, recovery, performance tuning, and optimization for Postgres/Snowflake/Greenplum.
* Execute data migrations with minimal downtime using tools like gpcopy.
* Utilize Greenplum utilities (gpload, pxf, GP spark) for efficient data loading.
* Develop automation scripts in Shell, Python, Ansible.
* Implement monitoring solutions and ensure database security and compliance.
* Work with cloud platforms (AWS, Azure, GCP).
* Additional Conditions: On-call availability over weekends.
Your Profile
Essential Skills:
* Extensive DBA experience with PostgreSQL, Snowflake, Greenplum.
* Strong SQL and complex query writing skills.
* Expertise in Shell/Python/Ansible scripting.
* Knowledge of Patroni for HADR and streaming replication.
Desirable Skills:
* ETL process implementation.
* Experience with Informatica, Talend.
* Cloud computing expertise (AWS, Azure, GCP).
Interested? Apply now and be part of a dynamic team driving data excellence!