Tradeweb
SQL Developer/DBA
Tradeweb, Jersey City, New Jersey, United States, 07390
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 clients -- in 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.
https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf
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 clients -- in 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.
https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf