Database Administrator
Location: Glasgow - Hybrid (3 days in office)
Day Rate: £510 (Inside IR35)
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)
Essential Skills
- 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)
- Snowflake: architecture, data lakes, roles, schemas, SQL, complex queries
- Expertise in Patroni for HADR and streaming replication
- Scripting skills in Shell, Python, or Ansible
- Experience with backup, recovery, and database security
Desirable Skills
- ETL processes and implementation
- Data ingestion pipelines (Informatica, Talend)
- Cloud experience with AWS, Azure, or GCP
Database Administrator in Paisley employer: Stott and May
Join a dynamic and innovative YC-backed start-up in London, where you'll have the opportunity to make a significant impact by transforming traditional industries with cutting-edge AI technology. The company fosters a collaborative work culture that encourages creativity and ownership, providing ample opportunities for professional growth and development. With a focus on real-world applications and a supportive team environment, this role offers a unique chance to contribute to meaningful projects while working alongside industry experts.
