Principal Technical Support Engineer

Job description

Responsibilities As a member of the Database 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. - Due to specific client contract requirements, this position requires that the successful candidate be a U.S. citizen Technical Skills: - Strong Oracle Database fundamentals – SQL tuning, indexing, execution plans, statistics, sessions, waits, locking, transactions, PL/SQL knowledge. - Strong understanding of Performance Tuning methodologies including SQL Tuning - ORDS architecture knowledge – connection pools, standalone/Tomcat deployment, REST calls, session management, request timeouts, logging. - REST/API performance basics – HTTP latency, payload size, concurrency, network round trips, JSON processing overhead. - APEX skills – Working knowledge of APEX e.g., creating pages, region/report optimization, Interactive Reports/Grids tuning, session state management, PL/SQL process efficiency, static file optimization. - SQL Developer skills – query tuning, worksheet/session behavior, client-side fetch settings, connection issues, data model/browser performance. - Middleware / Web ser...