Hi, *Required SQL Server Developer in Trenton, NJ.*
*Location: Trenton, NJ* ***Duration: 6 Months* *Short Description: * This Programmer is responsible for analysis, server and database migration and testing of all code and systems relevant to this contract role. There will be some testing, enhancements and possibly production support. ** *Complete Description*: Please note that the position, despite being listed as Area 2, is actually in Trenton, NJ. *Years of Relevant Experience:* 5 plus years *Preferred Education:* 4 year college degree or equivalent technical study *Role Description:* This role is for a Database Developer with over 5 years of SQL Server migration experience. A qualified candidate will also have prior experience migrating from Windows Servers (2000-2003 or 2003-2008). *Some projects that interact or are critical to this contractors role:* Data scrubbing and standardization of vital statistics birth data files from 1965 to present for use in the deployed EVVE and STEVE software. Quality control, verification and transmission testing of the newly implemented EVVE and STEVE systems. Document, establish training materials and support the local registrars in the transition to the newly deployed Netsmart system. Retire, build & replace the existing database servers which is end of life this year. Test and upgrade the existing SQL instance to SQL 2008 and implement automatic failover with a witness to database replication model. Design new Imports/Exports and reports for the new Fetal Death and Civil Union Components of the NetSmart software to meet the data request needs submitted by the Press Officer and related data agencies. Develop & test interstate exchange export of revised death certificate national reporting Develop & test interstate exchange export of existing fetal death certificate national reporting Data load/migration, quality assurance and quality control review of the NJ-DARM Birth data. The data project is ongoing as part of the compliance with the REAL ID & Anti-terrorism Acts and will require birth data to be scanned to image & loaded to the repository from 1964 to 1901. Test and possibly implement the replacement of the antiquated DOS EBC with Virtual machine technology on newer hardware to bridge the gap till the new EBC is in place. (Decision for implementation will be made based on tet results). Revamp the security and permission structure of the Netsmart application to be able to address the security concerns in a Citrix environment. Verification and testing of the Citrix environment to be utilized by the local registrars to initiate infrastructure for the deployment of access to the data warehouse. (This deliverable was not completed in the last contract due to delays in obtaining the Citrix licenses and set up through DHS.) Definition and design of enterprise components and access rules for Governor Corzine's Verification Engine Project for NJ Family Care enrollment. Development of the VS portion of expansion of the Verification Engine Project beyond NJ Family Care, to link to a single web interface that will query various state and federal agencies. Plan all required process steps. Review and understand the Application Team’s workplan. Provide status of work to Team Lead. Anticipate, identify, track and resolve issues and risks affecting own work and work of the Application Team. Develop contingency plans as necessary. Engage in ongoing process improvement. Detailed functional and process knowledge. Utilize deep modeling, design and coding skills. Provide expertise in one or more database environments." *Required / Desired Skills* [image: Show/Hide][image: Show/Hide] *Skill* ** *Required / Desired* ** *Amount of Experience* SQL Server 2000 Required 5 Years SQL Server 2005 Required 3 Years Database migration from SQL 2000 to 2005 Required 2 Years Windows Server 2000 Required 5 Years Windows Server Migration from 2000 to 2003 Required 2 Years VB Script programming Required 2 Years Windows Server 2003 Highly desired 3 Years SQL Server 2008 Highly desired 6 Months Data Recovery/Disaster Recovery Highly desired 3 Years Netsmart/QS Technologies Desired 1 Years *If you feel interested in this opportunity, Kindly send me your updated resume in word format along with the following details:* ** *1. Resume in Word Format* *2. Full Name:* *3. Hourly Rate:* *4. Current Location:* *5. Visa Status (H1-B/Green Card/U.S Citizen)* ** -- Thanks & Regards, Santhosh Rao 508-329-0577 [email protected] Advans Technologies Inc. www.advanstec.com
