Oracle SQL/PLSQL Developer – Performance Tuning

Job Description 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