I tried to reach you for the positionofSr Oracle PL SQL Developer at Oracle, Arizona, USA |
Email: [email protected] |
From: Raj, Techgene [email protected] Reply to: [email protected] I tried to reach you for the position of Sr Oracle PL/SQL Developer/Administrator with Performance Tuning (AWR Report) and - Irving, TX // Silver Spring, MD // Ashburn, VA // Bedminster, NJ // Alpharetta, GA // Temple Terrace, FL (Hybrid) I hope you are well. I am (Raj) with Techgene Solutions LLC. Were Sr Oracle PL/SQL Developer/Administrator with Performance Tuning (AWR Report)and I think your experience is a great fit for this role. If youre interested in learning more, Id love to connect with you. Please review th e Job description below and let me know if you are comfortable. I look forward to hearing from you soon. Thank you! Please share your profiles to [email protected] or you can reach me at 972-580-0247 Ext 253 CHECKPOINT Full Legal Name Contact Number Email ID Date of Birth (MM/DD) Last 4 Digit SSN Current Location with Zip Code Two LinkedIn references from their recent two projects Work Authorization/Visa Status Passport Number Corporation Name Open to relocate OR Travel Total Years of IT Experience Education Details University, year: US Experience Job Title: Sr Oracle PL/SQL Developer/Administrator with Performance Tuning (AWR Report) Location: Irving, TX // Silver Spring, MD // Ashburn, VA // Bedminster, NJ // Alpharetta, GA // Temple Terrace, FL (Hybrid 3 days onsite on any location ) 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 analyse 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: access management materials management database information technology procedural language Florida Georgia Idaho Maryland New Jersey Texas Virginia I tried to reach you for the positionofSr Oracle PL SQL Developer [email protected] |
[email protected] View all |
Thu Jun 13 23:46:00 UTC 2024 |