JP1427 - Computing Systems Professional 3
Summary:
Provides advanced technical support services; designs, specifies, and develops solutions for complex heterogeneous computing infrastructure. Performs research and development to identify and implement applicable emerging technologies in the Laboratory computing environment. Utilizes formal project management methodologies; gathers customer requirements; performs risk management functions; performs capacity and availability planning for computing infrastructure; performs effective communication both, verbal and written, at all levels.
Has wide-ranging experience, uses professional concepts and Laboratory objectives to resolve complex issues in creative and effective ways. Frequently contributes to the development of new theories and methods. Considered expert in field within the organization. Develops resolutions to complex problems that require the frequent use of creativity and where analysis of situations or data requires an in-depth evaluation of variable factors. Work is accomplished without considerable direction. May coordinate activities of other personnel. Exerts significant latitude in determining objectives of assignment, and determines the methods and procedures needed for new assignments.
Education:
Position typically requires a bachelors degree and a minimum of eight years related experience, or an equivalent combination of education and experience. At this level, applicable advanced vendor and/or professional certification is desirable.
Additional Job Requirements:
Position Description: SQL Script Writer, fluent in scripting to the Oracle Primavera P6 schema.
The key skill for this role is in SQL Script writing and editing, typically performed by a computer science professional trained for this role, who is facile with SQL scripting means and methods, 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. The SQL script writer shall be a part of the PMRC-IT Group at Los Alamos National Laboratory’s Project Management Resource Center that administers a large P6 user community, and will use their skills to assist in the configuration and operation of Oracle’s Project Integration Interface (PIF), being deployed to manage global- and project-level P6 data. This SQL script writer should be fluent in writing in SQL+ and suitable IDEs such as TOAD and experienced in querying Oracle databases loaded with Oracle’s Primavera P6 schema. To be clear, this role description is not the equivalent of a P6 Principal Application Administrator (P6 PA)—it is a distinctly different skillset.
Skills, Experience, Qualifications:
• 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 programming P6 Web services and P6’s Java API (the latter of which is pending deprecation)
Work Location: Must live within 2 hour commuting distance to Los Alamos National Laboratory or be willing to relocate.
COMPA is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, national origin, sexual orientation, disability, or protected Veteran status.
COMPA's policy could disqualify an applicant who has certain criminal history from employment in particular positions .