Oracle SQL/PLSQL Developer – Performance Tuning

Skills: IT IS_AMS_Oracle Database Administration~Oracle 10g Database performance tuning

Experience Required: 8-10

Descriptions: Oracle SQL/PLSQL Developer - Performance Tuning

We are seeking an experienced Oracle SQL/PLSQL Developer with strong expertise in SQL query optimization| database performance tuning| and Oracle database development.

The ideal candidate should possess hands-on experience in designing| developing| and tuning complex SQL and PL/SQL programs while ensuring high performance| scalability| and reliability of Oracle databases.

Required Technical Skills Oracle Database Oracle 11g/12c/19c/21cOracle Architecture fundamentals Database Objects Management SQL Complex SQL Queries Joins and Subqueries (WITH Clause)Analytical Functions MERGE Statements

Query OptimizationPL/SQLProceduresFunctionsPackagesTriggersCollectionsBulk Collect and FORAL Dynamic SQL Exception Handling Performance Tuning Explain Plan DBMS_XPLANSQL Trace TKPROFAWR Reports ASH Reports ADDM Reports

SQL Profiles SQL Baselines Index Tuning Partitioning Concepts Performance Tuning Expertise

Analyze execution plans and identify inefficient access paths.

Optimize high-cost SQL statements. Tune joins| subqueries| aggregation| and sorting operations.

Improve response times through indexing strategies.

Resolve locking| blocking| and deadlock issues. Tune PL/SQL code using bulk processing techniques.

Gather and maintain optimizer statistics using DBMS_STATS.

Diagnose CPU| Memory| and I/O bottlenecks.

Preferred Skills Oracle Exadata knowledge Shell Scripting Linux/Unix Commands Git/Version Control Agile/Scrum Methodology Banking & Financial Services domain experience

Key Performance Indicators (KPIs)Query performance improvements Reduction in batch processing timesIncident resolution turnaround time

Database availability and stability Production issue prevention and root cause analysis

Experience Required: 8-10

Location: Chennai, Hyderabad, Pune, Bangalore

WORK FROM OFFICE