Oracle Database - Performance tuning Developer
Hi
Position:
Oracle Database - Performance tuning Developer
Location: Austin, Texas
Duration: Long term
Investigate and resolve issues reported by users. Debug and fix defects in PL/SQL code, troubleshoot database-related problems, and implement corrective actions.
* Analyze and optimize SQL queries and PL/SQL code for improved performance and scalability. Identify and resolve bottlenecks, index inefficiencies, and database performance issues.
* Coordinating with Development team and explaining the data models and writing the PL/SQL code
* Collaborate with business stakeholders to understand data requirements and translate them into effective SQL/PLSQL solutions.
* Provide insights and recommendations based on data analysis.
* Review and optimize PL/SQL code for performance and best practices.
* AWR (Load Profile, SQL Elapsed Time (CPU, IO, Gets, Reads, System Statistics, IO Throughput)/ASH/ADDM Analysis for the long runner and provide the optimization results for better enhancements.
* Using hints to optimize the queries such as Leading, Ordering, INDEX, INDEX-COMBINE, INDEX_MERGE etc.
* DR Build Exercise, Periodical Patching s, Extensive level of query tuning using SQL Profile, SQL Baselines, SQL Patch, Hints.
* Designed and managed database schema (tables, views, stored procedures) for [mention applications or functionalities].
Hi
Position:
Oracle Database - Performance tuning Developer
Location: Austin, Texas
Duration: Long term
Investigate and resolve issues reported by users. Debug and fix defects in PL/SQL code, troubleshoot database-related problems, and implement corrective actions.
* Analyze and optimize SQL queries and PL/SQL code for improved performance and scalability. Identify and resolve bottlenecks, index inefficiencies, and database performance issues.
* Coordinating with Development team and explaining the data models and writing the PL/SQL code
* Collaborate with business stakeholders to understand data requirements and translate them into effective SQL/PLSQL solutions.
* Provide insights and recommendations based on data analysis.
* Review and optimize PL/SQL code for performance and best practices.
* AWR (Load Profile, SQL Elapsed Time (CPU, IO, Gets, Reads, System Statistics, IO Throughput)/ASH/ADDM Analysis for the long runner and provide the optimization results for better enhancements.
* Using hints to optimize the queries such as Leading, Ordering, INDEX, INDEX-COMBINE, INDEX_MERGE etc.
* DR Build Exercise, Periodical Patching s, Extensive level of query tuning using SQL Profile, SQL Baselines, SQL Patch, Hints.
* Designed and managed database schema (tables, views, stored procedures) for [mention applications or functionalities].