State Of NY Datawarehouse Architect(EDW) in Brooklyn, NY Hybrid Role

Brooklyn, NY - USA

Monthly Salary: Not Disclosed

Posted on: 4 days ago

Vacancies: 1 Vacancy

Job Summary

Direct End Client: NYC Department of Social Services.

Job Title: EDW Architect

Duration: Long Term Contract (Up to 36 Months Possible 2-Year Extension)

Location: Brooklyn New York (Onsite at DSS Data Center 505 Clermont Ave Brooklyn NY)

Position Type: Contract

Project: Data Center Co-location and Migration Project

Project Overview:

NYC DSS is undertaking a large-scale Data Center Co-location and Migration Project to modernize its IT infrastructure.

Approximately 90% of current data center infrastructure is reaching End-of-Life (EOL) / End-of-Support (EOS)

Migration from 15 MetroTech Center to 11 MetroTech (Brooklyn NY)

Consolidation of multiple data centers into a single co-location facility

Focus on:

Infrastructure modernization
Risk mitigation
Improved system reliability and performance
This project is critical to DSS operations supporting applications used for:
Public assistance
Housing and shelter services
Benefits distribution systems

Required Skills

8 years experience in data modeling data administration data security and integrity performance monitoring and logical and physical database design.
Strong knowledge of Data Warehouse Architecture DB Administration and ETL.
Strong knowledge of system upgrades patching Disaster Recovery and Migration on Engineered Systems.
Strong knowledge of designing LDOM ZONES in an Engineered System.
Experience in Migration patching upgrading and recovery of Oracle Database.
Familiar with WebLogic/OBIEE and Fusion Middleware Administration.
Strong exposure of ZFS file system designing high-redundancy grid disks on Exadata.
Well-versed with SSO using OAM integration of OID with Active Directory Security groups and roles.
Exposure to OBIEE 12c Oracle Portal Reports server and development.
Strong Working & technical knowledge of data migration data integration performance tuning ETL tools(ODI OWB) and File transfer.
Knowledge of UNIX/Linux operating systems and Scheduler scripting and Cron jobs.
Technical Tools and Technologies:
Oracle Toolset: AWS Oracle RDS custom Oracle RDBMS Oracle ASM Oracle Cloud Control Oracle Data Guard Oracle RMAN Oracle Grid Infrastructure Oracle Clusterware Oracle RAC Oracle ASM Oracle RAT OCFS OCFS2.
Data Replication: Oracle Golden Gate
Development Languages/Tools/Frameworks: SQL PL/SQL Python Java Perl Shell Scripting Java Script Oracle LogMiner Toad SQL Developer PL/SQL Developer.
Access Control: SSO using OAM integration of OID with Windows AD
Operating Systems: Linux Unix (SUN Solaris) Microsoft Windows.
Tools: OWB ODI OBIEE Oracle Portal Oracle Report Server WebLogic FMW
Experience with: ZFS file system LDOM ZONES

Direct End Client: NYC Department of Social Services. Job Title: EDW Architect Duration: Long Term Contract (Up to 36 Months Possible 2-Year Extension) Location: Brooklyn New York (Onsite at DSS Data Center 505 Clermont Ave Brooklyn NY) Position Type: Contract Project: Data Center Co-locati...