Direct Client Looking for Enterprise Data Warehouse (EDW) Architect in Brooklyn, New York( STATE OR PUBLIC SECTOR OR FEDERAL CLIENT MUST)
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 Webcam 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
Twitter: https://www.twitter.com/vgroupinc