Oracle DBA and BI

Job ID : 73 - Advertised : 2012-01-09 - Closing Date: 4749-12-05 or to apply
Company Name : Odyssey Information Services
  Approximate Salary: $  100,000.00 / Per Year
Location : Dallas,Texas   Country : United States
Industry : Advertising/PR/MR/Events   Position Type : Full-Time
Experience Level : 7 Years   Education Level : Bachelors Degree

As
a member of IT Application Delivery, the Senior Application DBA will assume a
key role in the design of Enterprise Information Management solutions at
Essilor of America.  The Senior
Application DBA will lead fu

POSITION PURPOSE:
This
position is primarily responsible for designing and implementing high
performing databases that will facilitate on-going data quality and support the
needs of the business.
The
individual must successfully apply Data Warehouse and Master Data Management
methodologies and processes with a focus on performance in high transaction
volume Business Intelligence environment. 
 
PRIMARY RESPONSIBILITIES:
·        
Work
with business and IT teams to understand requirements.
·        
Lead
business representatives in data modeling work sessions.
·        
Perform
logical and physical database design to support our MDM implementation and
Business Intelligence teams.
·        
Work
with business and IT representatives on Data Governance tasks and issues.
·        
Define
and document the data architecture of the Data Warehouse and Master Data
Domains, including the physical components and their functionality.
·        
Prepare
database structure and configuration for high-performance through analysis and
optimization.
·        
Assist
developers in tuning SQL.
·        
Database
Tuning and Optimization
·        
Development
of back-up and maintenance procedures
·        
Runtime
optimization, capacity management and planning, security, configuration,
planning and scheduling of maintenance utilities.
·        
Works
with ETL Team to formulate ETL approach and appropriate uses of utilities and
Oracle Tools.
·        
Design,
create and tune physical database objects (tables, views, indexes, etc) to
support normalized and dimensional models. Maintain the referential integrity
of the database.
·        
Create,
update and maintain project documents such as conceptual, logical and physical
data models.
·        
Present
project documents to IT and business team members for review.
·        
Maintain
leading edge knowledge of industry and technology trends, to effectively assess
and recommend options to the project team.
·
Comply
with the IS Pre-Production team standards in regards to operability of the
developed solutions.
·        
Comply
with the IS Technical Architecture team standards in regards to the global
technical framework of the company.
EDUCATION AND QUALIFICATIONS:
·              
Bachelor’s
Degree in IT, MIS, or equivalent work experience.
·              
Minimum
of 7 years in Data Warehousing and Business Intelligence design in a high
volume transaction environment.
·              
Extensive
knowledge of Oracle 10G/11G databases and PL SQL required.
·              
Experience
with migration and deployment of code required.
·              
Experience
with both OLTP and dimensional database design required.
·              
Demonstrated
experience with Entity Relationship (ER), Dimensional, and object modeling
techniques and tools such as Erwin.
·              
Demonstrated
experience tuning databases in a multi-terabyte (5+) Oracle environment
·              
Demonstrated
effectiveness during development, deployment and support phases of data
warehouse environment, including support for ETL functions.
·              
Experience
with large-scale, multi-source data conversion.
·              
Superior
analytical and problem resolution skills.
·              
Must
be able to work effectively alone or in a team environment.
·              
Excellent
verbal and written communication skills.
·              
Thorough
knowledge of data warehousing architectural approaches
·              
Knowledge
of Data Warehouse practices, database and ETL design and analysis.
·              
Knowledge
of current technological developments/trends in area of expertise.
·              
Proactive
personality with a proven track record of delivering on responsibilities and
tasks.
·              
MDM
experience is a plus.
·              
Experience
in an Informatica environment desired
·              
Experience
with OBIEE environments preferred