DBA D/W

• Responsible for creating and managing OWB (Oracle Warehouse Builder) mapping including staging tables, fact tables, target tables, indexes, procedures, triggers and packages
• Create and maintain various technical documentation including System Design Document, ERD, Data Dictionary, Data Mapping, Data Validation
• Responsible for designing and performing Extraction Transform Load (ETL) process, data mapping, workflow
• Responsible for maintaining data warehouse and reporting systems to ensure accurate data output
• Work with team to monitor and effectively document, diagnose, isolate and expediently resolve issues pertaining to data warehouse and reporting systems
• Perform unit testing on database code and manage product releases using internal Configuration Management (CM) tools
• Design, develop and debug ETL and related applications using OWB ETL tool and Oracle PL/SQL
• Assist in the design of object model, utilizing SQL, designing attributes, and reports, tables, constraints, and stored procedures
• Develop database implementation plans, including development of shell scripts and procedures for routine DBA tasks

• 5+ years experience as a database administrator working with Oracle 10g
• 5+ years experience as data modeler working with ERWIN
• 5+ years experience working with Unix typically HP-UX 11.11
• 5+ years experience in PL/SQL stored procedures & packages and tuning SQL statements
• Experience with data warehouse life-cycles including the design and building of data models and ETL to support business reporting
• MUST HAVE ORACLE WAREHOUSE BUILDER OR INFORMATICA

Nice to have

• Oracle 10g certification
• Good knowledge of Claim adjudication
• Some SQL Server expertise
• Java/Weblogic