CAIA's Career Center is an easy-to-use, comprehensive resource connecting job seekers with employers in the growing AI field. Use your knowledge and credibility to advance your career or build a talented team for your organization. Opportunities targeted to CAIA Charterholders are prioritized.
In order to search for jobs specifically for CAIA Charterholders or those pursuing the CAIA Charter please enter “CAIA” in the search panel.
This will enable you to search for CAIA specific roles globally.
A Leading Financial Services Business are looking to hire a Senior Oracle Optimizer.
6-12 months contract
Competitive Day Rate - £300 - £600 a day
London based - initially WFH
Deep understanding of Oracle Architecture.
Good Understanding of EXADATA system and key features.
Basic DBA skills including capacity monitoring and planning.
Oracle v 12 experience preferred.
Good understanding of Oracle Wait Events.
Good understanding of SQL and PL/SQL code.
Basic design concepts (PDMs etc).
Ability to read and understand performance reports (AWR/ASH/v$/TKPROF)
Ability to read and understand execution plans.
Ability to drive testing, carry out baseline/fix reconciliation and make concise suggestions based on results.
Proven track record of supporting live database applications.
Good communication skills. Able to efficiently exchange information with all levels of the project.
The team have a deep understanding of query tuning, baselines, Exadata subsystem, hints etc and are able to identify performance bottlenecks and provide guidance on how a job should be written, or indeed rewrite the query themselves
A good Oracle generalist / PL/SQL / DevOps / Analysis is also something that would be of interest.
Oracle Optimizer is an Oracle toolset to make databases more efficient through tuning of SQL queries etc
The role is quite complex in terms of background and skills set.
Someone who is an Oracle "Optimizer" / "Query Optimizer" / "SQL Optimizer" expert, would be beneficial
Needs to have good recent experience using Oracle Optimizer to tune high-transaction databases - ideally in FS sector, even more so within Payments.