Sql Developer at FL for 6+ Months

Please send the matching profiles to mohitb@usmsystems.com (Please add my id in your yahoo or G talk to be in touch with you) YIM: mohitstaffing G-Talk: mohit.staffing Title: Sql Developer Location: Jacksonville, FL Length: 6 Months Rate: $40/hr Job Discription: Roles: This is a Senior Developer position in our reporting/ETL functional area within the Sapphire platform. The Sapphire platform is an in house Enrollment and Billing system which supports those functions for the over 65 Medicare market. The existing reporting architecture utilizes SQL Server 2008 R2, SSIS and SSRS, with the operational data being extracted from an Oracle 10g database. Within this architecture, the position is responsible for the extraction of data and the creation and maintenance of new/existing reports. In addition to the reporting aspects, this position is responsible for transmission of claim, enrollment, and financial data to/from external vendors via secure FTP and NDM. These activities include troubleshooting transmission failures or assisting in the configuration of new file transmission processes. This position is also accountable for providing production support for reporting, file transmissions, and associated Control M processes. Additionally, this position performs various SQL Server Administrator functions on the reporting databases. This position will also be involved in the following daily activities, participating and providing input to system requirements, producing detail technical design documentation, scoping project work, creating new or modifying existing programs based on technical design, unit testing, and collaborating with system testing organization in response to defects. Technical  Bachelors degree in Computer Science, Engineering, Math, Business or equivalent related work experience.  Demonstrated knowledge of SQL Server 2008 R2 Reporting Architectures  Extensive SQL Server 2008 R2 SQL Server Integration Service (SSIS) and SQL Server Reporting Service (SSRS) experience required. SQL Server Analysis Services (SSAS) experience preferred.  Extensive experience with File Transfer Protocols (Secure FTP).  Microsoft SQL Server 2008 R2 Administrator experience required  Proven knowledge of Oracle 10g and PL/SQL experience.  Extensive C# programing experience  Extensive knowledge of UNIX and Windows Operating Systems required; experience with MVS preferred.  Experience with Team Foundation Server (TFS) required; ClearCase experience preferred  Control-M experience preferred  Understanding of RUP software development methodology preferred  Coach and develop less-experienced team members Business (preferred)  Knowledge of the Health Insurance Industry  Understanding of CMS, Center for Medicare and Medicaid Services, procedures and policies  Familiarity of third party Vendors (TriZetto, MedAssurant, WIPRO, RR Donnelley, and Prime Therapeutics) Mohit Email: mohitb@usmsystems.com , Phone: 1-(703)-349-2396 ...(More..)