Job Description

Reference # : 19-00690Title : IT Specialist
Location : Brooklyn, NY
Position Type : Contract
Experience Level : Start Date / End Date : 09/20/2019 / 09/20/2021
Description
The Senior SQL Server DBA is a mission-critical role to support the Department of Education's New York City Schools Account (NYCSA) application. This is a Parent Facing web application that provides parents and guardians a portal to see their children's current and historical information, like transcripts, grades, report cards and attendance. The selected candidate will manage and coordinate data access to the application and database. In addition, the selected candidate will serve as a subject matter expert, on all databases related issues in support and compliance to the DOE database standard and rules. This role is crucial to the Chancellor's overall goal of engaging parents and Client in all aspects of school life.

• Manage requirements gathering and analysis for new and existing projects
• Support Microsoft SQL Server 2012/2014/2016 databases across all environments
• Support Microsoft SQL Server 2012/2014/2016 replication feature widely used by different applications
• Support Microsoft Windows 2012 and 2016 Enterprise Servers including configuration and maintenance
• Implement and support Microsoft Clustering Services both on the SQL Server and System levels

Install and configure Microsoft SQL Server 2012/2014/2016 and Microsoft Windows 2012 and 2016 servers
• Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance
• Create, design, manage and troubleshoot SSIS packages
• Monitor and troubleshoot ETL jobs daily using BCP, DTSRUN, SSIS and other Performance Monitoring tools
• Maintain error and system maintenance logs
• OLAP and OLTP Data modeling with the ERWIN data modeling tool
• Support Operational data model and data mapping
• Support the development and maintenance of DIIT/STARS data dictionary
• Manage and Support DB2 relational system and troubleshoot issues on the DB2 System
• Administer DB2 Connect, DB2 Gateway in different ETL set up.

10061

Please see our complete list of jobs at:
www.rmscorp.com

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