Título del trabajo: Principal Software Engineer Sql

Compañía: Tradestation

Descripción de funciones: 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

Ubicación: Heredia

Fecha del trabajo: Sat, 15 Jun 2024 22:15:53 GMT