Solaris Windows Administration Oracle Data Integrator ODI Oracle Warehouse Builder   Requirement id 47681 Job title DBA Job location in Raleigh, NC Skills required SQL * Loader, PL/SQL, ETL Process, Solaris Windows Administration Oracle Da Open Date 31-Jul-2015 Close Date Job type Not specified Duration 11 Months Compensation DOE Status requirement --- Job interview type Face to Face interview Apply    Email Recruiter: coolsoft Job Description DBA: SQL * Loader, PL/SQL, ETL Process, Solaris Windows Administration Oracle Da Description: The SCUBI(Southeast Consortium for Unemployment Benefit Integration) project is a multi-state workforce agency consortium tasked with modernizing legacy Claims/Benefits processing systems. The SCUBI(Southeast Consortium for Unemployment Benefit Integration) project is a multi-state workforce agency consortium tasked with modernizing legacy Claims/Benefits processing systems. DB Administrator/Warehouse Manager candidate should be a self-motivated and results driven Data Conversion Expert with senior-level experience in Database mapping, design, migration and conversion. The DBA will be working as a member of the support team performing data analysis and migration process design and development. This person is responsible for the conversion of data contained within the existing legacy systems, migrating data and validating the integrity of the converted data. As the Data Warehouse Manager this individual will perform data modeling, database construction, and use of OWB or ODI processes to build the data warehouse. The creation of the Data Warehouse will be accomplished through joint collaboration of this person working with application developers to ensure the required data is available as well as to provide performance tuning assistance for new applications. KSA: The selected applicant should possess skills with Oracle (9i, 10G, 11G), SQL*Loader, Oracle Data Integrator (ODI)/Oracle Warehouse Builder (OWB), Oracle Data Masking, and PL/SQL. The candidate should have O/S experience in Solaris and Windows. • In-depth knowledge of relational DB design toolsets • Solid development background with senior-level expertise in migration processes, data modeling and data performance • Expert knowledge of normalized and dimensional modeling techniques • Must be able to provide design options, alternatives and recommendations based on experience and best practices • Strong knowledge of relational database technology, transaction processing and data warehouse design and advanced modeling and design tools • Direct administration experience with Oracle relational databases, hosted in both physical and virtual environments • Solid experience developing and tuning of complex SQL statements for purposes of analyzing data and/or evaluating how schema design effects database performance and physical database structures Responsibilities: • Responsible for ETL process, data modeling and database performance • Analyze, develop, install, test, upgrade, maintain and support complex data/process models, and processes in an ETL environment • Develop, implement and promote architectural standards and frameworks, allowing for a flexible and scalable environment • Define, understand and recommend changes to the existing databases, software, hardware and application environment in tandem with the current business needs and direction • Design, develop, and support complex integration processes (including interfaces) using Oracle, stored procedures and SQL program code • Performance monitoring using GRID/Enterprise Manager • Interact with various matrix partners and team members to ensure applications are fulfilling user requirements, are efficiently designed & are easy to support and maintain • Perform root cause analysis for issues and provide effective and timely resolution Experience in the following areas is a plus: • Unemployment Insurance Benefits systems and processes • MS-SQL Server Administration • RH Linux, Solaris, Windows Administration Required Skills: * SQL*Loader * PL/SQL * ETL Process * Solaris * Windows Administration * Oracle Data Integrator (ODI) * Oracle Warehouse Builder (OWB) * RH Linux * Relational DB Design Toolsets * Data Warehouse Design / Advanced * SQL Server Administration   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 47681 while calling.   Other jobs in NC: Chapel Hill (2), Charlotte (58), Dix Campus (1), Greensboro (3), Morrisville (2), North Charlotte (2), Raleigh (96), St Raleigh (2), Winston Salem (3),         (DBA: SQL * Loader, PL/SQL, ETL Process, Solaris Windows Administration Oracle Da in Raleigh, NC)

Featured Jobs Business Analyst - Analyst (Jobs in Tallahassee, Florida) Business Analyst - Analyst (Jobs in Tallahassee, Florida) Business Analyst - Analyst (Jobs in Austin, Texas) ServiceNow Specialist (Jobs in Raleigh, North Carolina) Quality Assurance MS Consultant (Jobs in Durham, North Carolina) Infrastructure Developer (Jobs in Raleigh, North Carolina) ETL Analyst (Jobs in Richmond, Virginia) APD Consultant (Jobs in Raleigh, North Carolina) Business Analyst LMS Consultant (Jobs in Durham, North Carolina) Warehouse Developer (Jobs in Lincoln, Nebraska)