IT JOBS: {SAP JOBS USA:109235} Immediate Hire For Intermediate Database Administrator

Friday 28 December 2012

{SAP JOBS USA:109235} Immediate Hire For Intermediate Database Administrator - SQL

Hi,

We have an urgent requirement for the position of Intermediate Database Administrator with our direct client.

Please send suitable profiles to grace.priya@solomonsint.com

And Please do let me know the consultant details and expected pay rate.

Position	Intermediate Database Administrator - SQL
Location	Harrisburg PA
Duration	6 Months
Payment Mode	W2 / 1099/ CTC

Additional details:

- 37.5 hours per week

- Work hours are 8:30 am – 5:00 pm, Monday - Friday (with lunch 12:00 - 1:00 pm)

Job Description:

The DBA position Resource will coordinate with agency developers to plan and implement database analysis, changes, and upgrades, and mentor agency staff on best practices.

The OIG Automated Recovery System ("OARS") is the Office of Inspector General's primary IT solution for the agency's welfare recovery efforts: case generation and routing, processing and recording payments, generating letters and reports, and communicating with several outside systems to achieve its mission. It is a web application with approximately 300 users within the agency.

This project is a modernization and reengineering of the existing OARS system, upgrading it from ASP.NET 1.1 to ASP.NET 4.5 and incorporating over 100 outstanding fixes and feature requests in the application code (Visual Basic .NET), database (SQL Server 2005) and reports (SQL Server Reporting Services), and refactoring and simplifying the system's internal structure for future ease of maintenance.

Some major initiatives within the project's scope include fixing known issues within the user interface, granting access to staff at allied state agencies to augment current business practices, granting access to the public to incorporate e-commerce style repayment of debt, simplifying or streamlining the generation of letters and legal documents, and creating detailed documentation of current business practices and rules.

The Database Administrator in this role will be work with existing agency staff in reviewing the OARS database, making recommendations for and overseeing the implementation of approved coding changes aimed at streamlining the data structure for future ease of maintenance and performance tuning, overseeing the upgrade process from SQL Server 2005, and mentoring agency staff on database design and administration best practices.

A qualified candidate must:

• Have a strong command of database design and adminsitration best practices.

• Have experience working with large-scale database reengineering projects.

• Have experience working with Very Large Databases (VLDBs).

• Have experience upgrading databases in SQL2005 to later versions.

An ideal candidate would additionally have working knowledge of the Pennsylvania welfare system and expereince working in an Agile environment.

Question 1	This position is for a 37.5 hour work week. Have you discussed this with your candidate and do you and your candidate both accept this requirement?
Question 2	The duration of this contract is approximately 6 months, with work stopping on 6/28/2013. Have you discussed this with your candidate and are you and your candidate able to accept this requirement?

Question 3

Candidates MUST be able to come to Harrisburg, PA for an in-person interview with the client. Client is not open to phone or web interviews at this time.

Skills	Required/ Desired	Years	Years of Experience	Last Used
DBA expereince working with large scale re-engineering projects	Required	3
DBA experience working with Very Large Databases (VLDBs)	Required	3
Experience upgrading SQL Server 2005 to later versions	Required	1
Database Administrator experience	Required	5
Experience working in an Agile enviroment	Highly desired
Working knowledge of the Pennsylvania Welfare System	Nice to have
Experience mentoring in DBA best practices.	Required	5