Principal Technical Support Engineer

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 server knowledge – Tomcat/Jetty/WebLogic basics, JVM memory/thread pools, logs, CPU/memory bottlenecks.
• Networking fundamentals – DNS, TLS/SSL overhead, load balancers, proxies, latency between app and DB tiers.
• Operating system basics – CPU, memory, disk I/O, file descriptors, process monitoring on Linux/Windows servers.
• Cloud / OCI awareness – compute, storage, autoscaling, networking, observability tools.
• Troubleshooting methodology – isolate DB vs app vs network, reproduce issues, compare environments, baseline vs current state.
• Ability to learn and use new AI and ML tools
• Programming in C or Java
Nice to have certifications: OCI (Oracle Cloud Infrastructure), APEX, AI Foundation

Personal competencies

• Desire to learn and continually expand knowledge in Database Options and Cloud Technologies
• Customer focus - Recognize customer urgency and the business impact/sensitivity of issues and provide timely, effective technical solutions
• Structured Problem Recognition and Resolution
• Experience of contributing to a shared knowledge base
• Experience of Support level work, like resolving customer problems, managing customer expectations, escalations and work under pressure
• Excellent Communication skills – Verbal and Written
• Planning and organizing
• Working Collaboratively and globally
• Relentless pursuit of Quality work
• Team Working and Results oriented
• Flexibility to work in different shifts and off days, including holidays and weekends.