Install, configure, upgrade, and maintain Primavera P6 EPPM and associated components (Web Access, Integration APIs, BI Publisher, etc.)
Configure global and project-specific settings including calendars, EPS/WBS structures, activity codes, and UDFs.
Monitor database performance, optimize configurations, and tune for speed.
Manage user access, set permissions, and implement security policies.
Develop and execute backup/restore plans, ensuring data recovery.
Act as the first point of contact for P6 users, providing training, mentoring schedulers, project managers and planners, and troubleshooting.
Maintain standards, procedures, and system configurations.
Collaborate with IT, developers, and Primavera support for seamless operations.
Liaise with Oracle support for escalated issues and patch management.
Ensure data integrity across projects and portfolios. Develop and maintain integrations with other enterprise systems.

Bachelor's degree in Computer Science, Engineering, Construction Management, or related field
7+ years experience managing P6 Primavera applications and project management scheduling support
5+ years' of demonstrated experience in Primavera P6 EPPM knowledge (schema, background jobs, administration guides) plus experience in Oracle Database skills (SQL, tuning, backup/recovery, security)
Proficiency in scripting (SQL, PL/SQL, Shell) for automation and understanding of P6's complex enterprise structure for project management support
Deep understanding of Oracle RDBMS, including installation, configuration, patching, performance tuning, and backup/recovery
Advanced SQL scripting for complex queries, reports, and PL/SQL for automation; strong scripting (e.g. Shell, Python) for efficiency
Experience tuning the P6 database (EPPM/PPM) for optimal performance, especially during cleanup and resource-intensive tasks
Experience implementing security, managing user access, and ensuring data integrity within the P6 environment

Comprehensive Medical benefits which could include medical, dental, vision, prescription coverage and Health Savings Account (HSA) with employer contributions options
Wellness Programs designed to support employees in maintaining their health and well-being including Employee Assistance Program providing support for our employees and their household members
401(k) with Company Match Contributions to support employees' retirement
Paid Vacations and Company Holidays
Opportunities for Flexible Work Arrangements to promote work-life balance
Educational Reimbursement and Comprehensive Career Programs to help employees grow in their careers
Global Recognition and Service Programs to celebrate employee accomplishments and service
Employee Referral Program

SPMO PPM Database Administrator

Key skills