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 expense)Duration: 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 Webex)Description: is looking for a highly motivated Senior SQL Server Database Developer/Engineer with a well-rounded experience to join our team. The candidate will be working on the development / operational support of high-volume 24/7 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.Responsibilities:Schema design, refactoringCreating and / or optimizing Store Procedures to be executed against a high volume, high availability OLTP systemDevelop and implement ETL processes using SSISDatabase performance tuningParticipate in DB engineering architecture processDevelop performance metricsAssist with report generation and Data AnalysisSupport production and development databasesSupport Network Operations team, both proactively and in crisis modeAssist team with DBA support when neededRequirements:Ability to produce sophisticated stored procedures and functionsManage data sources upwards of 100s of millions of rows of dataConstructed and optimized queries for high volume, high availability, real-time deploymentsStrong experience with database concepts and fundamentalsQualifications:7+ years of experience in database administration and development on the Microsoft platform with SQL Server 2008/20012 and/ or 2014Experience with high-volume, transactional web-based systems.Strong theoretical and practical data modeling skills.Strong skills in T-SQL / store procedure developmentStrong 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 packagesGood written and verbal communication skills.Good general understanding of enterprise-level software development and deployment lifecycles.