Technical Analyst/Performance Tuning - Oracle

We are looking for a DBA/technical analyst to fit the following position. Note that this is not a development role. Our client is looking for a PERFORMANCE ARCHITECT to work within an existing test team. You will be responsible for understanding the non-functional requirements and how they translate into the required service level characteristics (performance and availability) of a complex integrated platform.

key tasks

1) Analyse and review focused on optimizing performance: Forms and Reports, Batch Processes (Packages)

2) Review and comment Technical Proposals on, for example, criteria like: Performance impact, Logical data model done and designed, Database access defined (read, write, delete, update ), Archiving, purging strategy described, Impact analysis, Technical alternatives, Resource Impact and sizing

3) Undertake Code reviews and Quality reviews.

4) Analyse PL/SQL packages and propose changes to improve performance, developing and executing tests on a tesing environment. You will need to interpret/understand test results and be able to document test results accurately and be able to confidently present them.

expertise expected

You should have:

1) an expert knowledge of Oracle database 10g and 11g,

2) a good grasp of DBA functions as they relate to performance

3) A thorough and complete knowledge of Oracle Forms and Reports

4) Good knowledge of tools such as SQL ID, TKPROF (SQL Tracer), AWR (Automatic Workload Repository)

5) Good knowledge of oracle optimization processes such as PIPELINE, BULK Processing, BINNING

A technical background around the ODI technology XSD XML, SOAP/MTOM with their implementation on .NET and Java platforms and WS-. is a plus.