Oracle PL / SQL Developer with Performance Tuning experience
Core
Develop and optimize Oracle database solutions, focusing on complex PL/SQL programming and performance tuning for ERP and BI systems.
Role type
Senior Oracle PL/SQL Developer
Builds
ERP and BI database applications
Domain
Enterprise Resource Planning (ERP) and Business Intelligence (BI)
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Oracle PL/SQL programming, SQL query optimization, execution plan analysis, TKPROF reporting, AWR report analysis, stored procedures, packages, functions, collections, Native Dynamic SQL
Preferred skills
Oracle 11g or above expertise
Technologies
Oracle 11g, TKPROF, AWR
Responsibilities
Write complex PL/SQL code including procedures, packages, and functions; Analyze and optimize database performance using execution plans and reports; Implement advanced features like collections and Native Dynamic SQL; Develop efficient SQL queries with joins, subqueries, and data manipulation.
Seniority
Mid-Senior, hands-on IC