Hi, Manages requirements gathering and analysis for new and existing projects. middot Supports Microsoft SQL Server 201220142016 databases across all environments. middot Supports Microsoft SQL Server 201220142016 replication feature widely used by different applications. middot Supports Oracle DBs across all environments. middot Supports Microsoft Windows 2012 and 2016 Enterprise Servers including configuration and maintenance. middot Implements and supports Microsoft Clustering Services both on the SQL Server and System levels. middot Installs and configures Microsoft SQL Server 201220142016 and Microsoft Windows 2012 and 2016 servers. middot Monitors Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance. middot As an expert, creates, designs, manage and troubleshoots SSIS and DataStage packages. middot Monitors and troubleshoots ETL jobs daily using BCP, DTSRUN, SSIS and other Performance Monitoring tools. middot Utilizes SQL in creating, designing managing and troubleshooting in Microsoft SQL Server and Oracle. middot Maintainserror and system maintenance logs. middot Performs OLAP and OLTP data modeling with the ERWIN data modeling tool. middot Supports Operational data model and data mapping. middot Supports the development and maintenance of DIITSTARS data dictionary. middot Manages and supports DB2relational system and troubleshoot issues on the DB2 System. middot Administers DB2 Connect, DB2 Gateway in different ETL set up. TECHNICAL REQUIREMENTS middot 8+years of experience with the following middot DataStage and SSIS ETL DevelopmentComplex middot RDBMS Concepts and Writing Complex Stored Procedures and SQL in Oracle and MS SQL Server middot Performing Complex TasksWork with Little or No Supervision middot Full Lifecycle Staging, ODS, Data Mart and DWH Experience in ETL Data Integration in Large Scale Programs ShellPower ShellBash Script Program Development middot 2+years of experience in the following middot Design and Code Interfaces to DOT NET, XML, and MS Dynamic CRMIT DEVELOPMENT MANAGEMENT.
Location/Region: New York, NY