p>Responsibilities include: ⢠Managing database Disaster Recovery and High Availability for quantitative financial data, portfolio management, and trading databases ⢠Installing and upgrading the SQL Server database instances in all environments including but not limited to development, QA, and Production ⢠Designing and developing quantitative investment applications, system interfaces, databases, and reporting as required to deliver new systems functionality ⢠Performing data analysis, SQL optimization, database tuning, and general database reliability analysis ⢠Proactively monitoring the database systems to ensure secure operations with minimum downtime ⢠Collaborating with the development team throughout the system lifecycle, providing guidance on table design, database index optimization, and SQL query best practices ⢠Implementation and release of database changes as submitted by the development team ⢠Applying security patches in accordance with approved maintenance schedules ⢠Overseeing data processing workflows and ensure proper monitoring.
Requirements include:
⢠Master's degree in Computer Science or related field ⢠Proven 5+ years of SQL Server Database Administration experience ⢠5+ years of SQL development experience including package/procedure/trigger/scripting development in a multi-user production environment ⢠Ability to understand requirements and create tables, views, stored procedures, functions, and also support SQL deployment to multiple environments ⢠Experience with SQL Server High Availability configurations and disaster recovery ⢠Experience in C or C++ a big plus ⢠Familiarity with equity market data (S&P Global, Bloomberg, LSEG/Refinitiv, FactSet, etc.) is a strong plus.