SQL Developer

SQL Developer PositionsLocation: New York City or Alpharetta, GA - Hybrid Duration: 1 years +We need two SQL developers. One for a senior/Lead/Mentoring role and one Mid-Senior Level SQL Developer. Lead Candidates should have 2+ years as a lead SQL developer (10+ Total) or been performing that job without the title. They can be considered if they are very senior and are willing to mentor and do code review. The Mid-Senior level developer should have 5+ Years of experience. Candidates also need to have had experience in a Bank or financial services company. Candidates need to either sit in the New York/New Jersey area or Atlanta/Alpharetta, GA and be onsite 2-3 times a week. No relocation considered.Job DescriptionLooking for a SQL Database Developer with 10+ Years of design and development experience who applies database technologies to solve business problems, like high concurrent/transactional supporting databases, MPP Solutions, Analytical, data warehouse. This person will be leading team of database developers to support multiple applications and projects, will be responsible for architecture, design and performance.Must Haves10+ years SQL Server Development experienceSSISETL (using SSIS)SSRSExperience writing [somewhat complex] stored proceduresExperience working with application developersEssential FunctionsCollaborate with app, product, QA and PMO teams to provide needed support from database team. Ability to translate business requirement into technical requirements and work with application developers to deliver results.Supports multiple projects, understands capacity of team and responsible for deliveries from his/her team.Designs, develops, and implements complex database systems, tools, and applicationsWrites queries and stored procedures, uses data modeling tools, designs and optimizes databases, or implements at the physical levelDevelops and documents executable code according to functional and technical specifications using structured development methodologies and defined standards.Shares best practices with team members and provide technical leadership.Assists in the development of project and test plans by providing reliable development estimates.Knowledge and Skills/Technology Used10+ years of database design and development experience3+ years of working experience on Microsoft SQL database Lead developerExperienced in designing and developing databases that support high concurrent users with great performanceAdvanced knowledge of relational databasesAdvanced knowledge of database design to produce sound logical and physical data modelsAdvanced knowledge of SQL and coding techniques to code stored procedures and triggersExperience with varied forms of data design, such as online transaction processing, online analytical processing, data warehousing, operational data stores, and decision support systemsShould have worked in Agile project development environmentVery good communication skillsWorking experience with Offshore is plusExperience in working with Real Estate data is preferred