Oracle Database Developer

  • Competitive
  • New York, NY, USA
  • Permanent, Full time
  • Open Systems Technologies
  • 05 Dec 17 2017-12-05

Our client, a global asset management firm is seeking an Oracle Database Developer to join their team in New York, NY. This candidate will join the Equity Derivatives Trading technology group. He/she will work on a project to replace the system of record and be expected to perform analysis on existing data model, design new data model using patterns and develop data representation that takes into account insert/update/query usage patterns for optimal data access. 

Responsibilities:

  • Expert designing object schema in normalized form
  • Experience developing stored procedures, triggers
  • Experience with performance tuning, trouble shooting and debugging SQL or stored procedures
  • Design, develop, implement, test support and maintain software solutions to meet business requirements
  • Write functional documents and design technical specifications
  • Test software through unit testing, test review and analysis, test witnessing and certification, fixing, and resolution
  • Analyze application for data integrity issues
  • Maintain all system diagrams, system interface charts and any other compliance policy and procedure documents

Skills:

  • In depth knowledge of Oracle Exadata DBMS
  • Experience designing Bitemporal and ETL data patterns
  • Experience designing and developing object schema, SQL, stored procedures, triggers
  • Experience tuning performance in schema, procedure or SQL
  • Experience with UNIX shell scripting
  • Knowledge of Derivative Financial products (Equity Derivative products are preferred)