What are the responsibilities and job description for the SQL Server Database Administrator position at Candidate Experience site?
About Tradeweb:
Tradeweb Markets Inc. is a leading global operator of electronic marketplaces for rates, credit, equities and money markets. Founded in 1996, Tradeweb provides access to markets, data and analytics, electronic trading, straight-through-processing and reporting for clients in the institutional, wholesale and retail markets. Advanced technologies developed by Tradeweb enhance price discovery, order execution and trade workflows while allowing for greater scale and helping to reduce risks in client trading operations. For more information, please go to www.tradeweb.com.
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
Group Details:
The Global Database Engineering & Operations Group within the Tradeweb Technology Platform 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:
- Monitoring database availability, identifying potential problems, proposing ways to optimize availability & scalability.
- Working with the Infrastructure and line of business technology teams to architect and implement new technologies and strategies
- Managing data backup and restores required for disaster recovery.
- Installation of new servers, and upgrade of existing servers with regard to patches and new versions.
- The provision of extremely high levels of availability for the Production systems.
- Resolution of any problems in these systems in a timely and professional manner.
- Ensuring compliance with company security procedures.
- Automation of regular / recurring tasks
- Participate fully in the team’s 24x5½ “follow the sun” support model with daily hand-over / hand-off calls to colleagues in U.S. / U.K. respectively, as well as occasional weekend work & scheduled on-call duties
Required Qualifications:
- College degree in computer science or a related discipline, or an equivalent level of technical knowledge required.
- 8 years of administration & development experience in MS SQL Server (2019/2022)
- 5 years supporting a complex, large-scale, high transactional volume system to very high levels of availability
- 5 years of writing ad-hoc T-SQL queries and authoring/debugging stored procedures, functions and triggers
- 4 years of using PowerShell 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 building and supporting SQL Server AlwaysOn Availability Groups
- Experience of supporting Development / QA / TechOps teams to assist with data maintenance and query building
- 4 years supporting all types of SQL Server replication
- Experience of creating and maintaining SQL Server Integration Services (SSIS) packages for data extraction, transformation & loading
- An understanding of the fixed income / derivatives / equity markets and the financial instruments that trade on them
- Experience with MS SQL Server on SAN’s
- Experience using Red Gate Monitor
- Experience using Red Gate Flyway Enterprise
- Any experience of Oracle, PostgreSQL or Cassandra highly desirable
Desirable Skills:
- An understanding of the fixed income / derivatives / equity markets and the financial instruments that trade on them
- Experience with MS SQL Server on SAN’s
- Experience using Red Gate Monitor
- Experience using Red Gate Flyway Enterprise
- Any experience of Oracle, PostgreSQL or Cassandra highly desirable