Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
Sql Server 2000 Excel SQL Scripting Administrator
(Jobs in Dauphin County, PA)
 
Requirement id 6372
Job title Administrator
Job location in Dauphin County, PA
Skills required Data Analysis, Oracle 9G, Sql Server 2000, Excel SQL Scripting
Open Date 31-Aug-2011
Close Date
Job type Contract
Duration 2 Months
Compensation DOE
Status requirement ---
Job interview type Face to Face interview
Apply
   Email Recruiter: CoolReks Coolsoft
Job Description Administrator: Data Analysis, Oracle 9G, Sql Server 2000, Excel SQL Scripting

Complete Description:
The DCNR maintains a numbers of wells databases, which need to be more aligned. Because these are disparate systems running independent of each other, there is no way to have a global view of all wells in the Commonwealth, either from a reporting or mapping perspective. There are a number of data quality issues. This is particularly true of water well data. A number of wells share the exact same location coordinates. Quite a few wells have no location coordinates. The Well Iinformation System utilizes a database that stores the same information in multiple locations within the database. Hence, this resource will need to aid DCNR in bringing this data more into alignment.

The wells applications have an unsatisfactory reporting mechanism. The Bureau is repeatedly asked to provide data to external stakeholders because the data extraction and reporting mechanism in place does not provide the information required by the stakeholders. Poor data conditions are contributing to this issue.

There is a lack of integration of images and data. For oil/gas wells, the images are stored in a system separate from the data. This requires the user to either print the image or to navigate between systems to view the data in both places.

For this assignment, DCNR is looking for skilled data dictionary analysis and design and data model analysis design.
Familiarize and then maintain T&G well databases.
Responsible for data dictionary backup and recovery.
Responsible for applying current or creating needed new definition of standards of well data dictionaries.
Perform performance tuning.
Monitor database performance and space requirements.
Schedule and monitor end of day jobs.
Assist in coordinating software releases.
Communicate accurate and useful status updates.
Manage and report time spent on all work activities.
Follow quality standards.
Ability to work in a team environment
Complete assigned tasks.
Strong communication skills; both written and spoken.

Business systems analysis and design experience.
Logical data modeling techniques.
Production environment Tools/Utilities.
Knowledgeable in data analysis and database management techniques.
Scripting for data cleanup and alignments.
Execution of all responsibilities with little direct supervision of project manager.
Administration and scripting experience in relative platform.
Author shell scripts to perform back up, restore, and monitoring tasks.
Anticipate and resolve issues specific to the team.
Determine time estimates and schedule for own work and resolve issues in a timely manner.
Identify and track issues, risks and action items.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 6372 while calling.
 
Other jobs in PA: Dauphin (1), Dauphin County (3), Downingtown (2), Glen Milla (1), Harribsurg (1), Harrisburg (47), Horsham (6), Malvern (2), Pennsylvania (13), Phila (2), Philadelphia (16), Pittsburgh (1), Radnor (2), Reading (1), Sharon (3), WAYNE (1), West Cheste (1), West Chester (33),
 
 Data Analysis job openings in other states
Jobs List

Quality Assurance Analyst II - 148940
Create date: 29-Sep-2025
Start Date :10/27/2025
End Date :06/30/2026

Submission Deadline :10/6/25 at 4:00 PM CST

Client Info : DHS

Note:

* Onsite or Remote? Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense.

* Position is 100% remote within the state o.... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI))

Mainframe Developer Intermediate - 64848
Create date: 15-Sep-2025
Start Date :10/6/2025
End Date :10/31/2026

Submission Deadline : 09/19/2025

Client Info : Ne TRANS

Note :

* Position Location: On Site

* Candidate Must Be Local

* Local candidates preferred for onsite work in Lincoln, Nebraska (or must be willing to relocate).... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE))

DOAS HCM Training Specialist (774896)
Create date: 13-Aug-2025
Start Date :8/25/2025
End Date :04/30/2026

Submission Deadline :08/18/2025

Client Info : DOAS

Note:

* Agency Interview Type: Either Web Cam or In Person

* LOCAL CANDIDATES ONLY: DOAS participates in a hybrid work environment and telework is encouraged with some days in.... (This job is for - job Jobs in GA Atlanta Specialist - (in Atlanta, GA))

VSP - Help Desk Analyst 4 - (774531)
Create date: 08-Aug-2025
Start Date :9/1/2025
End Date :06/30/2026

Submission Deadline :08/13/2025

Client Info : VSP

Note:

* Please Submit your Best two candidates

* Candidates must be able to work on site.

* Local Candidates Strongly Preferred.

* Please submit your top .... (This job is for - job Jobs in VA NorthChesterfield Analyst - (in North Chesterfield, VA))

Business Analyst/Consultant IV - 143210
Create date: 30-May-2025
Start date : 07/28/2025

End Date : 06/30/2026

Submission deadline : 6/6/2025 4:00:00 PM

Client Info : ETF

Note:

* Interview Process: remote via MS Teams

* Duration: 6/30/2026, likely to extend

* Onsite or Remote? Must be a current WI resident. This position can work .... (This job is for - Stakeholders Jobs in WI Madison Analyst - (in Madison, WI))
 
 Data Analysis job openings in PA
Jobs List

Data Engineer Developer
Create date: 31-Mar-2016
start date:4/12/2016
submission deadline:4/6/2016
description:

Previous background and experience in healthcare industry preferred in Medicaid or Medicare systems

5 or more years demonstrated work experience in doing data analysis functions

Requires demonstrated application developer experience code using .... (This job is for - DeveloperRDBMS Jobs in PA CampHill Developer - (in CAMP HILL, PA))

Business Analyst / Quality Analyst
Create date: 14-May-2015
27 of 94,311

Business Analyst / Quality Analyst - Harrisburg/Carlisle, PA
Inbox
x
2-Comsys
x
Smith, Karen Karen.smith@experis.com via yahoo.com

10:11 AM (5 hours ago)


Required Skills:

ยท Interacts with the client and product team to gain an understanding of th.... (This job is for - ALMMS Office Jobs in PA Harrisburg Analyst - (in Harrisburg, PA))

Business Analyst-401285
Create date: 05-Mar-2015
Description:

The business analyst will review existing data collections and reports, evaluate the difference between the existing code and the required changes, capturing the gap. The business analyst will use the gap analysis to document the new report specification and testing requirements. The business analyst will work with the pr.... (This job is for - job Jobs in PA Harrisburg Analyst - (in Harrisburg, PA))

Business Analyst -397628
Create date: 04-Feb-2015
Description:

This resource will analyze data as it exists now for PIMS collections and make recommendations to meet the proposed requirements for the PIMS Data Collection Consolidation project
The business analyst will review existing data collections and reports, evaluate the difference between the existing code and the.... (This job is for - job Jobs in PA Harrisburg Analyst - (in Harrisburg, PA))

FISVJP00010537 - Data Analyst Sr
Create date: 29-Sep-2014
** Only W2 Employee - No Subcontracting

** Can submit only Green Card and Citizens

** Can submit at higher rate

*** Over Time is paid at 1.420 times
OT - Extra Hours on Weekdays and Saturdays

*** Double Time is paid at 2.0 times
DT - Hours worked on Sundays

Description:

Pe.... (This job is for - Jobs in PA KingOfPrussia Analyst - (in King Of Prussia, PA))
(Administrator: Data Analysis, Oracle 9G, Sql Server 2000, Excel SQL Scripting in Dauphin County, PA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us