Who We Are:
TradeStation is an online brokerage firm seeking to level the playing field for self-directed investors and traders, empowering them to claim their individual financial edge. At TradeStation, we're continuously pushing the boundaries of what's possible, encouraging out-of-the-box thinking and relentless search for innovation.
What We Are Looking For:
Do you love the challenge of designing and building mission-critical low-latency distributed systems that handle millions of events per second? If so, we have an opportunity for you as a SQL developer on an Agile team building high performance, real-time systems for financial market data networks. The role will play a crucial role in designing, implementing, and maintaining our database systems to ensure optimal performance and data integrity. Success in this role requires a strong technical background with a high degree of proficiency and creativity. The role requires an enthusiastic willingness to creatively solve problems for which there are no pre-existing projects.
What You'll Be Doing:
- Design SQL database solutions to meet business requirements and scalability needs
- Collaborate with cross-functional teams to understand data needs and recommend appropriate database structures
- Be a driver of innovation, technical thought leader and mentor to other less experienced engineers
- Write complex SQL queries and stored procedures to support various business applications
- Optimize and tune SQL code for performance improvements and efficient query execution
- Ensure data consistency, accuracy and security through proper data modeling and coding practices
- Monitor and analyze database performance, identifying and resolving bottlenecks and issues
- Implement best practices for database performance tuning, indexing and query optimization
- Create and maintain comprehensive documentation for database designs, schemas and processes
- Provide timely and effective support for database-related issues, ensuring minimal downtime
- Participate in Agile planning and execution
The Skills You Bring:
- Expertise in designing and implementing complex database solutions
- Proficiency in writing efficient and optimized SQL queries and stored procedures
- Strong knowledge of database security best practices
- Experience with performance tuning and optimization techniques
- Familiarity with data modeling tools and techniques
- Excellent communication and leadership skills
- Ability to work collaboratively in a team environment
- Experience with distributed and scalable software architectures, understanding of CAP theorem
- Familiarity working in a fluid Agile environment and demonstrated success with structured testing practices such as automated unit testing, regression testing, TDD and continuous delivery
- Ability to solve problems quickly and thoroughly by thinking outside the box
- Strong and effective interpersonal and communication skills and the ability to interact professionally with a diverse group
- Ability to multi-task and stay organized in a dynamic work environment
- As new technologies emerge and impact our systems, expected to learn these technologies very quickly and resolve any problems involved in integrating new technologies with our systems
- Expert knowledge on data structures, distributed/cloud architectures
- Eye for detail, eye for efficiency improvements through automation
- Good knowledge of security and encryption
Minimum Qualifications:
- 5+ years of experience with SQL Server database design and development
- Bachelor’s degree in software engineering, equivalent degree, or comparable industry experience
Desired Qualifications:
- Experience with low-latency software development
- C++ and/or C# coding skills preferred
What We Offer:
- Collaborative work environment
- Competitive Salaries
- Yearly bonus
- Comprehensive benefits for you and your family starting Day 1
- Unlimited Paid Time Off
- Flexible working environment
- TradeStation Account employee benefits, as well as full access to trading education materials
#LI-Remote