L3 Database Administration

L3 Database Administration

12 Month contract initially + Extensions. Based:
Glasgow, 3 days per week onsite.

Rate: £400-£450 per day (via Umbrella).

• Database Administration of Greenplum/Postgres/Snowflake.
• Snowflake DBA activities.
• Extensive working knowledge of Postgre
  
  SQL, Snowflake and Greenplum databases.
• Snowflake internals and integration with other data processing technologies.
• Data lakes, data structures and data models suited to Snowflake architecture.
• Snowflake modelling – roles, schemas and databases.
• Experience building data ingestion pipelines with tools such as Informatica, Talend, etc.
• Effective management of data from various sources such as JSON, XML, CSV.
• Expertise in Patroni for HADR and streaming replication.
• Strong knowledge of Postgres/Greenplum database backup and recovery strategies.
• Proven experience in performance tuning and optimization for Postgres/Snowflake/Greenplum.
• Develop and maintain backup strategies to ensure data integrity and availability.
• Manage day‑to‑day activities such as database provisioning, maintenance and upgrades in Postgres.
• Perform data migrations using gpcopy and other tools, minimizing downtime and data loss.
• Manage database bloat and leverage statistics for performance optimization.
• Understand and utilise GPTEXT for troubleshooting complex issues.
• Leverage Greenplum utilities like gpload, pxf and GPspark for efficient data loading and integration.
• Ensure database security, compliance and adherence to best practices.
• Knowledge of ETL processes and implementation.
• Knowledge of SQL and complex query writing.
• Implement monitoring solutions to proactively identify and resolve issues.
• Develop scripts in shell/Python/Ansible to automate routine database tasks and improve operational efficiency.
• Cloud computing experience with AWS, Microsoft Azure, Google Cloud.

• Extensive working knowledge of Postgre
  
  SQL, Snowflake and Greenplum databases.
• For Postgre
  
  SQL: database provisioning, maintenance and upgrades.
• For Greenplum: data migrations using gpcopy, performance optimisation leveraging statistics, management of DB bloat, use of GPTEXT, tools such as gpload, pxf and GPspark.
• For Snowflake: data lakes, data structures and models suitable for the architecture, modelling of roles, schemas and databases.
• SQL and complex query writing.
• Expertise in Shell/Python/Ansible scripting.
• Expertise in Patroni for HADR and streaming replication.

• ETL processes and implementation.
• Building data ingestion pipelines with Informatica, Talend, etc.
• Cloud computing experience with AWS, Microsoft Azure, Google Cloud.

We are committed to fostering an inclusive, equitable and accessible workplace where everyone feels valued and supported. We welcome applications from all individuals, regardless of background or identity, and encourage candidates who may not meet every listed requirement to still apply. If you require any adjustments or support during the recruitment process, please let us know and we will work with you to ensure a fair and accessible experience.