[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.ResponsibilitiesSystem 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 UDFsPerformance Tuning: Monitor database performance, optimize configurations, and tune for speedSecurity & Access: Manage user access, set permissions, and implement security policiesBackup & Recovery: Develop and execute backup/restore plans, ensuring data recoveryUser 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 usageDocumentation: Maintain standards, procedures, and system configurationsCollaboration: Work with IT, developers, and Primavera support for seamless operations. Liaise with Oracle support for escalated issues and patch managementData Management and Integration: Ensure data integrity across projects and portfolios. Develop and maintain integrations with other enterprise systemsSkillsBachelor's degree in Computer Science, Engineering, Construction Management, or related field7+ years experience managing P6 Primavera applications and project management scheduling support5+ 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 supportDeep understanding of Oracle RDBMS, including installation, configuration, patching, performance tuning, and backup/recoveryAdvanced SQL scripting for complex queries, reports, and PL/SQL for automation; strong scripting (e.g. Shell, Python) for efficiencyExperience tuning the P6 database (EPPM/PPM) for optimal performance, especially during cleanup and resource-intensive tasksExperience implementing security, managing user access, and ensuring data integrity within the P6 environmentBenefitsComprehensive Medical benefits which could include medical, dental, vision, prescription coverage and Health Savings Account (HSA) with employer contributions optionsWellness Programs designed to support employees in maintaining their health and well-being including Employee Assistance Program providing support for our employees and their household members401(k) with Company Match Contributions to support employees' retirementPaid Vacations and Company HolidaysOpportunities for Flexible Work Arrangements to promote work-life balanceEducational Reimbursement and Comprehensive Career Programs to help employees grow in their careersGlobal Recognition and Service Programs to celebrate employee accomplishments and serviceEmployee Referral ProgramCompany OverviewWestinghouse Electric Company provides innovative and secure nuclear technology solutions. It was founded in 1886, and is headquartered in Cranberry, Pennsylvania, USA, with a workforce of 5001-10000 employees. Its website is http://www.westinghousenuclear.com.Company H1B SponsorshipWestinghouse Electric Company has a track record of offering H1B sponsorships, with 1 in 2025, 2 in 2023, 1 in 2022, 2 in 2021, 4 in 2020. Please note that this does not guarantee sponsorship for this specific role.