Sr Oracle PL/SQL Developer/Administrator with Performance Tuning (AWR Report)
Five Cubes Inc | Irving | www.resume-library.com |
Job Title: Sr Oracle PL/SQL Developer/Administrator with Performance Tuning (AWR Report)
Location: Irving, TX // Silver Spring, MD // Ashburn, VA // Bedminster, NJ (Hybrid)
Duration: Long Term
Visa - Any
Need senior solid candidate, Strong PLSQL coding exp in production environment.
Able to Analyze AWR report and do performance tuning by PLSQL Query.
Development
PL/SQL expert - collections, bulk collect and DML, exception handling, best practices for performance and scalability
Data modelling - basic ER creation / maintenance, strong data modelling principles, strong physical modelling (indexes global vs. local, partitions, mat views)
Performance Tuning
AWR analysis - identify system bottlenecks, poorly performing SQL / DML, misuse of DB resources, and provide solutions incl communicating with and educating development teams on best practices
Query tuning - analysis of why a query is slow and provide recommendations for indexing, rewrites, hints, etc.
Complex query tuning - able to analyze very large and complex queries to isolate the trouble spots and provide solutions as above.
Proficiency with other tools such as ASH, ADDM, TKPROF, DBMS_PROFILE, SQLT
Ideally the candidate should have a deep knowledge of Oracle DB internals and be able to communicate / educate on how to best take advantage of the database for business needs.
Top must have Skills:
Experienced SQL & PL/SQL developers (let's start small max 3) with 6+ years relevant hands-on experience including complex query performance analysis and tuning.
Experience using AWR, ADDM, ASH for application / database tuning is also required.
Experience using Toad and/or SQL Developer for tuning / coding. Candidates should be detail oriented and have good written and oral communication skills.
They should have worked (hands on) Oracle 19c and previous Oracle versions for the above requirements
Location: Irving, TX // Silver Spring, MD // Ashburn, VA // Bedminster, NJ (Hybrid)
Duration: Long Term
Visa - Any
Need senior solid candidate, Strong PLSQL coding exp in production environment.
Able to Analyze AWR report and do performance tuning by PLSQL Query.
Development
PL/SQL expert - collections, bulk collect and DML, exception handling, best practices for performance and scalability
Data modelling - basic ER creation / maintenance, strong data modelling principles, strong physical modelling (indexes global vs. local, partitions, mat views)
Performance Tuning
AWR analysis - identify system bottlenecks, poorly performing SQL / DML, misuse of DB resources, and provide solutions incl communicating with and educating development teams on best practices
Query tuning - analysis of why a query is slow and provide recommendations for indexing, rewrites, hints, etc.
Complex query tuning - able to analyze very large and complex queries to isolate the trouble spots and provide solutions as above.
Proficiency with other tools such as ASH, ADDM, TKPROF, DBMS_PROFILE, SQLT
Ideally the candidate should have a deep knowledge of Oracle DB internals and be able to communicate / educate on how to best take advantage of the database for business needs.
Top must have Skills:
Experienced SQL & PL/SQL developers (let's start small max 3) with 6+ years relevant hands-on experience including complex query performance analysis and tuning.
Experience using AWR, ADDM, ASH for application / database tuning is also required.
Experience using Toad and/or SQL Developer for tuning / coding. Candidates should be detail oriented and have good written and oral communication skills.
They should have worked (hands on) Oracle 19c and previous Oracle versions for the above requirements
Don’t miss out on new job openings!
Create a job alert for: Database Developer, Irving
It's free, and you can cancel email updates at any time