Background:
This is a global, alternative investment management firm operating across a broad range of derivatives-based strategies with a deep understanding of volatility. Formed in 2007 and headquartered in New York, they have offices in London, Amsterdam, Los Angeles, Hong Kong, Stamford, and Boston. Through strategic insight, market-leading expertise, and advanced technology, they seek to anticipate and harness the complexities of world markets, creating unique opportunities for clients, team and industry alike.
Overview:
As a Senior Database Engineer, you will be at the forefront of building a leading and innovative platform that underpins the investment teams. Acting as a coach, you will contribute directly while also building and developing junior members. You will get the chance to work on cutting-edge platforms, automation tools and several interesting projects.
The ideal candidate will have essential expertise in databases such as SQL Server, Snowflake and Redshift. As a liaison between technical teams and business users, excellent communication skills are a must. They value those who take personal ownership of tasks and display a commitment to delivering high-quality results. The ideal candidate for this role is self-starting, flexible, intellectually curious and adept at creative problem-solving.
Responsibilities:
1. Design, implement, and manage database solutions across a variety of platforms, including SQL Server, Snowflake, MongoDB, and Redshift
2. Develop the consolidated core build-out for all database installations
3. Lead projects to identify and consolidate duplication across data stores
4. Contribute to the development and enforcement of best practices, ensuring consistency in database management processes
5. Develop and maintain automation scripts and tools to streamline database operations and processes
6. Leverage open-source tools (e.g. Prometheus, Grafana) to manage, monitor, and optimize database performance
7. Implement and manage database security measures, including access controls and encryption
8. Conduct regular database maintenance tasks, including backups, restores, and performance tuning
9. Monitor database systems to identify and resolve issues proactively
Essential Skills:
10. A minimum of 5+ years of hands-on experience managing enterprise database platforms
11. Essential knowledge of SQL Server, Snowflake and Redshift
12. Proficiency with Transact-SQL, and the ability to write, debug, and maintain scripts, stored procedures, functions, and views
13. Proficient in Python and Unix shell scripting (preferable)
14. Experience running applications and databases in containers (Docker, Kubernetes)
15. Excellent communication skills and the ability to work with, and inspire, a wide cross section of investment professionals
16. Fluency in English
Desirable Skills:
17. Experience in MongoDB and/or other timeseries databases
18. Demonstrate experience in optimizing databases and reducing costs
19. Experience working with trading teams, data teams and infrastructure teams
Whilst we carefully review all applications, to all jobs, due to the high volume of applications we receive it is not possible to respond to those who have not been successful.