Job Description :
Title: Data Architect (Heavy Oracle) Duration: 1 Year + Location: Pittsburgh, Pennsylvania Job Description Ability to function in highly complex distributed environment with multiple development and production environments Demonstrated experience with application and database migration scenarios Ability to transcend between conceptual architecture and logical structures to design and implementation Ability to reverse engineer current data structures and replication Ability to support multiple development teams in data center migration events Available to assist in multiple data center migration events during normal working hours and on weekends/evenings Ability to develop alternatives and identify trade-offs for retirement of materialized views, database links, and direct coupling to database schemas Present design proposals to data architects and development teams for evaluation Open mindset and willingness to accept guidance from peer architects Participate in reviews with data and solution architects Excellent verbal and written communication skills Knowledge / Skills / Abilities Considered a Plus Advanced Oracle data architect including database administration skills focusing on design rather than system DBA Familiar with database tools such as Oracle SQL Developer and SQL*Plus Knowledge of Oracle data dictionary Knowledge of Oracle roles, permissions, tables, materialized views, views, OIDs, database links Familiar with data replication tools such as IBM CDC, Oracle GoldenGate and Data Guard Experience across all phases of data modeling, from conceptualization to database optimization In-depth knowledge of data integration concepts, approaches, and tools to successfully implement data integration strategy Working knowledge of data modeling tools (preferably ER/Studio) Experience with implementing architecture principles and design patterns Experience with end-to-end solution architecture for data capabilities Familiarity with Service Oriented Architecture (SOA), microservices, and data service