Belvedere Trading is a leading proprietary trading firm proudly headquartered in downtown Chicago. Our traders work hard to provide liquidity to the market through their market-making activities and are the masters of a diverse set of commodities, interest rates, exchange-traded funds (ETF), and equity index options. From the beginning, we began iteratively investing in our proprietary technology and committing to building our systems from the ground up. Our trading models and software systems are continually re-engineered, optimized, and maintained to stay on top of the industry. This wouldn’t be possible without the dedicated efforts of our technology teams who utilize and perfect our innovative technology solutions.
Our team’s focus is to deliver high-quality data solutions to our core and affiliated groups. We strive to understand and support end-user needs who both leverage data for performance analytics and depend on our SQL Server infrastructure backing production trading systems. The data team strives to ensure that properly curated data is in the hands of the people who need it. They deliver the data and tools Belvedere needs to perform complex analytics and make data-driven decisions.You will be part of a team responsible for designing software and infrastructure to ensure the high availability, stability, and integrity of our production SQL Server databases.
Additionally, you will contribute to the design and operation of our data warehouse and cloud data pipeline processes. A passion for supporting data consumers and development teams during business hours, combined with strong attention to detail and a genuine curiosity to understand and analyze data, will be essential. As a member of the Data Platform Team at Belvedere, you will be expected to delve deeply into complex challenges, adapt to evolving technologies and business requirements, and actively contribute your insights to enhance team efficiency and outcomes.
What you'll do
- Support the continuous operation of on-premises and cloud databases, including SQL Server, Google BigQuery, and Google Cloud SQL.
- Address database performance issues by helping to implement solutions, which may involve hardware upgrades, server configuration adjustments, or optimizing queries and indexes.
- Collaborate with developers to ensure efficient query design and data modeling for traditional SQL, SQL data warehouses, and NoSQL use cases.
- Maintain monitoring systems, dashboards, and operational health plans for database infrastructure.
- Provide support for and troubleshoot issues related to data pipelines, ETL jobs, replication processes, and other database-dependent critical systems in coordination with the DBA team.
- Debug application code, notebooks, and batch jobs to identify and enhance query performance and behavior.
- Follow DBA team standards and procedures.
- Develop a comprehensive understanding of organizational data sources and business use cases through collaboration with teams and self-directed learning.
- Participate in on-call rotations with other DBAs to ensure the ongoing availability and stability of database systems.
- Occasionally perform duties outside of trading hours, including weekends and holidays, as required for scheduled maintenance or to address unforeseen emergencies.
What you'll need
- Proven experience in operating and supporting SQL Server database infrastructure.
- Demonstrated experience in supporting SQL Server rollouts and migrations within complex application environments.
- Familiarity with database change control processes and tools.
- Hands-on experience with clustering, mirroring, and replication technologies in production environments.
- Experience in query optimization and performance tuning.
- Knowledge of and demonstrated experience with SQL/T-SQL.
- Understand and be able to apply principles of relational databases like normalization, referential integrity, constraints, indexes, tables, columns, data types, primary keys, and similar.
- Exposure to modern cloud data warehouses and associated tools.
- Willingness and ability to learn and work with development languages and tools, particularly PowerShell and Python.
- Excellent verbal and written communication skills, along with strong analytical and problem-solving abilities.
- Minimum of 2 years of relevant experience (preferred)
$110,000 - $140,000 a yearAdditionally, certain positions at Belvedere Trading are eligible for discretionary bonuses. Our employees have access to a variety of benefits, which can be found on our website here.Women and underrepresented groups frequently apply to jobs only if they meet 100% of the qualifications.We encourage you to break that mold and apply. No candidate is perfect; all have a lot to offer. We welcome your application.Core ValuesThe secret to our award-winning culture is our Core Values: Team Belvedere, Me In Team, Own It, Iterative Innovation, and Passionate Discourse. We live and breathe these values every day.Our StanceBelvedere is an Equal Opportunity Employer and is committed to providing a non-discriminatory employment environment for its employees.
Discrimination against employees and applicants due to race, color, religion, sex, national origin, disability, age, military, and veteran status is prohibited. Belvedere encourages initiatives to increase diversity and provide equal opportunity to all applicants and employees. Belvedere is committed to providing a positive environment in which team members are treated with respect, dignity, and courtesy. Our firm believes in a dynamic culture of inclusion and diversity, where people thrive on individual and organizational characteristics, values, experiences, and backgrounds.Please note that Belvedere Trading does not accept unsolicited resumes from search firms or employment agencies. Any unsolicited resumes will become the property of Team Belvedere. No phone calls, please.Any questions regarding the virtual recruiting process, please reach out to recruiting@belvederetrading.com.
Work Schedule:
Regular and reliable attendance during standard business hours
Amount of Travel Required:
None
Sponsorship:
Not available for this position
Apply for this job
