Financial Services

Oracle database specialist

Return to Postings

Our client are one of Austria's most exciting and innovative IT consultancies based in Vienna. They are now looking to expand their already highly talented team of software specialists and are looking for an Oracle database specialist to join them.

Posted On: Wednesday, 27th November 2019
Location: Austria
Job Type:
Contract
Pay Rate: Attractive & neg
Duration: December 2019 - December 2020
Travel:

Job Description:

Our client are one of Europe's most respected IT consultancies who are now looking for an Oracle Database Specialist that has knowledge of Hibernate to work with a financial client of theirs.

Your daily task will be to:

  • Analyze and Tune an Application based on Hibernate and Oracle (The application processing speed needs to be increased)
  • Enable the local team to run performance tests going forward, empower them
    to deal with bottlenecks in the future themselves.
  • Configure Hibernate to log all its SQL commands sent to the server with timestamps
  • Analyze SQL commands generated by the application
  • Performance Tune SQL commands on Oracle - identify missing stats updates, missing indexes, faster ways to access the data

Information regarding the system:

  • Complexity of the data: diversified
  • Data volume: 30GB
  • ETL: yes
  • Oracle Hints: few
  • ODI: not used
  • Power Designer: not used
  • Technologies: all is in PL/SQL

Ideally you have the following skills:

  • Being able to configure Hibernate
  • Having worked with Hibernate you understand how it works internally
  • Performance tuning of SQL statements

Additional information:

  • Work is set in the beautiful city centre within a modern and open office setting
  • This is a contract opening based full time on site in Vienna
  • There is the option of a contract extension at the end of the initial term

Preferred Skills: