What are the responsibilities and job description for the Database SRE position at Hudson River Trading?
Hudson River Trading (HRT) is looking for a Database SRE to join our growing Research & Development team. This team builds and maintains an exceptionally large and growing distributed compute cluster, a petabyte-scale storage layer, operating systems, automation software, and development tools. Much of our hardware layer and operating system layer reflect the state-of-the-art at any given time.
We are looking for an experienced Database SRE with solid Linux systems engineering skills. You’ll be at the forefront of designing, building, and maintaining HRT’s diverse production database infrastructure, focusing on performance, scalability, and reliability. This is a job for an engineer looking to make a real difference working with a small, focused team of like-minded database and systems engineers.
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
- Exceptional communication and project management skills - this role will require cross-collaboration with various stakeholders across HRT
- You are resourceful, have a sense of urgency, and are motivated to make things better
