Job Description The Global Database Engineering & Operation Group within the Tradeweb Technology division is responsible for the entire database estate, with provision of extremely high levels of availability for the production, test & development systems to the dealers, customers and internal Tradeweb users. Job Responsibilities
- Developing / modifying database schema & code as per project requirements
- Developing / modifying ETL processes, e.g. SSIS packages & PowerShell/Python scripts
- Monitoring & troubleshooting critical scheduled tasks & processes (SQLAgent jobs, etc.)
- Working with the Infrastructure and Line of Business Technology teams to architect and implement new technologies and strategies
- Monitoring database performance, identifying potential problems, proposing ways to optimize performance & scalability.
- The provision of extremely high levels of availability for the Production, and UAT systems.
- Resolution of any problems in these systems in a timely and professional manner.
- Investigating new database functionality
Qualifications
- College degree in computer science or a related discipline, or an equivalent level of technical knowledge required.
- 7-10 years of administration & development experience in MS SQL Server (2016/2017/2019)
- 5+ years of writing complex T-SQL queries and authoring/debugging stored procedures, functions and triggers
- Strong experience of creating and maintaining SQL Server Integration Services (SSIS) packages for data extraction, transformation & loading
- 5+ years supporting a complex, large-scale, high transactional volume system to very high levels of availability
- 4+ years of using PowerShell/Python to streamline and automate frequent/recurring tasks
- Hands-on experience of database schema and code release processes
- Experience of evaluating query performance and implementing changes/strategies to improve it
- Experience of supporting Development / QA / TechOps teams to assist with data maintenance and query building
- In this role you will be required to be flexible regarding work schedule, including evening and occasional weekend duties, plus actively participating in the on-call shift rotation
- Maintaining detailed documentation on database process & procedures
- Experience using source-control tools e.g. Git
Desirable Skills:
- An understanding of the fixed-income / derivatives / equity markets and the financial instruments that trade on them
- Experience building and supporting SQL Server AlwaysOn Availability Groups
- Experience supporting all types of SQL Server replication
- Experience of the Quest suite of monitoring tools
- Experience using Solarwinds Database Performance Analyzer (DPA)
Additional Information Tradeweb is committed to providing valuable and competitive benefits. In addition to working in our culture of innovation and collaboration, we offer:
- Health Insurance: Highly competitive medical, dental, and vision programs
- Hybrid Environment: Our employees have the flexibility of working in the office and from home.
- Health Care and Dependent Care Flexible Spending Accounts: You may elect to set aside pre-tax earnings to pay for eligible health care and dependent day care expenses for you and your eligible family members.
- Maven Family Building Benefit: Maven offers support for fertility and preconception; pregnancy and post-partum; adoption; surrogacy and pediatrics for children up to age 10. Tradeweb provide a $10,000 lifetime reimbursement towards fertility, egg freezing, adoption and surrogacy expenses.
- Building Wealth - 401(k) Savings Plan: Employees are immediately eligible for the 401(k) plan. Participants may contribute up to 75% of eligible compensation into a traditional 401(k) and/or Roth 401(k). Tradeweb will match 100% of the first 4% of compensation that you contribute.
- The current pay range for this role if performed in the city of New York is currently $120,000 to $240,000 per year, based on a regular, full-time schedule. The amount of pay offered will be determined by a number of factors, including but not limited to qualifications, market data, geographic location, and internal guidelines.
Other Benefit Programs
- Pre-Tax Commuter Benefits Program
- ARAG Legal Services
- Employee Assistance Program
- Tuition Reimbursement
- Financial Wellness Tools
- Travel Assistance Benefits
- Pet Insurance
- Corporate Gym Subsidies
- Wellness Perks
- Paid Time Off and Parental Leave
Company Description Tradeweb Markets is a world leader in the evolution of electronic trading. A fintech company serving approximately 2,500 clients - including the world's largest banks, asset managers, hedge funds, insurance companies, wealth managers and retail clientsin more than 65 countries across the globe. Since our first trade in 1998, we have helped transform and electronify the fixed income markets. Tradeweb is a culture built on innovation, creativity and collaboration. Through a combination of very talented and driven people, innovative products and solutions, cutting-edge technology, market data, and a vast network of clients, we continue to work together to improve the way financial markets trade. Mission: Move first and never stop. Collaborate with clients to create and build solutions that drive efficiency, connectivity, and transparency in electronic trading. Tradeweb Markets LLC ( Tradeweb ) is proud to be an EEO Minorities/Females/Protected Veterans/Disabled/Affirmative Action Employer.