Oracle-certified Database Administrator (Oracle DBA)

Oracle-certified Database Administrator (Oracle DBA) to support deployments of P6 EPPM on Oracle databases
Minimum experience in this role: 5 years 
Must live within commuting distance of Los Alamos National Laboratory or be willing to relocate there

Oracle DBAs in Los Alamos National Laboratory’s Project Management Resource Center-IT Group create and maintain multiple Oracle Databases running Oracle Primavera P6 PPM and EPPM; therefore, familiarity with Oracle databases hosting P6 schema for the stated duration of experience, at a minimum, is required. It is expected that the candidate shall be proficient in SQL scripting to the extent required to support Oracle DBA responsibilities, and is diligent when it comes to remarking script they create, such that others can readily understand the intent, technique and steps that were used to achieve the working result. For this role, the qualified Oracle Database Administrator is not to be confused with a P6 Principal Application Administrator (P6 PA) )—it is a distinctly different skillset.

Plus-factors impacting the candidate’s evaluation may include:

• An overlap of skills and qualifications, to include the skills required for a P6 PA, which can be beneficial in performing in the SQL script writer’s role
• Knowledge of P6’s business rules, both as expressed in P6’s UI and controlled in the P6 schema in the Oracle database by stored procedures and the relational structure
• Knowledge of P6 configuration at the application level (Global Data Structures et al) to support project operations in the context of DOE business operations
• Familiarity with Oracle Weblogic installation and maintenance
• Familiarity with programming P6 web services and the Java API (the latter of which is pending deprecation)