Oracle Architect (Smithfield, RI)

Oracle Architect

s www.globalchannelmanagement.com jobopeningsjobs(at)globalchannelmanagement.co mOracle Architect needs 10 years of related responsible experience working with large and complex data warehouse systems experienceOracle Architect requires 8 years of recent experience working with Oracle Exadata in a multi terabytes environment 8 years of hands-on experience in database and SQL performance tuning (Oracle PL SQL) 5 years of experience in designing & developing logical & physical data model using data warehouse methodologies including Star schema - Star-joined schemas conformed dimensions data architecture early late binding techniques and data modeling Extensive hands-on technical knowledge of Data Warehouse Architecture ETL Database & SQL performance tuning Knowledge of data warehouse software development lifecycles (SDLC) including Project & multi-tasking ability Excellent interpersonal communications skills Oracle Architect duties Provide technical leadership in developing vision strategy architecture and overall design for assigned domain and for solutions. Lead teams technical projects or programs and has overall leadership responsibility for project architecture and design. Actively facilitate complex design and technical discussions reconciling differing opinions and drives decision making process. Review and ensure architectural designs are consistent maintainable flexible and cost effective. Provide technical leadership and mentoring throughout the project lifecycle Identify reuse opportunities proactively and build metadata driven process Articulate the tradeoffs benefits and risks of all architecture and design solutions. Understand nonfunctional requirements unique to each application and identify the optimal system configuration and database design to deliver exceptional levels of performance and availability Be open to hands-on SQL PL SQL tuning participate in design development activities Be open to learn new technologies understand and the lead the rollout of features in new releases of Oracle database to benefit existing applications