SPMO PPM Database Administrator
About The Position
As a Primavera P6 EPMM Administrator, you will manage the Oracle P6 Enterprise Project Portfolio Management (EPPM) system, focusing on installation, configuration, security, backups, performance tuning, and user support. You will act as the bridge between P6 application users and core IT, ensuring data integrity and system availability for project managers/schedulers. This will include system health monitoring, tuning for speed, managing access rights, disaster recovery, and assisting users, having a strong Oracle/SQL knowledge. You will report to the Senior Manager, SPMO PM Systems, Operations and Analytics. This is a remote role that can be performed from anywhere in the United States.
Requirements
- 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 EPMM 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.
Responsibilities
- System Administration & Configuration: Install, configure, upgrade, and maintain Primavera P6 EPMM 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.
- Performance Tuning: Monitor database performance, optimize configurations, and tune for speed.
- Security & Access: Manage user access, set permissions, and implement security policies.
- Backup & Recovery: Develop and execute backup/restore plans, ensuring data recovery.
- User Support: Act as the first point of contact for P6 users, providing training, mentoring schedulers, project managers and planners, and troubleshooting. Promote best practices in schedule management and system usage.
- Documentation: Maintain standards, procedures, and system configurations.
- Collaboration: Work with IT, developers, and Primavera support for seamless operations. Liaise with Oracle support for escalated issues and patch management.
- Data Management and Integration: Ensure data integrity across projects and portfolios. Develop and maintain integrations with other enterprise systems.
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
5,001-10,000 employees
