
SPMO PPM Database Administrator
Westinghouse Electric Company
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $90,000 - $112,500 per year
About the role
- 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.
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 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
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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Primavera P6 EPPMOracle DatabaseSQLPL/SQLShell scriptingPython scriptingdatabase performance tuningbackup and recoverysecurity managementdata integrity
Soft Skills
trainingmentoringtroubleshootingcollaborationcommunication
Certifications
Bachelor's degree in Computer ScienceBachelor's degree in EngineeringBachelor's degree in Construction Management