Sr SQL Developer with DBA

company banner
Spruce Technology Inc.
"SQL Server" AND "SQL Server Developer"
Contract W2, Contract Corp-To-Corp, 12 Months
Depends on Experience
Work from home not available Travel not required

Job Description

Spruce Technology is a mid-size and rapidly-growing Information Technology services firm headquartered in New Jersey. An award-winning firm (Inc 5000, SmartCEO) with a steadily growing portfolio of commercial and government clients, Spruce Technology provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce Technology, Inc. is an Equal Opportunity Employer that does not discriminate on the basis of actual or perceived age, sex, pregnancy, race, creed, color, national origin, disability, marital status, sexual orientation, citizenship status, genetic information, religion, or any other characteristic protected by applicable federal, state or local laws.

Note: Shortlisted candidates should be open for direct face to face Interview

Position: Sr.SQL Server Developer with DBA

Location: NYC, NY

Job Type: Contract

Duration: 12 Months.

Job Description:

We are looking for a Sr.SQL Server Developer to assist one of our clients in NYC.This role will be on- site reporting and will be responsible for for designing databases and ensuring their stability, reliability, and performance. You will also work other developers optimizing in-application SQL statements as necessary, and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.

Required Skills:

  • The selected candidate must have the minimum of 10 years experience as a SQL Server Developer
  • Experience with SQL 2008 R2, 2012 and component services like SSIS ETL, SSAS, SSRS
  • Configure SQL Server monitoring utilities to minimize false alarms
  • Ensuring that new database code meets company standards for readability, reliability, and performance
  • Providing developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each.
  • Designing indexes for existing applications, choosing when to add or remove indexes
  • Assisting developers with improving the performance of that query by tweaking it or modifying indexes
  • Conducting SQL Server lunch-and-learn sessions for application developers
  • Advising developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.)
  • Being a subject matter expert on database design, performance issues, disaster recovery, backups, database maintenance and database archiving
  • DR knowledge with Always On, SQL log shipping, DB mirroring, Replication
  • Experienced with SQL installation on standalone and cluster servers
  • Assess and tune Data base/SQL performance
  • Database migration from ADABASE, DB2 and Access
  • Creating Packages, cleansing Data and ETL development process
  • In addition, the candidate must demonstrate ability to write T-SQL queries to fulfill ad-hoc requests and data integrity checking; demonstrated ability to write T-SQL stored procedures for code re-use. The candidate must also demonstrate experience with DTS / integration service data transformation and manipulation tools.

Desired Skills:

  • Business Objects
  • Crystal Reports
  • LDAP
  • Java Media Framework
  • OLE Programming with J-Integra
  • HP Quality Center

If interested, please forward a current copy of your resume with contact information to spvishnu@sprucetech.net or call me at 973-272-4205



Company Information

Founded in 2006, Spruce Technology is a leading provider of IT services for the public, private, and federal sectors, specializing in Strategic Staffing Services, Solutions & Professional Services, and Advisory Services. With clients in 30+ states, Spruce is a certified MBE and MS Gold Partner.
Dice Id : 10215935
Position Id : SPRUCE012111

Similar Positions at Spruce Technology Inc.

SQL Server Developer/ DBA
  • New York, NY
  • 3 days ago
Sr SQL Server Developer
  • Peck Slip, NY
  • 4 days ago
SQL Server Developer
  • Peck Slip, NY
  • 2 days ago
SQL Server Developer
  • Nyc, NY
  • 2 days ago
Sr.SQL Server Developer
  • Nyc, NY
  • 20 hours ago
Sr MS Dynamics CRM Specialist
  • Brooklyn Heights, NY
  • 4 days ago
.Net Developer
  • New York, NY
  • 20 hours ago