| 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] |
| 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 Thanks & Regards, Syed Mubasheer "Certified Woman Owned Minority Business Enterprise (WMBE)" 222 West Las Colinas Blvd, Suite # 540, East Towers, Irving, Texas, 75039 USA Email: [email protected] Contact No: 469 962 2899 Ext: 542 www.techstargroup.com Please consider the environment before printing this e-mail DisclaimerUnder Bill s.1618 Title III passed by the 105th U.S. This mail cannot be considered Spam as long as we include contact information and a remove link for removal from our mailing list. To be remove from our mailing list reply with " REMOVE" and include your "original email address/addresses" in the subject heading. Include complete address/addresses and/or domain to be removed. We will immediately update We apologize for the inconvenience if any caused to you. 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 |
| Wed Apr 24 03:46:00 UTC 2024 |