USA Jobs, Careers and Recuitements
Job Target Job Search

Contact Information

Contact Name: DAVE

Job Details: Oracle Database Architect Date: Aug 12 2019

Job Reference: 2517
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Recruiter
Employment type: Contract
Degree: High School
Experience: 3 years
Location: Harrisburg, Pennsylvania, 17103
Job Skills: Oracle Database Architect
Share Job with Others

Job Tools

Job Description

Direct End Client: State of Pennsylvania
Job Title: Oracle Database Architect
Duration: 12 months with high possibility with extension
Start Date: ASAP
Location: Harrisburg, PA
Position Type: Contract
Interview Type: Either Go To Meeting/ Web Cam or In Person interview

• Project Mgmt/Project Lead experience (Required 5 Years)
• Oracle Database (11G and prior) (Required 5 Years)
• SQL*Plus (Required 7 Years)
• PL/SQL (Required 5 Years)
• Oracle Developer Suite (or previous) (Required 5 Years)
• TOAD or SQL Developer (or equivalent) (Required 5 Years)
• Entity Relationship Modeling (Required 5 Years)
• Experience creating web services (Required 2 Years)
• Oracle Forms (10G or greater) (Required 5 Years)
• Strong Communication skills (Required)
• Oracle Reports (9i or greater) (Desired 3 Years)
• Microsoft Team Foundation Server (Desired 2 Years).

Client system is an Oracle web form based application that uses an Oracle 11G DB as the back end. It provides a holistic view of the clients and sites (including facilities) that client regulates. In addition it tracks the various functions that support client regulations such as compliance activities, bonding, fees, certifications, authorizations/licenses/permits, etc.

Clients system is a complex system encompassing thousands of business rules. There are over 2000 users from all facets of the department, plus several external users. It provides for basic data entry roles, application processors, compliance specialist, bonding, certification, etc.

The client’s system has over 140 Oracle Forms, over 2500 tables in its main schema, and over a thousand other tables, views indexes for interfacing with integrated systems.

These individuals will be utilized to support the existing system, implement enhancements for the various program areas, assist in upgrades and architectural changes, and provide mentoring and support to client staff.

These positions may be involved in any or all facets of developing application system such as defining user requirements, system impacts, analysis, coding, testing, deployments, documentation, etc.


• Understand the inner workings of the client system Application and other Oracle system.
• Understand the roles, security and authorization within the client and integrated systems.
• Provide maintenance and support to client and other Oracle, integrated systems
• Review selected documentation of the existing systems to become familiar with the system requirements, functionality, and architecture, reporting, etc.
• Meet with end-users on new system requirements
• Generate Requirements, Technical and Business Functional documents, system documents, and assist in creating training and testing documents.
• Profile and tune selected pieces of the system for better maintainability and performance as necessary.
• Provide mentoring and assistance as required for the transfer of knowledge to other developers and Commonwealth IT staff.
• Aid in production deployments of systems.
• Provide weekly status updates to BIT team manager or other client managers as requested.
• Generate reports as needed for executive management, end-users, and BIT staff.

Copyright © 2019 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.