L3 Database Administration - 12 months - Glasgow (Hybrid)
L3 Database Administration - 12 months - Glasgow (Hybrid)
Contracting role based in Glasgow (Hybrid, 3 days in office) for a 12-month engagement within the financial services sector. You will provide expert-level database administration across Snowflake, Greenplum, and PostgreSQL environments, covering performance tuning, data migrations, backup and recovery, security, and automation - supporting a leading global financial institution.
Key Responsibilities:
- Administer and maintain PostgreSQL, Snowflake, and Greenplum databases across provisioning, upgrades, and day-to-day operations
- Manage Greenplum data migrations using gpcopy, minimising downtime and data loss, and leverage gpload, pxf, and GP Spark for efficient data loading and integration
- Manage database bloat and utilise GPTEXT for troubleshooting complex Greenplum issues, leveraging statistics for performance optimisation
- Design and manage Snowflake architecture including data lakes, data structures, roles, schemas, and databases
What You Will Ideally Bring:
- Extensive hands-on DBA experience across PostgreSQL, Snowflake, and Greenplum - essential
- Strong SQL skills including complex query writing and performance tuning across Snowflake and PostgreSQL
- Proven expertise in Patroni for HADR and streaming replication
- Solid Scripting ability in Shell, Python, and/or Ansible for database automation
- Experience with Greenplum utilities - gpload, pxf, GP Spark, gpcopy, and GPTEXT
- Knowledge of ETL processes and data ingestion pipeline tools such as Informatica or Talend - preferred
- Experience handling structured and unstructured data formats - JSON, XML, CSV
- Cloud computing experience across AWS, Microsoft Azure, or Google Cloud - advantageous
Contract Details:
- Duration: 12 months
- Rate: £400 per day
- Location: Glasgow (Hybrid - 3 days on-site)
- Start Date: ASAP