SPMO PPM Database Administrator

Westinghouse Electric Company; Cranberry Township (Butler County); On-site; USD 90,000 - 112,500; Full time

Benefits offered by this job

Comprehensive Medical benefits

Wellness Programs

401(k) with Company Match

Job summary

Westinghouse Electric Company seeks a Primavera P6 EPPM Administrator to manage the Oracle P6 EPPM system, including installation, configuration, security, backups, and performance tuning. You will bridge P6 users with IT, ensuring data integrity and system availability for project managers and schedulers.

The role reports to the Senior Manager, SPMO PM Systems, Operations and Analytics. This is a remote position, eligible to be performed from anywhere in the United States.

Qualifications

• Bachelor's degree in CS, Engineering, Construction Management or related field.
• 7+ years experience managing P6 Primavera applications and project management scheduling support.
• 5+ years' of P6 EPPM knowledge plus Oracle Database skills (SQL, tuning, backup/recovery, security).
• Proficiency in scripting (SQL, PL/SQL, Shell) for automation and understanding of P6 enterprise structure.

Responsibilities

• Install, configure, upgrade, and maintain Primavera P6 EPPM and components (Web Access, Integration APIs, BI Publisher).
• Configure global and project-specific settings including calendars, EPS/WBS structures, activity codes, and UDFs.
• Performance tuning: monitor DB performance, optimize configs, tune for speed.
• Security: manage user access, permissions, and security policies.
• Backup & recovery: develop and execute backup/restore plans.

Skills

Oracle P6 EPPM

SQL

PL/SQL

Shell scripting

Oracle Database

Backup & Recovery

Performance Tuning

Security & Access

System Administration

Education

Bachelor's degree in CS/Engineering/Construction Management

Tools

Web Access

BI Publisher

Job description

Are you interested in being part of an innovative team that supports Westinghouse's mission to provide clean energy solutions? At Westinghouse, we recognize that our employees are our most valuable asset and we seek to identify, attract and recruit the most qualified talent while recognizing and encouraging the value of diversity in the global workplace.

About the role

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.

Key Responsibilities

• System Administration & Configuration: 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.
• 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.

Qualifications

• 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.

We are committed to transparency and equity in all of our people practices. The base salary range for this position, which is dependent upon experience, qualifications and skills, is estimated to be $90,000.00 to $112,500.00 per year.

#LI-Remote

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

Westinghouse is an Equal Opportunity Employer including Veterans and Individuals with Disabilities.