About this role

Design, write, and maintain robust, high-performance Oracle PL/SQL stored procedures, packages, functions, and triggers
Architect and implement complex application business logic directly within the database layer for data integrity and speed
Diagnose, troubleshoot, and optimize slow-running SQL queries, execution plans, and PL/SQL blocks using tools like TKPROF, EXPLAIN PLAN, and AWR reports
Collaborate with software engineering teams to design efficient relational database schemas, tables, views, and indexes
Partner closely with backend developers to align database-level business logic with application-level APIs and services
Review database code generated by application developers to ensure adherence to performance standards and best practices

Deep, hands-on experience with Oracle Database versions (e.g., 19c / 21c)
Mastery of advanced PL/SQL concepts including collections, bulk binds (FORALL, BULK COLLECT), ref cursors, and analytical functions
Proven track record of resolving database bottlenecks, optimizing indexes, partitioning tables, and rewriting inefficient queries
Strong understanding of database internals, locking mechanisms, concurrency, and session management
Proficiency with database management tools such as Oracle SQL Developer, PL/SQL Developer, or Toad
Valid and unrestricted U.S. work authorization

Oracle Database Developer

Key skills