Oracle Primavera Developer

Job Summary:

We are seeking a highly skilled Oracle Primavera Developer to join our team. The ideal candidate will be responsible for developing, enhancing, and maintaining Primavera P6 EPPM (Enterprise Project Portfolio Management) solutions. The role will involve integrating Primavera with other enterprise systems, creating custom reports, optimizing performance, and ensuring the system meets business requirements for project management and scheduling.

The candidate should possess deep expertise in Primavera P6 APIs, Oracle databases, PL/SQL scripting, and related technologies, with a strong understanding of project controls, scheduling, and portfolio management processes.
Key Responsibilities:

• Develop, configure, and maintain Primavera P6 EPPM applications, including custom workflows, reports, and dashboards.
• Build integrations between Primavera and ERP systems, financial systems, and other project management tools.
• Develop custom reports and data extracts using SQL, PL/SQL, BI Publisher, and Oracle Reports.
• Work with business analysts, project managers, and stakeholders to gather and translate requirements into technical solutions.
• Enhance and optimize Primavera P6 databases, ensuring high performance and data integrity.
• Customize Primavera Global Data, Activity Codes, UDFs (User Defined Fields), and security configurations as per project needs.
• Develop and maintain Primavera Web Services, REST APIs, and SOAP APIs for custom integrations.
• Perform system upgrades, patches, and migrations while ensuring system stability.
• Provide technical troubleshooting and support to resolve issues related to Primavera functionality, performance, and data accuracy.
• Work closely with infrastructure teams to monitor system health and ensure optimal performance of the Primavera application servers.
• Develop data validation scripts to ensure data consistency between Primavera P6 and other enterprise systems.
• Collaborate on Primavera cloud migration initiatives (if applicable).
• Maintain technical documentation, including data models, integration diagrams, and configuration guides.

Required Skills & Qualifications:

• 5+ years of experience working with Oracle Primavera P6 EPPM (Web and Client) as a developer.
• Expertise in Primavera P6 APIs (Web Services, REST, SOAP).
• Strong hands-on experience in Oracle SQL, PL/SQL, stored procedures, triggers, and performance tuning.
• Experience in customizing Primavera P6 layouts, dashboards, and reports.
• Strong understanding of Primavera P6 data structures (projects, activities, WBS, resources, calendars, baselines, etc.).
• Experience with integrating Primavera P6 with ERP, financial, or document management systems.
• Hands-on experience with Oracle BI Publisher or other reporting tools for Primavera reports.
• Experience in developing and enhancing user-defined fields (UDFs) and Global Data in Primavera.
• Experience with Primavera Administration (Global Security Profiles, OBS, EPS setup).
• Familiarity with Primavera Gateway and Primavera Unifier is a plus.
• Experience working in a multi-project environment with complex schedules and cost controls.
• Solid understanding of project controls processes - scheduling, cost management, and reporting.

Desired Skills:

• Knowledge of Primavera Cloud (P6 Cloud Service).
• Experience with Primavera Unifier customization and integrations.
• Experience with data migrations from legacy project management systems to Primavera.
• Familiarity with Oracle Cloud Infrastructure (OCI) and managing Primavera on OCI.
• Knowledge of construction, engineering, or capital projects environments.
• Experience working with Agile or hybrid project delivery methodologies