Performance Technical Support Analyst 4
Posted: November 10, 2016
Reference ID: 160018P0
The Performance Team's mission is to provide solutions for customers experiencing issues involving transactions that are not processing in an expected about of time. In general we focus on a handful of diagnostic tools to help diagnose and provide solutions for various performance related issues. These include the ability to analyze a system state dump, a 10053 optimizer trace, a 10046 sql trace, a hang analyze, AWR/ASH reports. The ability to tune a sql statement is imperative for this position.
Apart from the above mentioned requirements, following would also be essential:1. Overall knowledge of database fundamentals and deep knowledge of database architecture and concepts.2. Hands on experience on SQL Tuning - Knowledge of different join methods, hints & optimizer concepts, ability to troubleshoot using explain plan, usage knowledge of SQL Tuning Advisor, SQL profiles, Stored outlines etc.3. Hand-on experience on performance tuning - troubleshooting using AWR & ASH reports, understanding of locks, latches, enqueues, predominant wait events etc.4. Good working knowledge of SQL commands, PLSQL and system packages.5. Good working knowledge on various Unix & Linux flavors and preferably also Windows.6. Good Analytical reasoning skills and lateral thinking capability.7. Fluent oral and written communication skills.8. Customer handling skills would be an added advantage.
As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our Electronic Support Services. A primary point of contact for customers, you are responsible for facilitating customer relationships with Support and providing advice and assistance to internal Oracle employees on diverse customer situations and escalated issues.
As a Principal Support Engineer, you will offer strategic technical support to assure the highest level of customer satisfaction. A primary focus is to create/utilize automated technology and instrumentation to diagnose, document, and resolve/avoid customer issues. You are expected to be an expert member of the technical problem solving/problem avoidance team, routinely sought after to address extremely complex, critical customer issues. Services may be frequently provided by on-site customer visits.
Leading contributor individually and as a team member, providing direction and mentoring to others. Work is non-routine and very complex, involving the application of advanced technical/business skills in area of specialization. 7 years experience with Core products or eight years experience with Applications products, BS Computer Science/Management Information Systems/Science/ Engineering/Math/Physics/Chemistry with 3.0 GPA OR (for Applications) proven professional/ technical experience, i.e., demonstrating an understanding of Applications at a functional and technical level (preferably Oracle).
Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans status or any other characteristic protected by law.