Apply Now

Enterprise Data Warehouse Architect

• Posted 12 hours ago • Updated 1 hour ago

Full Time

On-site

Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

Code Refactoring
Infrastructure Architecture
Cloud Computing
Regulatory Compliance
Health Insurance
Accountability
Data Warehouse
Collaboration
KPI
Technical Drafting
Dashboard
Data Quality
Data Integrity
Business Process
Scalability
Business Analysis
Business Intelligence
Data Architecture
OLAP
Cubes
Data Modeling
Data Management
Data Security
Performance Monitoring
Database Design
Data Warehouse Architecture
Database Administration
Disaster Recovery
Migration
Recovery
Database
Oracle Exadata
Data Migration
Data Integration
Performance Tuning
Extract
Transform
Load
Scripting
cron
Amazon Web Services
Amazon RDS
Remote Desktop Services
RDBMS
Oracle Cloud
Oracle Data Guard
Oracle RMAN
GRID
Oracle Clusterware
Oracle RAC
Oracle ASM
OCFS2
Replication
Oracle GoldenGate
PL/SQL
Python
Java
Perl
Shell Scripting
JavaScript
Oracle LogMiner
Toad
SQL
Pl/Sql Developer
Access Control
SSO
OAM
Object Identifier
Oracle Internet Directory
Active Directory
Operating Systems
Linux
Unix
Solaris
Microsoft Windows
Oracle Warehouse Builder
OWB
Oracle Data Integrator
OBIEE
Oracle WebCenter
Oracle
Reporting
Oracle WebLogic
Oracle Fusion Middleware
FMW
ZFS
File Systems
LDOM

Summary

Role: Enterprise Data Warehouse Architect

Duration: Long Term

Location: Brooklyn, 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 execute with minimal disruption
Analyze for technical feasibility of Oracle Fusion Middleware Apps SME to define and support the architecture and tools used, such as Oracle Portal, Reports, OBIEE, OID, ODI, and OAM on Solaris and Unix Operating systems.
Analyze requirements to create technical designs, data models, and migration strategies.
Evaluate and influence selection of data warehouse and business intelligence software.
Collaborate with technology stakeholders to define and implement actionable metrics, KPIs and data visualizations
Lead technical design and implementation of dashboards and reporting capabilities
Implement data quality, data integrity, and data standardization efforts across products and databases enabling key business processes and applications
Recommend improvements to enhance existing ETL and data integration processes to enable performance and overall scalability
Interact closely with Business Analysis team, ETL team and BI Reporting teams to ensure understanding of proper use of data architecture
Design, build, and maintain physical databases, dimensional data models, OLAP cubes, ETL layer design and data integration strategies

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: RTL939169
Position Id: 31d755b3a02038e18cf05b046c105bcb
Posted 12 hours 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

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

Hybrid in Brooklyn, New York

•

2d ago

DirectEnd 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 cent

Easy Apply

Contract, Third Party

$65 - $70

Enterprise Data Specialist

New York, New York

•

Today

Full-time / direct role only HCLTech is looking for a highly talented and self- motivated Reporting Data Analyst, Morristown, NJ; New York, NY; Purchase, NY, Charlotte, NC; Conshohocken, PA; Dallas, TX; Houston, TX Alpharetta, GA; Chicago, IL; Colorado Springs, CO; Denver, CO; Fargo, ND; Garden City, NY; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; Topeka, KS (Onsite) Full time role) to join it in advancing the technological world through innovation

Easy Apply

Full-time

$104,000 - $120,640

Staff Data Architect

New York, New York

•

4d ago

{"description": " THE POSITION Our roster has an opening with your name on it As a Staff Data Architect, you are accountable for domain-scale data architecture impact. You define the target-state architecture for your domain, establish enforceable standards and data contracts, and enable multiple teams to deliver governed, reliable, and reusable data products. You are responsible for architecture decision quality, semantic consistency, and adoption of shared patterns across your vertical. You sh

Full-time

USD 170,000.00 - 223,650.00 per year

Search all similar jobs