Role Overview
The selected candidate will be responsible for creating and updating request types, workflows, validations, and forms within PPM tools, configuring dashboards and analytical reports, managing user access and roles, and ensuring system integrity. Additionally, the role involves developing PL/SQL packages, procedures, functions, triggers, and database objects, optimizing SQL queries, and building logical views for reporting platforms such as Spotfire.
Key Responsibilities
- Configure and maintain PPM modules including dashboards, KPI views, and reports.
- Manage PPM user roles, security settings, and access permissions.
- Troubleshoot functional and technical issues within PPM processes.
- Develop and enhance PL/SQL packages, procedures, functions, triggers, and tables.
- Optimize SQL queries for improved performance and reliability.
- Create and maintain logical views and data models for BI reporting tools.
- Support integration between PPM and other enterprise systems.
- Collaborate in Agile environments, participate in daily scrums, and deliver solutions on schedule.
Technical Proficiencies
- PL/SQL programming including packages, procedures, functions, and triggers.
- Oracle SQL development and optimization.
- Spotfire reporting and logical views creation.
- Performance tuning for database operations.
Core Competencies
- Basic testing and debugging skills.
- Understanding of code and development tools.
- Knowledge of programming languages and version control systems.
