Overview
Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
No Travel Required
Unable to Provide Sponsorship
Skills
Management
Documentation
Extract, Transform, Load
Functional Design
Hyland OnBase
ADO
Agile
Business Intelligence
Cloud Computing
Microsoft Azure
Microsoft SQL Server
Microsoft Visio
Migration
IT Architecture
Impact Analysis
Legacy Systems
Microsoft Access
Roadmaps
SAP BASIS
Scrum
Software Modernization
Product Design
Product Planning
Product Support
System Testing
Test Scenarios
Training
Transact-SQL
Proxies
SQL
Staff Augmentation
Stored Procedures
Taxonomy
UI
Usability
User Stories
Job Details
The Product Specialist is the expert for a technical development or execution environment product or set of products. The primary responsibility of a Product Specialist is to ensure the availability and facilitate the productive use of a product for Application Teams or end users. The Product Specialist may own part of a product, all of one, or several products depending on the nature of the product(s) and their use. The Product Specialist requires significant to expert experience and skills in the product supported. The Product Specialist is responsible for collaborating with Technical Architecture Specialist, System Specialists, Programmers and vendors to ensure and enhance the use of the product and effect migration to new versions of a product.
• Responsible for functioning as the Technical SME on an enterprise-wide system.
• Responsible for implementations of products/services
• Provide direct technical expertise to Executive applications involving national security
• Make sound recommendations on functional and technical improvements to the product.
• Analyze the functional and technical impact of product planning decisions.
• Develop appropriate functional and usability standards for products.
• Track and document expected volume and type of use of the product.
• Participate in product design reviews to verify that design meets quality standards and functional/technical requirements.
• Perform impact analyses on production fixes and enhancements to establish priorities.
• Provide basic product support and provide accurate and complete answers to detailed product questions in a timely manner.
• Provide effective on-site product support as needed.
• Accurately sets severity of identified defects.
• Provide input to training and / or documentation materials regarding latest technical and functional design changes.
• Document all work for future reference.
• Review the system test approach and conditions used as the basis for detailed test scenarios.
Background:
• RICS: Relationally Integrated Computer System (RICS) application modernization for the Division of Oil & Gas Resources Management (DOGRM) well information system is currently a Microsoft Access user interface with a SQL Server backend (known as RBDMS) that is to be converted to a web-based application hosted within the Azure cloud.
• RBDMS? As noted above, the legacy system is a Microsoft Access user interface with a SQL Server backend. This system is still in operation and DOGRM needs a staff augmentation that will work with the internal users to define a roadmap to sunset the legacy system.
Deliverables/Goals
1) Evaluate, identify, and resolve the current bi-direction sync issues between the RICS system tables and data fields and the RBDMS tables and data fields.
2) Create roadmap to sunset active RBDMS functionality being used by DOGRM program areas.
3) Act as a proxy Product Owner with RICS vendor through attending standups, defining features, user stories and acceptance criteria requirements in Azure ADO for development of approved RICS enhancements.
4) Assume lead role working with business leads to test and validate RICS developed enhancements.
5) Manage existing OnBase taxonomy including identifying and submitting additional new OnBase document groups and document types as required.
Skills Table:
Skill
Required / Desired
Amount
of Experience
Experience with MS-Access & SQL Server (TSQL) development
Required
7
Years
Experience with creating Stored Procedures and Triggers to assist with creating bi-directional sync between RICS and JMT.
Required
7
Years
Experience creating SQL queries to perform data clean up or orphan data
Required
7
Years
Experience creating ETL process between systems
Required
7
Years
Ability to resolve OnBase issues when transferring legacy documents (RBDMS) into OnBase with RICS taxonomy
Required
5
Years
3+ Years experience one who has live the Agile/SCRUM software methodology
Required
3
Years
Document all requirements in ADO
Required
Someone who can use Visio to document the sync process
Required
Question
Please provide your candidate’s physical residence (City, State).
Question
This is a hybrid role, and will require onsite work at 2045 Morse Rd., Bldg. F, Columbus, OH 43229. Does your candidate accept.
Question
Selected candidate will be required to have a Federal/BCI Fingerprint check performed. Does your candidate agree?
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.