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.
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
Upon receipt, one of our managers will contact you to discuss in full