SPMO PPM Database Administrator

This is a fully remote position, open to applicants in United States.

📋 Description

• Install, configure, upgrade, and maintain Primavera P6 EPPM along with its associated components, such as Web Access, Integration APIs, and BI Publisher.

• Set up global and project-specific configurations, including calendars, EPS/WBS structures, activity codes, and UDFs.

• Monitor database performance, optimize configurations, and fine-tune for enhanced speed.

• Oversee user access, establish permissions, and enforce security policies.

• Develop and implement backup and restore plans to ensure effective data recovery.

• Provide primary support, training, mentoring, and troubleshooting assistance for P6 users, schedulers, project managers, and planners.

• Advocate best practices in schedule management and system utilization.

• Maintain standards, procedures, and system configurations.

• Collaborate with IT, developers, Primavera support, and Oracle support teams on operational issues, escalated matters, and patch management.

• Ensure data integrity is upheld across projects and portfolios.

• Create and uphold integrations with other enterprise systems.

• Report directly to the Senior Manager, SPMO PM Systems, Operations, and Analytics.

⛳️ Requirements

• Bachelor’s degree in Computer Science, Engineering, Construction Management, or a related discipline.

• Over 7 years of experience managing P6 Primavera applications and providing project management scheduling support.

• At least 5 years of proven expertise in Primavera P6 EPPM, including schema, background jobs, and administrative guides.

• Proficiency in Oracle Database, including skills in SQL, tuning, backup/recovery, and security.

• Strong knowledge in SQL, PL/SQL, and Shell scripting for automation purposes.

• Familiarity with P6's intricate enterprise structure for project management support.

• Extensive understanding of Oracle RDBMS, covering installation, configuration, patching, performance tuning, and backup/recovery.

• Advanced skills in SQL scripting for complex queries and report generation.

• Experience with PL/SQL automation and scripting languages like Shell or Python.

• Proven experience in tuning the P6 database (EPPM/PPM), particularly during cleanup and resource-intensive operations.

• Experience in implementing security measures, managing user access, and ensuring data integrity within the P6 environment.

🏝️ Benefits

• Comprehensive medical benefits, which may include medical, dental, vision, and prescription coverage, along with Health Savings Account (HSA) options featuring employer contributions.

• Wellness Programs, including an Employee Assistance Program available for employees and their household members.

• 401(k) plan with Company Match Contributions.

• Paid vacations and company holidays.

• Flexible work arrangements.

• Educational reimbursement and extensive career development programs.

• Global recognition and service programs.

• Employee Referral Program.