Sr.SQL Server Developer

company banner
Spruce Technology Inc.
ssrs and ssis
Contract W2, Contract Corp-To-Corp
Depends On Experience
Work from home not available Travel not required

Job Description

Position: Sr.SQL Server Developer
Location: NYC, NY
Job Type: Contract
Duration: 12+ Months

 

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.

 

Job Description
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.


If interested, please forward a current copy of your resume with contact information to ranga@sprucetech.com

Posted By

Ranga Reddy



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 : 643558

Similar Positions at Spruce Technology Inc.

SQL Server Developer
  • Nyc, NY
  • 1 day ago
SQL Server Developer
  • Peck Slip, NY
  • 1 day ago
Sr SQL Server Developer
  • Peck Slip, NY
  • 1 day ago
SQL Server Developer/ DBA
  • New York, NY
  • 1 day ago
Sr SQL Developer with DBA
  • Ny, 10038
  • 1 day ago
Data Migration Lead
  • Flushing, NY
  • 4 weeks ago
Sr MS Dynamics CRM Specialist
  • Brooklyn Heights, NY
  • 1 day ago
.NET Developer
  • 55 Water Street, NY
  • 1 day ago