Epicareer Might not Working Properly
Learn More
P

Oracle Database - Performance tuning Developer

Salary undisclosed

Checking job availability...

Original
Simplified

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].

Thanks & Regards
Sagar
Desk: +1
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job

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].

Thanks & Regards
Sagar
Desk: +1
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job