L3 Database Administration
12 Month contract initially + Extensions
Based: 3 days p/w onsite in Glasgow
Rate - £400 - £450 p/d (via Umbrella)
We have a great opportunity with a world leading organisation where you will be provided with all of the support and development to succeed. A progressive organisation where you can really make a difference. We have a great opportunity for a Database Administrator on a long term program of work.
Key Responsibilities:
Database Administration of Greenplum/Postgres/Snowflake
o Snowflake DBA
* Candidate will have extensive working knowledge on PostgreSQL, 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 of building data ingestion pipelines with tools like Informatica, Talend etc.
* Effective management of data from various sources like JSON, XML, CSV etc.
* 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 and 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 utilize GPTEXT for troubleshooting complex issues.
* Leverage Greenplum utilities like gpload, pxf, and GP Spark for efficient data loading and integration.
* Ensure database security, compliance, and adherence to best practices.
* Knowledge about ETL processes and its 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
Key Skills and Experience:
* Extensive working knowledge (DB Administration) on PostgreSQL, Snowflake and Greenplum databases.
o For Postgres - Database provisioning, maintenance, and upgrades
o For Greenplum -
? Data Migrations using gpcopy
? performance optimization leveraging Statistics
? Manage Db bloat, Understand and utilize GPTEXT for troubleshooting complex issues
? experience in Greenplum utilities like gpload, pxf, and GP Spark for efficient data loading and integration.
o For Snowflake -
? Data lakes, data structures and data models suited to Snowflake architecture.
? Snowflake modelling - roles, schemas and databases
* SQL and complex query writing
* Expertise in Shell/Python/Ansible scription knowledge
* Expertise in Patroni for HADR and streaming replication
Desirable skills/knowledge/experience:
* ETL processes and its implementation
* Building data ingestion pipelines with tools like Informatica, Talend etc
* Cloud computing experience with AWS, Microsoft Azure, Google Cloud
This is an excellent opportunity on a great project of work, If you are looking for your next exciting opportunity, apply now for your CV to reach me directly, we will respond as soon as possible.
LA International is an award-winning partner of choice for many of the world's most influential companies and government organisations. Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance.
A multiple award-winning organisation, having secured the prestigious Queens Award for Enterprise: International Trade over consecutive years. 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 we 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.
Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.