Title Sr. SQL DeveloperLocation Jericho NY please source locally first ok to source out of state as long as the candidate is willing to relocate at their own expenseDuration Contract to HireVisa Type H1 GC US CitizenRate 65- 70 per hour C2CInterview 1 or 2 rounds of phone followed by an on-site interview may be able to provide out of state candidate with Skype or WebexDescriptionis looking for a highly motivatedSenior SQL Server Database DeveloperEngineerwith a well-rounded experience to join our team. The candidate will be working on the development operational support of high-volume 247 OLTP systems and Enterprise tier ODS environments.Our audience is substantial and high performing available and scalable systems are just as essential to our continued success and growth as the availability and accuracy of reporting and analytics data.This role requires a highly motivated individual with a strong sense of ownership strong technical and analytical expertise as well as longer-term planning abilities.ResponsibilitiesSchema design refactoring Creating and or optimizing Store Proceduresto be executed against a high volume high availability OLTP system Develop and implementETL processes usingSSIS Database performance tuning Participate in DB engineering architecture process Develop performance metrics Assist with report generation and Data Analysis Support production and development databases Support Network Operations team both proactively and in crisis mode Assist team with DBA support when neededRequirementsAbility to produce sophisticated stored procedures and functions Managedata sourcesupwards of 100s of millionsof rows of data Constructed and optimized queries for high volume high availability real-time deployments Strong experience with database concepts and fundamentalsQualifications7&plus years of experience in database administration and development on the Microsoft platform with SQL Server 200820012 and or 2014 Experience with high-volume transactional web-based systems. Strong theoretical and practical data modeling skills. Strong skills in T-SQL store procedure development Strong skills with SQL Server Integration Services SSIS Experience with SQL Server Analysis Services SSAS Experience with SQL Server Reporting Services SSRS Strong performance tuning and optimization skills including procedure and query tuning and index management. Experience with Source Control packages Good written and verbal communication skills. Good general understanding of enterprise-level software development and deployment lifecycles.