logo

View all jobs

DATA ANALYST (SQL Server 2012/2014)

Brooklyn, NY
JOB TITLE: DATA ANALYST (SQL Server 2012/2014)
CUSTOMER: CITY OF NEW YORK
LOCATION: Metrotech Brooklyn
DURATION: 3 years with 2 year extension
POSITION NUMBER: 13

PLEASE NOTE: ALL APPLICANTS MUST INCLUDE 2 (TWO) REFERENCES with resume 
 
PROJECT NAME:  Information Verification Services 2.0 (IVS 2.0)
PROJECT DESCRIPTION: 
  • The Information Verification Service (IVS) system is being built with the collaborative efforts between ITS, FIA, BPI, OQA and IREA in order to produce a centralized processing and research tool for all the data matches that currently exist throughout ITS, IREA and other departments.

TASKS & DUTIES:
  • Create and maintains all databases required for development, QA, Staging and production usage
  • Involved in implementing all the Data model changes.
  • Perform the capacity planning required to create and maintain the databases.
  • Work closely with system administration staff because Computers often have applications or tools on them in addition to the Oracle /SQL Databases.
  • Perform ongoing tuning of the database instances. Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
     
REQUIRED SKILLS:
  • Minimum 4 years experience in SQL Server 2008/2008R2/2012/2014 database management and related products from Microsoft including PowerShell, Windows 2008R2/2012R2 Server operating systems.
  • Minimum 4 years experience with advanced SQL queries and reading query execution plan, developing and performance tuning complex, SSRS and SSIS-2012 packages.
  • Minimum 4 years experience with SQL 2012 on High Availability configuration, support, and troubleshooting.
  • Minimum 4 years experience with Performance tuning, Performance monitoring, Replication, Log shipping, Database Mirroring, Database capacity planning, Users and Role creation and monitoring.
     
If interested in pursuing this opportunity, please respond back and include the following:
• Full MS WORD Resume
• Required compensation
• Contact information
• 2 (TWO) references with contact information
• Availability
 
Upon receipt, one of our managers will contact you to discuss in full
 
Stephen Fleischer
Director
INTERMEDIA GROUP, INC.
131 Varick Street
New York, NY 10013
Voice: 212-248-0100
sfleischner@intermediagroup.com
www.intermediagroup.com
 

 
Powered by