Posted in

Database SRE

Database SRE

CompanyHudson River Trading
LocationTarrytown, NY, USA
Salary$200000 – $250000
TypeFull-Time
Degrees
Experience LevelSenior

Requirements

  • 5+ years of experience working in database management and infrastructure engineering
  • Proven expertise in designing and implementing production database infrastructure, from security and replication to observability (monitoring, alerting, logging)
  • Solid familiarity with state-of-the-art DB technologies and tradeoffs (distributed DBs, time-series DBs, relaxed consistency models, columnar storage)
  • Experience with dynamic clustering solutions such as Patroni
  • Strong knowledge and experience with Linux (especially Debian)
  • Extensive experience with PostgreSQL or MySQL
  • Solid programming with the ability to write Python with an understanding of data structures and the principles of software design
  • Performance troubleshooting, and networking knowledge

Responsibilities

  • Design, build, and maintain HRT’s SQL and NoSQL database infrastructure, supporting a globally distributed trading infrastructure and extending to large-scale research
  • Configure and scale PostgreSQL and MySQL servers for trade-critical, real-time workflows
  • Investigate and improve performance of PostgreSQL and MySQL queries and supporting infrastructure (Debian Linux)
  • Transform the metrics and alerting landscape with Prometheus, VictoriaMetrics, and Grafana
  • Architect and deploy Redis based key/value stores for current and future use-cases
  • Engineer and apply infrastructure-as-code tools and services (Salt, Terraform, and others)
  • Build and test proof of concept datastores to fit consumer use cases

Preferred Qualifications

  • Experience with Redis, Prometheus, VictoriaMetrics and Grafana preferred