Database Administration (Level 3)

LA International; United Kingdom; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading ICT Recruitment Consultancy in the UK is seeking a Database Administrator (Level 3) for an initial 6-month contract. The role involves managing PostgreSQL, Snowflake, and Greenplum databases, optimizing performance, and executing data migrations. Ideal candidates will have extensive experience in database administration and scripting skills. This is a great opportunity to join a progressive organization in a supportive environment.

Qualifications

• Extensive knowledge of PostgreSQL, Snowflake, and Greenplum databases.
• Experience with data ingestion pipelines using tools like Informatica and Talend.
• Strong skills in database performance tuning and optimization.

Responsibilities

• Manage day-to-day activities such as database provisioning, maintenance, and upgrades.
• Perform data migrations using gpcopy minimizing downtime.
• Ensure database security and compliance with best practices.

Skills

PostgreSQL Database Administration

Snowflake Database Administration

Greenplum Database Administration

Data Migrations using gpcopy

Performance optimization

Shell/Python/Ansible scripting

ETL processes

Cloud Computing (AWS, Azure, Google Cloud)

Job description

Database Administrator (Level 3)
6 Month contract initially
Based: Max 3 days Onsite in Glasgow
Rate: £450 - £550 p/d - (via Umbrella company)

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 number of Database Administrators (Level 3) to join the team.

Database Administration of Greenplum/ Postgres/ Snowflake

• Role 1 : Snowflake DBA
• Role 2 : GP/PSG DBA (good to know Snowflake)

Key Responsibilities

• 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 modeling - 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 & Experience

• Extensive working knowledge (DB Administration) on PostgreSQL, Snowflake and Greenplum databases.
  • For Postgres – Database provisioning, maintenance, and upgrades
  • 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.
• For Snowflake –
  • Data lakes, data structures and data models suited to Snowflake architecture.
  • Snowflake modeling – roles, schemas and databases
  • SQL and complex query writing
  • Expertise in Shell/Python/Ansible scripting 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 a HMG approved ICT Recruitment and Project Solutions Consultancy, operating globally from the largest single site in the UK as an IT Consultancy or as an Employment Business & Agency depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, LA International welcome applications from all sections of the community and from people with diverse experience and backgrounds.

Award Winning LA International, winner of the Recruiter Awards for Excellence, Best IT Recruitment Company, Best Public Sector Recruitment Company and overall Gold Award winner, has now secured the most prestigious business award that any business can receive, The Queens Award for Enterprise: International Trade, for the second consecutive period.