homeJob Search SQL DBA-Expert

Job Search

Job Code PA-4707
Job Name SQL DBA-Expert
Number of openings 1
Start date 2019-09-20
End date 2021-09-19
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 guardian in all aspects of school life.   Duties • 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. Mandatory Requirements • Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business application and products that run on those platforms – Beyond that of a programmer. • Experience (7+ Years) Requirements • 84 Months of Experience in Database Management doing Relational Data modeling.  • 84 Months of Experience in SQL Server in the setting up and Configuring Microsoft SQL Server on Windows platform.  • 84 Months of Experience in SQL Server in managing and administering SQL Server database.  • 84 Months of Experience in SQL Server Backup and Restore Strategy.   • 84 Months of Experience in data modeling for data warehouse and data mart.    • 84 Months of Experience in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)    • 84 Months of Experience in SQL Server Performance Tuning and Query Optimization.  • 84 Months of Experience in writing complex Stored Procedure and Functions in T- SQL.    • Bachelor’s Degree from a recognized University 
Country US
Location  Brooklyn, New Yor
Contact Information
Professional Information

Full description only for registered users.

Please login or register

Not a member?
  1. Newsletter

    Subscribe newsletter

  2. Partners