oracle pl/sql developer
Core
Develop and optimize Oracle database solutions, focusing on complex PL/SQL programming and performance tuning.
Role type
Senior Oracle PL/SQL Developer
Builds
ERP and BI database components
Domain
Enterprise Resource Planning (ERP) and Business Intelligence (BI)
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Oracle PL/SQL programming, advanced PL/SQL (collections, Native Dynamic SQL), SQL (joins, functions, sub queries, Data Manipulation), Oracle performance tuning, execution plan analysis, TKPROF, AWR reports
Preferred skills
Oracle 11g or above experience
Technologies
Oracle 11g, TKPROF, AWR
Responsibilities
Write complex stored procedures, packages, and functions; Analyze and optimize database execution plans; Troubleshoot and resolve performance bottlenecks using TKPROF and AWR reports; Implement advanced SQL queries and data manipulation logic.
Seniority
Senior, hands-on IC
