Job ID: IN-8755-1 (910790429)
PRIMAVERA Admin with ORACLE, MIGRATING, JAVA, Desktop/PC Support, SQL, SharePoint Designer/Infopath, Visual Studio and IIS experience
Location: COLUMBIA, SC
Duration: 12 months
Remote Work Availability:75%
REQUIRED SKILLS
Database PlatformsMS SQLYes1IntermediateCurrently Using1 – 2 Years
Desktop/PC Support•Ability to diagnose and troubleshoot computer and network problemsNo1IntermediateCurrently Using1 – 2 Years
Desktop/PC Support•Proficiency configuring and troubleshooting Windows operating systems in a client/server environmentNo1IntermediateCurrently Using1 – 2 Years
Packaged ApplicationsOracleYes1IntermediateCurrently Using1 – 2 Years
Programming LanguagesJavaYes1IntermediateCurrently Using1 – 2 Years
Software FramworkPrimaveraYes1IntermediateCurrently Using1 – 2 Years
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
EXPERIENCE IN DESIGN AND DEVELOPMENT OF PRIMAVERA P6
STRONG KNOWLEDGE OF PRIMAVERA P6 ARCHITECTURE
EXPERIENCE MIGRATING P6 SQL TO ORACLE 12.2
EXPERIENCE UPGRADING, INSTALLING, AND MIGRATING PRIMAVERA 16.6 TO PRIMAVERA 17.1
EXPERIENCE WITH MAINTAINING AND SUPPORTING ORACLE DATABASES, ANALYZATION AND CORRECTION OF ERRORS
TO MAXIMIZE AVAILABILITY AND UPTIME
EXPERIENCE WITH JAVA, ORACLE, SQL QUERIES, STORED PROCEDURES
UP-TO-DATE KNOWLEDGE OF RELATED INFRASTRUCTURE COMPONENTS AND/OR OPERATING ENVIRONMENT
STRONG KNOWLEDGE IN DIFFERENT KINDS OF DATABASE, SYSTEM INTEGRATIONS
VERBAL AND WRITTEN COMMUNICATION SKILLS, PROBLEM SOLVING SKILLS, CUSTOMER SERVICE AND INTERPERSONAL SKILLS
REQUIRED EDUCATION/CERTIFICATIONS:
B.S. COMPUTER INFORMATION SYSTEMS
B.S. COMPUTER SCIENCE
B.S. COMPUTER ENGINEERING
OR EQUIVALENT TRAINING REQUIRED
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
STRONG ANALYTICAL, COMPUTER, AND INTERPERSONAL SKILLS
STRONG ABILITY TO TROUBLESHOOT ISSUES AND MAKE SYSTEM CHANGES AS NEEDED TO RESOLVE ISSUE
STRONG KNOWLEDGE OF THE FULL SOFTWARE DEVELOPMENT LIFECYCLE: FROM BUSINESS/SYSTEMS ANALYSIS, THROUGH REQUIREMENTS GATHERING AND FUNCTIONAL SPECIFICATION AUTHORING, TO DEVELOPMENT, TESTING AND DELIVERY
BASIC ABILITY TO WORK INDEPENDENTLY AND MANAGE ONE’S TIME AS WELL AS BEING A COLLABORATIVE TEAM MEMBER
DAILY DUTIES / RESPONSIBILITIES:
MUST BE ABLE TO PROVIDE SUPPORT AND GUIDANCE TO P6 USERS, SCDOT IT SYSTEMS STAFF, SCDOT ENGINEERING STAFF AND WORK WITH THE ORACLE VENDOR AS NEEDED FOR APPLICATION ISSUES, DATABASE ISSUES, MAINTENANCE, INSTALLATIONS AND UPGRADES. ANALYZE USER REQUESTS AND SOFTWARE REQUIREMENTS FOR FEASIBILITY OF DESIGN AND POTENTIAL IMPACT. ASSIST MORE EXPERIENCED SYSTEM DEVELOPMENT/SUPPORT PERSONNEL IN DEVELOPING SOLUTIONS TO CUSTOMER RELATED REQUESTS AND/OR SYSTEM PROBLEMS.
WILL PROVIDE TRAINING AND MENTORING FOR EXISTING OR NEW USERS AS NEEDED ON HOW TO USE NEW SOFTWARE FEATURES OR UPDATES BY PHONE SUPPORT, VIRTUAL TRAINING OR CLASSROOM TRAINING.
Application/system and Database Infrastructure Standards
1.Microsoft IIS 8.5 native running in Windows Server 2012 R2 SP1 64bit
2.Microsoft SharePoint 2013.
3.Microsoft SQL Server 2014 R2 CU3 GDR2
4.Microsoft SQL Reporting Services 2014.
5.Oracle 12C
6.Oracle PL/SQL – 11G.
7.Oracle Weblogic Server 12C 122.1.2.0 (DMZ Only)
8.Oracle BI Discover V = 12C
Application/System Development Environment
1.Microsoft Visual Studio .NET (2015 or greater)
2.Microsoft InfoPath Designer (2013 or greater)
3.Microsoft SharePoint Designer (2013 or greater)
4.Authentication Method (Anonymous or Integrated Windows Only).
5.No applications can use local accounts.
6.No applications can be dependent on automatic server login. All such application needs will be deployed as a Service.
7.Microsoft ASP.NET Framework Version 4.5.
8.Do not include any Database (SQL or Oracle) configuration in build.
9.If a database connection string is included as part of the applications function, it must be encrypted in the (web.config) file. Encryption on first run is not acceptable.
10.Default document defined in package build.
11.All server reboots will occur after normal business hours.
12.All reports regardless of database format must leverage SCDOT’s SQL Reporting Services.
13.All SQL databases must be in SQL Server 2014 R2 native mode not compatibility mode.
Application/System Deployment Methods
1.SharePoint application/systems deployed using (.WSP) package.
2.InfoPath forms deployed using (.XSN) package.
3..NET applications deployed using Microsoft Installer (.ZIP) package. (Microsoft Web Deploy)
4.If a database connection string is included as part of the deployment package, it must be encrypted in the deployment package. Encryption on first run is not acceptable.
a.SharePoint applications requiring external database connections can use a Secure Store Application.