[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