Job Description

Ref No.:18-03886
Location: New York, New York
Duration- 36 months
Interview type- In-person

PROJECT DESCRIPTION:
The Shelter & Building Compliance System (BCS) is a web application for maintaining shelter facility characteristics and compliance information. BCS is the system of record for maintaining and reporting on violation remediation efforts by citywide network providers and Client maintenance and compliance units. BCS is also the system of record for OTDA (NYS) deficiencies and tracks the NYC and provider responses to OTDA along with any associated Operational Plans.

Tasks & Duties
• Create and maintain all databases required for development, QA, Staging and production usage.
• Involved in implementing all the Data model changes.
• Perform the capacity planning required to create and maintain the databases
• Perform data analysis and troubleshooting
• Write complex SQLs and integrate technologies with internal and external data sources


Required Skills
Minimum 5-7 Years Experience in SQL 2008/2008R2/2012/2014 database management and related products from Microsoft including PowerShell, Windows 2008R2/2012R2 Server operating systems.
Minimum 5-7 Years Experience with advanced SQL queries and reading query execution plan, developing and performance tuning complex, SSRS and SSIS-2012 packages
Minimum 5-7 Years Experience with SQL 2012 on High Availability configuration, support, and troubleshooting
Minimum 5-7 Years Experience with Performance tuning, Performance monitoring, Replication, Log shipping, Database Mirroring, Database capacity planning, Users and Role creation and monitoring


Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online