Database Administrator
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!