Компания "Dukascopy"
Oracle Performance tuning specialist
This is part-time position.
Key Responsibilities:
- proactively follow AWR reports and identify performance ineficient SQL
- Suggest optimization approach, optimize SQL and PL/SQL procedures
- Provide expertise and suggestions on performance tuning to other development team members
- Introduce best optimization practices
Essential Skills Required:
- Excellent understanding of Oracle 19c internals
- Experience with PL/SQL development, implementing new stored procedures and scripts, resolve complex PL/SQL compilation issues
- Experience and knowledge of SQL queries and SQL Trace/Explain plans, SQL performance tuning. Setting Oracle parameters, and options.
- Edition Based Redefinition
- Oracle Real Application Cluster
- Oracle Partitioning
- Solid experience (at least 5 years) in optimization