Sr SQL Server Developer 9/1/2016

Spruce Technology Inc New York, NY

Company
Spruce Technology Inc
Job Classification
Full Time
Company Ref #
29479363
AJE Ref #
576062000
Location
New York, NY
Job Type
Regular

JOB DESCRIPTION

APPLY
JOB TITLE: SR SQL SERVER DEVELOPER
Duration: Full-time
Location: New York City, NY

NOTE: CANDIDATES NEED PERMANENT WORK AUTHORIZATION TO WORK IN USA. NO SPONSORSHIP

JOB DESCRIPTION:
MINIMUM 10 YRS OF EXPERIENCE AS A SQL SERVER DEVELOPER
Application data modeling experience using tools like ERwin or ER/Studio.
Proficiency in supporting SQL Server 2005/2008 databases in high availability environments with intimate knowledge of both SQL and T-SQL.
Working knowledge on cross-platform databases like MySQL/Oracle/DB2/MS Access.
Experience in Migration MS-Access database to MS Sql Server
Familiarity with SSRS, SSAS, SSIS and data warehousing concepts like ETL, Dimensions, Facts, Cubes.
Experience with database replication techniques.
Experience in replication between Mainframe systems and relational databases.
Demonstrated knowledge of designing, developing and integrating databases, data warehouses and multidimensional databases in MS-SQL Server.
Ability to write and optimize complex SQL queries, procedures and functions.
Ability to perform both database-level and operating system performance tuning and monitoring.
Prior experience with database server installations and configurations.
Knowledge of SQL Server backup and recovery scenarios.
Proficiency in SQL Server security management..
Ability to design databases according to industry standards and make tuning recommendations.
Experiences with database-level encryption technologies.
Experience with version control and release management principles.
Experience with high availability features such as clustering and mirroring.