The task is to create a MySQL DB to store daily data for option series, populate the database with data stores in a series of CSV format files, create stored procedures to access the DB from R. The data comprises the observed date, expiration date of the options and the option Greeks (delta, Gamma etc). The data comprises around 20M records in total.
We want to be able to retrieve option combinations (put and call) of a specified type (straddle, strange, call spread, put spread) with delta in a specified range, and maturity in a specified range (number of days from observed date to expiration). The procedure will then calculate the daily PnL of the selected option combinations over each specified period.
You must be expert in SQL database programming and R programming and have some experience and understanding of financial markets. Basic understanding of options would be an advantage.