Hope you are doing well!
Please go through the below requirement and send me your suitable candidate's resume on recr...@tcagroupmail.com.
Role: Sr.
Data Analyst
Location: Brooklyn, NY / NYC
Duration: About 36 Months
Interview: 1st Phone and 2nd Face to Face
Only
Local Candidates with GC/EAD-GC/USC
SCOPE OF SERVICES
PROJECT DESCRIPTION:
DHS CCTV project is to enhance the security and safety of shelter sites throughout the City while enhancing the client diversion and intake processes. Technologies and processes will be implemented to comply with DHS’ mandate to examine security practices across the shelter system and to decrease the agency’s exposure to litigation due to staff or clients being harmed in our facilities.
Tasks & Duties:
· Perform Data analysis across 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
MANDATORY SKILLS:
· Minimum 8 - 10 Years’ Experience in SQL 2008/2008R2/2012/2014 database management and related products from Microsoft including PowerShell, Windows 2008R2/2012R2 Server operating systems.
· Minimum 8 - 10 Years’ Experience with advanced SQL queries and reading query execution plan, developing and performance tuning complex, SSRS and SSIS-2012 packages.
· Minimum 8 - 10 Years’ Experience with SQL 2012 on High Availability configuration, support, and troubleshooting.
· Minimum 8 - 10 Years’ Experience with complex data analysis across all databases.
Thanks,
Shalin
TCA Consulting Group Inc.
recr...@tcagroupmail.com
Mobile: 929-399-8651