R+L Carriers

Software Engineer

• Develop PL/SQL packages, stored procedures, functions, triggers, and SQL statements in Oracle 19c
• Perform performance tuning by optimizing SQL code and PL/SQL packages
• Maintain shared tooling, including PL/SQL packages that facilitate partitioning and purging
• Perform index-based optimization, including statistics gathering and execution-plan optimization
• Use Oracle Enterprise Manager (Cloud Control) to monitor and optimize SQL statements
• Improve application architecture to prevent deadlocks in highly concurrent applications
• Monitor and reduce SQL plan degradation
• Implement SQL profiles and SQL plan baselines to help resolve critical production issues
• Provide mentoring and support to Oracle developers

Developer, Oracle