EDW Architect

Tri-Force Consulting Services, Inc.•New York, NY

1d•Onsite

About The Position

We are seeking an experienced Data Warehouse Architect to join our Data & Analytics team. The ideal candidate will bridge the gap between data engineering and analytics, ensuring our data infrastructure supports both high-performance data processing and insightful analytics. If you have a passion for data, a background in high-scale internet companies and expertise in designing and optimizing data warehouses, we want to hear from you!

Requirements

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

Nice To Haves

Bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead