SQL Developer/DBA

$120,000 - $240,000/Yr

Tradeweb Markets - Jersey City, NJ

Full-time

Jersey City, NJ

Web Search Portals, Libraries, Archives, and Other Information Services

About the position

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.

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

Requirements

• 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

Nice-to-haves

• 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)

Benefits

• 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.
• 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