Database Administrator

Database Administrator

Posted 2 weeks ago by Queen Square Recruitment

Apply
£500 Per day
Inside
Hybrid
Glasgow, Scotland, United Kingdom
Apply
Ansible Apache Spark Automation Business Continuity And Disaster Recovery Cloud Computing Cloud Technology Database Administration Database Security Data Ingestion Data Lakes Data Processing Disaster Recovery Extensible Markup Language (XML) Extract Transform Load (ETL) Google Cloud Platform (GCP) Greenplum Informatica Microsoft Azure Oracle Database Administration (DBA) Performance Tuning PostgreSQL Python (Programming Language) Scripting Snowflake (Data Warehouse) SQL (Programming Language) Talend

Summary: The role of L3 Database Administrator involves managing and optimizing databases such as Snowflake, Greenplum, and PostgreSQL in a hybrid working environment. The position requires extensive experience in database administration and scripting, with responsibilities including data ingestion, backup, recovery, and performance tuning. The contract duration is for 6 months, and the role is based in Glasgow. Candidates should be prepared for on-call availability over weekends.

Key Responsibilities:

  • Administer and maintain PostgreSQL, Snowflake, and Greenplum databases.
  • Implement Snowflake modeling (roles, schemas, databases) and integrate with data processing technologies.
  • Design and manage data lakes, structures, and models suited for Snowflake architecture.
  • Build data ingestion pipelines using tools like Informatica, Talend.
  • Manage data from multiple sources (JSON, XML, CSV).
  • Ensure high availability and disaster recovery using Patroni and streaming replication.
  • Perform backup, recovery, performance tuning, and optimization for Postgres/Snowflake/Greenplum.
  • Execute data migrations with minimal downtime using tools like gpcopy.
  • Utilize Greenplum utilities (gpload, pxf, GP spark) for efficient data loading.
  • Develop automation scripts in Shell, Python, Ansible.
  • Implement monitoring solutions and ensure database security and compliance.
  • Work with cloud platforms (AWS, Azure, GCP).
  • On-call availability over weekends.

Key Skills:

  • Extensive DBA experience with PostgreSQL, Snowflake, Greenplum.
  • Strong SQL and complex query writing skills.
  • Expertise in Shell/Python/Ansible scripting.
  • Knowledge of Patroni for HADR and streaming replication.
  • ETL process implementation.
  • Experience with Informatica, Talend.
  • Cloud computing expertise (AWS, Azure, GCP).

Salary (Rate): £500 daily

City: Glasgow

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Contract Opportunity: 2x L3 Database Administrators (Snowflake OR Greenplum/PostgreSQL) Location: Glasgow Mode: Hybrid (3 days in office) Contract Duration: 6 Months Rate: £400 – £500 per day inside IR35

About the Role Our client is seeking experienced L3 Database Administrators to join their team on a contract basis . This role involves managing and optimizing Greenplum, PostgreSQL, and/or Snowflake databases in a hybrid working environment. Open Positions: Role 1: Snowflake DBA Role 2: Greenplum/Postgres DBA (Snowflake knowledge is a plus)

Key Responsibilities

  • Administer and maintain PostgreSQL, Snowflake, and Greenplum databases.
  • Implement Snowflake modeling (roles, schemas, databases) and integrate with data processing technologies.
  • Design and manage data lakes, structures, and models suited for Snowflake architecture.
  • Build data ingestion pipelines using tools like Informatica, Talend .
  • Manage data from multiple sources (JSON, XML, CSV).
  • Ensure high availability and disaster recovery using Patroni and streaming replication.
  • Perform backup, recovery, performance tuning, and optimization for Postgres/Snowflake/Greenplum.
  • Execute data migrations with minimal downtime using tools like gpcopy .
  • Utilize Greenplum utilities (gpload, pxf, GP spark) for efficient data loading.
  • Develop automation scripts in Shell, Python, Ansible .
  • Implement monitoring solutions and ensure database security and compliance.
  • Work with cloud platforms (AWS, Azure, GCP).

Additional Conditions: On-call availability over weekends.

Your Profile

Essential Skills: Extensive DBA experience with PostgreSQL, Snowflake, Greenplum . Strong SQL and complex query writing skills. Expertise in Shell/Python/Ansible scripting . Knowledge of Patroni for HADR and streaming replication.

Desirable Skills: ETL process implementation. Experience with Informatica, Talend . Cloud computing expertise (AWS, Azure, GCP).

Interested? Apply now and be part of a dynamic team driving data excellence!

Apply
Similar Jobs
Loading data...