Associate Delivery Consultant at Stott and May
Database Administrator
Location: Glasgow - Hybrid (3 days in office)
Contract Duration: 6 Months
Additional Conditions: On-call over weekends
Role Overview
We are seeking an experienced Database Administrator to manage PostgreSQL, Greenplum or Snowflake databases. The role includes administration, performance tuning, backup and recovery, automation, and supporting data ingestion and integration pipelines.
Focus areas
* Snowflake DBA – data lakes, architecture, roles, schemas, and databases.
* Greenplum/Postgres DBA – database maintenance, migrations, and performance optimisation.
Responsibilities
* Administer and maintain PostgreSQL, Greenplum, and Snowflake databases
* Design and manage Snowflake data structures, roles, schemas, and databases
* Build and manage data ingestion pipelines (Informatica, Talend)
* Manage data from multiple sources (JSON, XML, CSV)
* Implement Patroni for HADR and streaming replication
* Perform database provisioning, maintenance, upgrades, and migrations (gpcopy)
* Optimise performance using statistics and Greenplum utilities (gpload, PXF, GP spark)
* Manage database bloat and troubleshoot issues using GPTEXT
* Develop scripts in Shell, Python, or Ansible to automate routine tasks
* Ensure database security, compliance, and best practices
* Implement monitoring solutions to proactively detect and resolve issues
* Support cloud deployments (AWS, Azure, GCP)
Qualifications
* Extensive experience with PostgreSQL, Greenplum, and Snowflake administration
* Postgres: provisioning, maintenance, upgrades, and migrations
* Greenplum: migrations, performance tuning, bloat management, GPTEXT, utilities (gpload, PXF, GP spark)
* Expertise in Patroni for HADR and streaming replication
* Scripting skills in Shell, Python, or Ansible
* Experience with backup, recovery, and database security
* ETL processes and implementation
* Cloud experience with AWS, Azure, or GCP
Seniority level
Not Applicable
Employment type
Contract
Job function
Quality Assurance
Industries Financial Services, Banking, and Investment Banking
Referrals increase your chances of interviewing at Stott and May by 2x
#J-18808-Ljbffr