Quant Trading Firm #015
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
Qualifications
- 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
- Experience with Redis, Prometheus, VictoriaMetrics and Grafana preferred