Senior SQL Server Developer - Onsite in Brooklyn NY

Senior SQL Server DeveloperLong Term Onsite project in Brooklyn NY Ideally we need candidates with 10+ years relevant experience

• Implement conceptual design to physical database implementation, enhance and refine the logical design of the database.
• Monitors and manages SQL Servers and databases on a day-to-day basis; develops database designs, stored procedures, triggers, and constraints for new applications in MS SQL Server based on client standards.
• Provides day to day advice to users on data structures and terminology and develops policies and procedures related to the support and maintenance of database applications.
• Monitor databases for optimal performance and acts to mitigate blocking and performance tuning issues.
• Provide guidance to Application Development staff for query, stored procedures, functions, and database design.
• Baseline system performance and monitor for deviation, recommending and implementing improvements to slow running queries.
• Document database architecture, configuration settings, baseline performance metrics and planned and unplanned outages.
• Establishes and implements best practices regarding data definition, data quality, data security, and data integration.
• Performs database administration duties, including installation, patching, backup and recovery management, space management, schema management, startup, and shutdown.

• Technical expertise in writing optimal T-SQL queries, stored procedures, User defined functions and views.
• In depth knowledge and hands-on experience developing, deploying, and maintaining complex SSIS packages.
• Through understanding of database maintenance practices, including index management, backup strategies and disk space requirements.
• Knowledge of Microsoft systems, i.e., Windows 2012, 2019, IIS, SQL Server 2012 and 2014, Access, MS
• Experience with backups, restores and recovery models.