As an Oracle Developer, you will design, develop, and maintain Oracle-based applications to meet business requirements and enhance system functionality. You will work on optimizing SQL queries, developing reporting solutions, and collaborating with stakeholders to ensure seamless implementation of technical specifications.
Primary Responsibilities
- Design, develop, and optimize PL/SQL and SQL applications and database objects (tables, views, stored procedures).
- Ensure optimal performance and resource utilization by fine-tuning SQL queries.
- Develop reports, dashboards, and data visualizations using Oracle ADW, OAC, FDI, and Microsoft Excel/PowerPoint.
- Translate business requirements into technical specifications for reporting solutions.
- Work with technical and functional teams to deliver reporting and analytics solutions.
- Participate in daily stand-ups, sprint planning, and retrospectives. Use Jira for task tracking.
- Troubleshoot and resolve Oracle application and reporting issues.
- Document technical and functional solutions for knowledge transfer.
Required Experience
- Proven experience in Oracle application development with PL/SQL and SQL.
- Strong knowledge of SQL query optimization, database design, and data security in Oracle.
- Experience with Oracle ADW, OAC, and FDI.
- Proficient in reporting, dashboards, and data visualizations.
- Familiarity with agile methodologies and Jira.
- Experience with Oracle Cloud environments.
- Strong communication skills for both remote and in-person interactions.
- Knowledge of Oracle E-Business Suite or similar Oracle applications is a plus.