| Oracle PL SQL Developer with Performance Tuning, AWR Report at Irving, TX, Silver Spring, MD, Ashburn, VA, Bedminster, NJ (Hybrid) at Irving, Texas, USA |
| Email: [email protected] |
| From: Syed, TechStar Group [email protected] Reply to: [email protected] Title: Oracle PL/SQL Developer with Performance Tuning (AWR Report) Location: Irving, TX, Silver Spring, MD, Ashburn, VA, Bedminster, NJ (Hybrid) Duration: Long Term 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 (lets 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 Keywords: database procedural language Maryland New Jersey Texas Virginia Oracle PL SQL Developer with Performance Tuning, AWR Report at Irving, TX, Silver Spring, MD, Ashburn, VA, Bedminster, NJ (Hybrid) [email protected] |
| [email protected] View all |
| Tue Apr 23 23:09:00 UTC 2024 |