At a Glance
- Tasks: Administer and optimise PostgreSQL, Greenplum, and Snowflake databases in a data-intensive environment.
- Company: Join a large-scale enterprise within the financial services sector in Glasgow.
- Benefits: Contract role with a competitive rate of £425 per day, hybrid working model.
- Other info: This is a 12-month contract position requiring 3 days onsite per week.
- Why this job: Opportunity to work with advanced database technologies in a complex environment.
- Qualifications: Strong DBA experience with PostgreSQL, Snowflake, and Greenplum is essential.
The predicted salary is between 34000 - 45000 £ per year.
We are seeking an experienced L3 Database Administrator to join a large-scale enterprise data environment within the financial services sector. The role focuses on administration, optimisation, and support of PostgreSQL, Greenplum, and Snowflake platforms in a complex, data‑intensive environment. This is a hands‑on technical role requiring deep expertise across database administration, performance tuning, data engineering support, and cloud-based data platforms.
Key Responsibilities
- Administer, maintain, and support PostgreSQL, Greenplum, and Snowflake database environments
- Manage database provisioning, upgrades, patching, and lifecycle activities
- Design and support scalable data models and architectures within Snowflake
- Work with data ingestion pipelines using tools such as Informatica or Talend
- Manage data migration activities using tools such as gpcopy with minimal downtime
- Perform performance tuning, query optimisation, and database health checks
- Handle database backup, recovery, and high availability strategies (including Patroni-based setups)
- Monitor and manage database bloat, statistics, and system performance
- Support troubleshooting using Greenplum utilities such as gpload, PXF, and GP-related tooling
- Automate database operations using Shell scripting, Python, or Ansible
- Work with structured and semi-structured data formats (JSON, XML, CSV)
- Ensure security, compliance, and operational best practices across environments
- Collaborate with engineering teams on ETL processes and data workflows
- Support cloud-based deployments across AWS, Azure, or GCP environments
Essential Skills
- Strong DBA experience across PostgreSQL, Snowflake, and Greenplum
- Advanced SQL and complex query writing
- Experience with PostgreSQL administration (provisioning, upgrades, maintenance)
- Greenplum expertise including performance tuning, gpcopy, and system optimisation
- Snowflake experience including roles, schemas, data modelling, and architecture
- Strong scripting skills in Shell, Python, or Ansible
- Experience with Patroni and streaming replication for high availability
- Strong understanding of data pipelines and ETL concepts
Desirable Skills
- Experience with ETL tools such as Informatica or Talend
- Cloud platform experience (AWS / Azure / GCP)
- Exposure to large-scale enterprise data environments
L3 Database Administration in Glasgow employer: Queen Square Recruitment Ltd
This role is based in Glasgow, offering a hybrid work model. The company operates in the financial services sector, focusing on large-scale enterprise data environments. You'll collaborate with engineering teams on ETL processes and data workflows, enhancing your technical expertise.
Contact Details:
Queen Square Recruitment Ltd Recruitment Team
