Oracle PL/SQL Developers

Roles and Responsibilities:

• Develop and maintain complex PL/SQL programs for high-volume OLTP and reporting applications
• Write and optimize advanced SQL and PL/SQL queries using collections and dynamic SQL
• Perform performance tuning of queries, procedures, and database objects
• Analyze execution plans, TKPROF, and AWR reports for optimization
• Design and implement database structures including partitioning and indexing
• Work on bulk data processing using collections and bulk operations
• Develop and manage data transfer mechanisms using flat files, DB links, and web services
• Implement materialized views for reporting and data aggregation
• Perform data modeling and database design for large-scale applications
• Troubleshoot and resolve production issues in fast-paced environments
• Collaborate with teams for performance improvements and database enhancements