Database Administrator - 6 months - Glasgow- Inside IR35
Hamilton Barnes
Lanark, United Kingdom
4 days ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Compensation
£ 117KJob location
Lanark, United Kingdom
Tech stack
Amazon Web Services (AWS)
Azure
Databases
ETL
Database Security
Greenplum
Python
PostgreSQL
Performance Tuning
Ansible
SQL Databases
Talend
Snowflake
Spark
Data Lake
Data Pipelines
Job description
- Administer Postgres, Greenplum, and Snowflake databases.
- Optimize performance, manage backups, and ensure database security.
- Build data pipelines (Informatica/Talend) and handle varied data formats.
- Perform migrations using gpcopy; use Greenplum tools (gpload, pxf, GP Spark).
- Manage Postgres HA/DR with Patroni and streaming replication.
- Create automation with Shell, Python, or Ansible.
- Implement monitoring and troubleshoot complex issues (GPTEXT).
- Work with cloud platforms: AWS/Azure/GCP
Requirements
- Strong DBA experience with Postgres, Greenplum, Snowflake.
- Solid SQL and complex query writing.
- Knowledge of Snowflake modelling, data lakes, and architecture.
- Expertise in performance tuning and stats-based optimization.
- Understanding of ETL processes and ingestion tools.
- Bonus: experience with Informatica/Talend and multi-cloud environments.
