Industry: Information Technology - Data Architect/Analyst/Administrator
Type: Full Time
$62,820.00 - 148,460.00
?SQL SERVER DBA Work Location: Brooklyn NY 11201 Interview: In-person
? 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.
- Experience in Database Management doing Relational Data modeling.? - Experience in SQL Server in the setting up and Configuring Microsoft SQL Server on Windows platform.? - Experience in SQL Server in managing and administering SQL Server database.? - Experience in SQL Server Backup and Restore Strategy.? - Experience in data modeling for data warehouse and data mart.? - Experience in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)? - Experience in SQL Server Performance Tuning and Query Optimization.? - Experience in writing complex Stored Procedure and Functions in T- SQL.? - Bachelor?s Degree
Associated topics: data analyst, data analytic, data engineer, data scientist, database administrator, erp, hbase, mongo database, mongo database administrator, sql