*SQL Server Developer w/Access- Direct Client **Immediate Interview and Start ASAP!!! *
*Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Job Title: SQL Server Developer w/AccessLocation: Harrisburg, PADuration: 4 MonthsDirect client PositionClient: State of PARate: $55/hr on C2CThe Department of Health Bureau of Information Technology (DOH BIT) seeks a highly skilled resource in SQL Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) to perform the conversion of Birth and Death records from the client based systems to the Department’s new Vendor supported DAVE system. The primary duties for this resource will be:1.Data ConversionExecute processes to identify and reprocess any records that were recently updated after the record was converted into DAVEVerify all records were applied into DAVE systemClean and process any outstanding recordsExecute processes to clean and split out mailing address information for record import into DAVECorrect any issues found during new record process testingCreate MS Access Form(s) for Bureau of Health Statistics and Research (BHSR) staff to view information before the DAVE system goes liveCreate automated jobs to apply records into source tables and upload into DAVE on a nightly basis Data mapping between Vital Vision and DAVE as well as for various extracts.2. Reporting databaseCreate data extract processes that will be used as inputs and integration points into both internal and external systems Populate information into database 3. OperationsCreate/Populate Disaster Recovery environment and database mirroringCreate documentation on all processes using Bureau of Information Technology (BIT) templates.Test nightly jobs Schedule nightly jobs within DAVE at Go-Live Monitor systems via Microsoft Service Center Operations Monitoring (SCOM) for any downtime or performance issues.Conduct source code promotions to the Staging environment.4. Provide support for EVVE, STEVE, Fetal Deaths, Local Registrar and other Vital Records systems.5. May work with Data warehouse team regarding birth and death data.This engagement will consist of 37.5 hour work weeks and could include work during the evening or weekends during DAVE releases. This position will report to BIT.Transact SQL Required 5 Years SQL Server – Data Transformation Services (DTS) Required 5 Years SQL Server Integration Services (SSIS) 2005 Required 5 Years MS Access Required 5 Years MS Excel Required 5 Years Production Database Tuning Required 5 Years Excellent Verbal Communication Skills Required Excellent Written Communication Skills Required Create Documentation Required 3 Years Solid experience and expertise with data conversions Required 5 Years Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com <s...@cncconsulting.com>* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.