Platform Specialist - Databases

Squarepoint Capital; London; On-site; GBP 70,000 - 100,000; Full time

Job summary

A leading investment firm is seeking a Platform Applications Specialist to enhance their global systems team. You will be responsible for delivering high-performance and scalable database infrastructures, primarily focusing on technologies like PostgreSQL and Clickhouse. This role requires extensive experience in database administration and collaboration with various teams to ensure successful implementations. Join a dynamic environment that values expertise and innovation.

Qualifications

• 5+ years database administration experience with PostgreSQL, Clickhouse or FoundationDb.
• Experience with high availability and disaster recovery solutions.
• Full project life cycle ownership from initiation to implementation.

Responsibilities

• Deliver high-performance, scalable infrastructure for trading and research.
• Work collaboratively with internal teams to design and deploy database solutions.
• Support cross-platform databases and optimize system processes.

Skills

Database Administration

Linux Systems Administration

Python

Critical Thinking

Problem Solving

Education

Degree in Engineering

Degree in Computer Science

Tools

PostgreSQL

Clickhouse

Redis

Terraform

Ansible

Job description

Social network you want to login/join with:

Position Overview: Platform Applications Specialists Database role will be part of a global systems team responsible to deliver highly available, high-performance, and scalable infrastructure to support trading and research using the DevOps methodology.

As part of this role will be focused on working collaboratively with internal development, investment, and infrastructure teams to design, deploy and support cross-platform databases solution such PostgreSQL, Redis, Clickhouse and Microsoft SQL.

Required Qualifications:

• 5+ years database administration experience required (At least one of: PostgreSQL, Clickhouse, FoundationDb).
• Experience with high availability, backup, and disaster recovery solutions.
• Knowledge of indexes, triggers, stored procedure development and optimization.
• Experience with Linux systems administration.
• Experience with Python, Ruby or Perl.
• Basic understanding of source control concepts, best practices, and the software development lifecycle.
• Full project life cycle ownership: project delivery from initiation to full implementation and deployment.
• Strong verbal and written communication skills.
• Critical thinking and problem-solving skills.
• Systematic and iterative approach to analyzing and improving systems and processes.
• Degree in Engineering, Computer Science, or related experience.

Nice to have:

• Experience with other database platforms ClickHouse, FoundationDb, MSSQL, MongoDb, Redis, Neo4j.
• Experience with configuration management tools i.e. Chef, Terraform, Ansible.
• Experience with an observability & monitoring stack such as Prometheus exporters, LogStash, Elasticsearch, Prometheus, Thanos, Grafana, and AlertManager.
• Experience with CI / CD pipelines.
• Experience working with various cloud providers (AWS and GCP).
• Experience with virtualization technologies such as VMware and containers (standalone and Kubernetes).
• Experience with Windows systems administration.