Oracle Performance tuning specialist

Компания "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