New York, NY 10007
Full-time
Salary: $125,000.00 to $135,000.00 /year


  • Manages requirements gathering and analysis for new and existing projects.
  • Supports Microsoft SQL Server 2012/2014/2016 databases across all environments.
  • Supports Microsoft SQL Server 2012/2014/2016 replication feature widely used by different applications.
  • Supports Oracle DBs across all environments.
  • Supports Microsoft Windows 2012 and 2016 Enterprise Servers including configuration and maintenance.
  • Implements and supports Microsoft Clustering Services both on the SQL Server and System levels.
  • Installs and configures Microsoft SQL Server 2012/2014/2016 and Microsoft Windows 2012 and 2016 servers.
  • Monitors Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance.
  • As an expert, creates, designs, manage and troubleshoots SSIS and DataStage packages.
  • Monitors and troubleshoots ETL jobs daily using BCP, DTSRUN, SSIS and other Performance Monitoring tools.
  • Utilizes SQL in creating, designing managing and troubleshooting in Microsoft SQL Server and Oracle.
  • Maintains error and system maintenance logs.
  • Performs OLAP and OLTP data modeling with the ERWIN data modeling tool.
  • Supports Operational data model and data mapping.
  • Supports the development and maintenance of DIIT/STARS data dictionary.
  • Manages and supports DB2 relational system and troubleshoot issues on the DB2 System.
  • Administers DB2 Connect, DB2 Gateway in different ETL set up.

Application Modernization and Enhancements:

8+ years of experience with the following:

  • DataStage and SSIS ETL Development
  • Complex ETL Job Architecture
  • RDBMS Concepts and Writing Complex Stored Procedures and SQL in Oracle and MS SQL Server
  • Performing Complex Tasks/Work with Little or No Supervision
  • Full Lifecycle Staging, ODS, Data Mart and DWH Experience in ETL Data Integration in Large Scale Programs
  • Shell/Power Shell/Bash Script Program Development

2+ years of experience in the following:

Design and Code Interfaces to DOT NET, XML, and MS Dynamic CRM

IT Development and Management:

8+ years of experience with the following:

  • DataStage and SSIS ETL Development
  • Complex ETL Job Architecture
  • RDBMS Concepts and Writing Complex Stored Procedures and SQL in Oracle and MS SQL Server
  • Performing Complex Tasks/Work with Little or No Supervision
  • Full Lifecycle Staging, ODS, Data Mart and DWH Experience in ETL Data Integration in Large Scale Programs
  • Shell/Power Shell/Bash Script Program Development

2+ years of experience in the following:

Design and Code Interfaces to DOT NET, XML, and MS Dynamic CRM

Go to all jobs