Edw Architect

Job Title: EDW Architect
Location: New Jersey, New York and Pennsylvania preferred.
Visa: H1B

I need a 10+ years candidate

Job Summary
We are seeking an experienced Enterprise Data Warehouse (EDW) Architect to design, implement, and manage robust data warehouse solutions. The ideal candidate will have deep expertise in data architecture, database administration, ETL processes, and Oracle-based technologies, with a strong focus on performance, security, and scalability.

Key Responsibilities
Design and develop scalable and high-performance data warehouse architectures
Oversee data modeling, database design, and data administration
Ensure data security, integrity, and performance monitoring across systems
Manage ETL processes and data integration workflows
Perform system upgrades, patching, and migrations on engineered systems
Implement and manage Disaster Recovery (DR) strategies
Handle Oracle database migration, backup, and recovery operations
Administer and support Fusion Middleware components including WebLogic and OBIEE
Design and manage high-redundancy storage solutions using ZFS and Exadata grid disks
Work with UNIX/Linux environments for scripting, scheduling, and automation (Cron jobs)
Collaborate with cross-functional teams to ensure efficient data solutions
Required Qualifications
8+ years of experience in:
Data modeling
Data administration
Database design
Performance tuning and monitoring
Strong knowledge of:
Data Warehouse Architecture
Database Administration
ETL processes
Hands-on experience with:
Oracle database migration, patching, upgrading, and recovery
Engineered systems (Exadata preferred)
Experience with Disaster Recovery and system migrations
Technical Skills
Databases & Tools:
Oracle RDBMS
Oracle RAC
Oracle ASM
Data Guard
RMAN
GoldenGate
ODI
OBIEE
Middleware & Identity Management:
WebLogic
OAM (Oracle Access Manager)
OID (Oracle Internet Directory)
Systems & Storage:
UNIX/Linux (scripting, scheduling, Cron jobs)
ZFS file system
Exadata (grid disk design and management)
Preferred Skills
Experience with Fusion Middleware Administration
Strong problem-solving and troubleshooting abilities
Ability to work in a high-availability, mission-critical environment

--