[Remote] SPMO PPM Database Administrator
Note: The job is a remote job and is open to candidates in USA. Westinghouse Electric Company is a global leader in the nuclear energy industry, committed to providing safe and clean energy solutions. They are seeking a Primavera P6 EPMM Administrator to manage the Oracle P6 Enterprise Project Portfolio Management system, focusing on installation, configuration, security, and user support while ensuring data integrity and system availability.
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
Skills
- 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
Company Overview
Company H1B Sponsorship