Database Administrator

Senior Delivery Partner at Queen Square Recruitment

Location: Glasgow

Mode: Hybrid (3 days in office)

Contract Duration: 6 Months

Our client is seeking experienced L3 Database Administrators to join their team on a contract basis
. This role involves managing and optimizing Greenplum, Postgre

SQL, and/or Snowflake databases in a hybrid working environment.

• Role 1: Snowflake DBA
• Role 2: Greenplum/Postgres DBA (Snowflake knowledge is a plus)

• Administer and maintain Postgre
  
  SQL, Snowflake, and Greenplum databases.
• Implement Snowflake modelling (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.

• Extensive DBA experience with Postgre
  
  SQL, Snowflake, Greenplum
  .
• Strong SQL and complex query writing skills.
• Expertise in Shell/Python/Ansible scripting
  .
• Knowledge of Patroni for HADR and streaming replication.
• ETL process implementation.
• Experience with Informatica, Talend
  .

Interested? Apply now and be part of a dynamic team driving data excellence!