Role summary:

We are looking for a database Developer who will be responsible for optimizing the Oracle database tables, SQL queries, and recommending new data models for mission critical empirical research database.

The work involves working closely with Equity quantitative research analysts in developing new sources of information for the development of equity models in line with business requirements.

Role responsibilities:

Using their proficiency in PL/SQL, the ideal candidate should be able to understand complex queries, look into their execution plan and come up with a combination of alternatives to the tables, the indices and the code to optimize performance or meet other objectives as required.

The candidate should be able to take a large/ complicated codebase of sql statements, understand the patterns in it and be able to modularize and optimise the code using parameterized cursors , stored procedures and scripting languages.

Technical Requirements:

An Oracle database developer specialising in optimising Oracle database and SQL queries.

We are moving some of the data processing from SQL to python, the ideal candidate should be at least able to call SQL procedures from a python program.

Business Requirements:

In order for the successful candidate to be productive from day one they will require knowledge and understanding of financial and equity markets. Specifically:

A variety of equity source feeds such as Compustat, IBES, MSCI, FTSE, S&P, etc.

Characteristics/ issues related to fundamental equity data i.e. basic equity accounting metrics such as EBITDA, Revenue, Free Cashflow, Operating Margin, etc.