Analyze, tune, and improve SQL queries and PL/SQL code, review and optimize execution plans, and assess indexing strategies to optimize Oracle database performance
Job Summary
Analyze, tune, and improve SQL queries and PL/SQL code, review and optimize execution plans, and assess indexing strategies to optimize Oracle database performance.
Manage and optimize Denodo virtual views, queries, and services, improve performance via configuration and caching strategies, and support squads in designing efficient virtualization layers.
Provide expertise to multiple squads, serve as the go-to specialist for performance issues, and collaborate on Denodo 9 security revamp.
Matching Summary
Analyze, tune, and improve SQL queries and PL/SQL code, review and optimize execution plans, and assess indexing strategies to optimize Oracle database performance.
Skills & Requirements
Must-have
Oracle database performance tuning
Denodo administration and optimization
Troubleshooting complex performance issues
Understanding of data modeling
Understanding of distributed systems
Nice-to-have
data virtualization architectures
MPP platforms
InterSystems Caché
storage strategy
cloud data platforms
monitoring tools and scripting
Key Requirements
Strong experience in Oracle database performance tuning
Hands-on Denodo administration and optimization experience