Apply Now

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

Hybrid in Brooklyn, NY, US • Posted 2 days ago • Updated 2 days ago

Contract Corp To Corp

Contract W2

Contract Independent

No Travel Required

Hybrid

$65 - $70/hr

Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

Datawarehouse Architect

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91172378
Position Id: 881-44286-
Posted 2 days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

EDW Architect

New York, New York

•

Today

Trigyn's direct government client has an immediate long-term need for an EDW Architect in New York, NY. Tasks & Duties: ? Migration Strategy Design: Define options between lift-and-shift, re-platforming, or refactoring approaches ? Infrastructure Design: Architect target environments (cloud, colocation, hybrid) Security and Compliance requirements like the Health Insurance Portability and Accountability Act for protecting secure restricted data. ? Assess workloads, create migration paths, and

Contract, Third Party

DOE

Role: Enterprise Database Architect (Hybrid) - Location: Newark, NJ (In-Person Interview) - 100% Only Locals (NJ) With Valid DL Copy

Hybrid in Newark, New Jersey

•

Yesterday

Role: Enterprise Database Architect (Hybrid) Location: Newark, NJ (In-Person Interview) Job Type: Contract Job Description This role requires deep technical mastery of Oracle Exadata, Oracle E-Business Suite (EBS), and complex Oracle database upgrades, including end-to-end migrations from 11g to 19c. Onsite interview is required. You will serve as a senior technical authority, driving architectural decisions, mentoring DBAs, and leading strategic initiatives such as cloud migration to OCI, Exad

Easy Apply

Contract, Third Party

Up to $100

Oracle PL/SQL developer

Hybrid in Jersey City, New Jersey

•

8d ago

Role : Oracle PL/SQL developer with Snowflake SQL experience Location : Jersey City, NJ or Tampa, FL Duration : 12+ Months Job Description: This role is responsible for developing, enhancing, and supporting high?performance Oracle PL/SQL based data solutions while contributing to ongoing data modernization initiatives leveraging the Snowflake cloud data platform. The ideal candidate will have strong database engineering fundamentals, hands?on experience with Oracle PL/SQL, and working knowledge

Easy Apply

Contract

Depends on Experience

Oracle Fusion Reporting and Analytics Developer

New York, New York

•

2d ago

Amtex SystemsInc is an information technology and talent solutions company offering talent and BI consulting to the companies in US for over 25 years. Our solutions are designed to fill resource gaps, by providing the right candidates who deliver value to the organization. Our propensity to nurture and build strong relationships with our clients helps us better understand their business demands and gives us the ability to provide services that are on time and rise above the rest. Role - Oracle F

Easy Apply

Contract, Third Party

Depends on Experience

Search all similar jobs