Short Description:
Programmer is responsible for analysis, design, coding, component & assembly testing of all application code owned by the Application Team. Programmers typically are involved in maintenance (including production support), enhancement & development work.
Complete Description:
**Please Read Details Regarding Occasional TRAVEL for this Position**
Contracted support is needed to provide research, analysis, development, testing, documenting, and deployment functions for various Access database systems and associated reports at State Hospitals within the Office of Mental Health and Substance Abuse (OMHSAS). Contractor will also assist in the development of a new State Facilities Tracking System which will eventually eliminate a lot of the current Access systems at the State Hospitals.
OBJECTIVES OF ENGAGEMENT
The contractor’s responsibilities will be to:
-- Provide software development and phone support of State Hospital Access systems to keep them up and running.
-- Conduct knowledge transfer activities with designated OMHSAS and BIS staff to keep these Access systems running and functional as determined by OMHSAS Central Office, State Hospitals, and BIS to which it may be applicable.
-- Assist in the coding of new State Facility Tracking System
TASKS TO BE PERFORMED
1. Be able to work independently with minimal supervision.
2. Assist in the development of the new State Facilities Tracking System web project.
3. Phone and development support of State Hospital Access systems.
4. Engage in knowledge-transfer activities with OMHSAS Patient Tracking System users and administrative staff which includes; analysis, modification, testing, and deployment of enhanced PTS system to Wernersville to relieve immediate crisis.
5. Provide status reports and updates as required to designated DPW Project Manager and supervisor.
**The contractor MAY also be required to travel to various State Hospitals as necessary to assess and observe system issues as they arise as well as conduct deployment/training activities. Mileage reimbursement will be calculated at state rates for State Hospital on-site visits.**
Skills:
Skill
Required / Desired
Amount
of Experience
Access Database (XP/2002 and 2007) systems (Combined exp)
Required
5
Years
MS VBA for both Access XP/2002 and 2007 (vb.net)
Required
5
Years
SQL Server 2005-2008 functional/software use
Required
5
Years
Microsoft Excel/Word (version’s XP and Office 7)
Required
2
Years
Microsoft Office XP – Office 7 Suite Outlook for email correspondence
Required
2
Years
Experience with change control procedures (DEV/SAT(UAT)/PROD)
Desired
Exp w/ SQL Server security configuration
Required
5
Years
Experience w/ experience with MS Access pass-through queries
Required
5
Years
Experience with DAO/ADO objects
Required
5
Years
Exp w/ Active directory configuration
Required
3
Years
VB.Net web development
Required
3
Years
C#.Net
Highly desired