Direct End Client: NYC Department of Social Services| Enterprise Data Warehouse (EDW) Architect| Brooklyn, NY| MUST have State & Federal Exp
Suman Bakshi
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
Hours Per Week: 35
Interview Type: Both Web Cam and In Person Interview
Onsite/Remote/Hybrid: Onsite
Ceipal ID: NYC_DW325_SG
Requirement ID: BID-DSS-ITS-C-20260325-1-39
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
V Group
Inc. is a NJ-based IT Services and Products Company with its business
strategically categorized in various Business Units including Public Sector,
Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products.
Within Public Sector business unit, we cater IT Professional Services to
Federal, State and Local. We have multiple awards/ contracts with 30+ states,
including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN,
PA, TX, VA, NM, VT, and WA.
If you are considering applying for a position with V Group, or in partnering
with us on a position, please feel free to contact me for any questions you may
have regarding our services and the advantages we can offer you as a
consultant.
Please share my contact information with others working in Information Technology.
Website: https://www.vgroupinc.com/publicsectorLinkedIn: https://www.linkedin.com/company/v-group/
Facebook: https://www.facebook.com/VGroupIT