Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
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
   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

VITA Market Research-Financial Analyst (728526)
Create date: 29-Jan-2024
Hybrid

start date :02/12/2024

End date :02/12/2025

submission deadline :2/1/2024

client info :VITA

Description :

*Local Richmond, VA candidates required for onsite work
*Candidates must work onsite 3 days a week with 2 remote
job Jobs in VA Richmond Analyst - (in Richmond, VA))

VDOT Business Analyst With Agile/Scrum (726886)
Create date: 16-Jan-2024
Hybrid

start date :01/29/2024

End date :06/30/2024

submission deadline : 1/19/2024

client info : VDOT

Description :

**candidate must be able to come to Richmond, VA occasionally
**candidate must have experience working in Agile/Scru.... (This job is for - Wireframes Jobs in VA Richmond Analyst - (in Richmond, VA))

VDOT Senior Power BI Developer (723760)
Create date: 14-Nov-2023
Hybrid

Start date :12/11/2023

End date :06/30/2024

Submission deadline :11/17/2023

Client info :VDOT

Description :

*Local candidates only please
*Candidate must also be able to work onsite 2-3 days/week.
*Contractor will be r.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA))

Business Analyst Sr - 61540
Create date: 03-Oct-2023
Start date : 11/01/2023

End date : 11/01/2024

Submission deadline : 10/11/2023

Client info : TN EC

Note :

* Position Location : Hybrid

Description :

Analyze and document business requirements and processes related to publ.... (This job is for - UX Jobs in TN Nashville Analyst - (in Nashville, TN))

GA TECH IT Business Analyst 2 (721168)
Create date: 26-Sep-2023
Remote

start date :10/23/2023

End date :04/19/2024

submission deadline :09/29/2023

client info :Georgia Tech - OIT

Description :

The Business Analyst will act as a key link between business stakeholders and technical teams, facilitatin.... (This job is for - Tableau Jobs in GA Atlanta Analyst - (in Atlanta, GA))
 
 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