Database Developer
Caxton Associates, founded in 1983, is a global trading and investment firm with offices in New York, London, Singapore, Monaco, Bangalore and Dubai. Our primary business is to manage client and proprietary capital through global macro hedge fund strategies.
The role
We are seeking a Database Developer to join our Bangalore-based technology team. This is a hands-on role with significant ownership of core data platform components, focused on their design, development, and optimization.
You will work closely with global teams across London and New York. You will also play a key role in shaping and scaling the firm’s data platform, directly supporting trading and investment decision-making globally. The role requires strong technical expertise, attention to data quality, and the ability to operate in a fast-paced, business-critical environment.
Key Responsibilities
- Collaborate with Technology, Quant, and Risk teams to deliver data solutions for reporting and analytics
- Design and implement scalable database schemas, tables, indexes, and stored procedures
- Develop and maintain Python ETL pipelines for trade, position, and pricing data
- Build and support reporting and visualization solutions using Tableau
- Ensure data integrity, security, and high availability across production and non-production environments
- Monitor and optimize database performance (query tuning, indexing, execution plans)
- Work with AWS services (RDS, Aurora, S3) to build scalable, resilient data platforms
- Perform database maintenance, including backups, recovery, and integrity checks
- Implement database security best practices, including user permissions and roles
- Support and improve global data platform operations across multiple regions
- Create and maintain detailed documentation of database structures, processes, and best practices