Squarepoint Capital Logo
Squarepoint Capital
Platform Specialist - Databases
🌎Montreal
1w ago

Job Description

Department:   Application Engineering

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.