SMSI, LLC provides expert management consulting, program and project management, and technical consulting services to government and private sector clients. A small business founded in 2008, SMSI has built an outstanding reputation for client-focused performance and for delivering results that enable clients to meet commitments and milestones.

EOE/AA - M/F/Vet/Disability/Drug-Free Workplace

Los Alamos National Laboratory requires all on-site personnel to be fully COVID vaccinated to be considered for this position

SQL Script Writer, fluent in scripting to the Oracle Primavera P6 schema

Primary Duties and Responsibilities:

• 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 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.

  That said, 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 programming P6 Web services and P6 s Java API (the latter of which is pending deprecation)

Required Experience/Qualifications:

• Minimum experience in this role: 5 years
  
• DOE Q clearance preferred

• Must live within commuting distance of Los Alamos National Laboratory or be willing to relocate there

Education:

• Bachelor s degree

All candidates must posses:

• US Citizenship
• Ability to pass pre-employment drug screening
• Excellent written and verbal communication skills
• Excellent organizational skills
• Capability with MS Office Suite
• Excellent interpersonal skills and ability to interface with clients, contractors, and consultants on a day-to-day basis.

Benefits:

• Excellent Salary
• 401(k)
• Generous Paid Time Off
• Medical Coverage
• Dental Coverage
• Vision Coverage
• Life Insurance
• Disability Insurance
• Other Benefits