Position: Sr. Data Warehouse DBA
Location: Boston, MA Area

Details:
Sr. Data Warehouse DBA - Oracle 11g - OBIEE - RAC  - Boston, MA Area - Up to
$110K+ DOE
Up to $110K+ Base + Bonus + Comprehensive Benefits
Local Candidates Only
Stable Work History

Company:
Large, successful, public International Business Information Services Firm

Position Responsibilities - Summary:
The Senior Data Warehouse DBA will be responsible for partnering with
business owners and analysts to translate requirements into a complete Data
Warehouse and business intelligence solution.

The desired candidate will architect the logical/physical Data models,
define the ETL and MetaData repository approach and layout both a short-term
roadmap and long-term Warehouse strategy. The completed Warehouse
environment may consist of multiple disparate source systems to be
consolidated into a robust high performing, quality rich, scalable Data
foundation.

In addition to a strong Data warehousing background, the ideal candidate
will also possess a solid understanding of Enterprise BI solutions.

Position Responsibilities - Detailed:
- Plans, coordinates and administers matters related to database(s),
including base definition, structures, documentation, upgrades, long-range
requirements, operational guidelines and protection.
- Ensures accuracy and completeness of data in master files and
various support tools, such as base dictionaries.
- Establishes and maintains security integrity controls.
- Formulates and monitors policies, procedures and standards
relating to database management.
- May direct the following: troubleshooting, recovery, tuning of the
database, software installation and upgrades, resolving errors and failures,
auditing activities, and resource utilization.
- Creates and manages large scale, highly available production
databases under clustered environments.
- Willing to support production databases in a high quality and
dynamic environment. Occasional off-hours worked required.
- Hands on experience in using tools or custom scripts to monitor
the health of the database.
- Hands on experience with running and interpreting performance
monitoring utilities.
- Strong replication experience, in addition to backup and recovery
implementations either in a stand alone or using recovery man
- Defining ETL (extract, transform, and load) development standards
and conventions.
- Write and maintain database documentation, including data
standards, procedures, definitions for the data dictionary and logical and
physical models of the databases.
- Experience working with Systems Architects to proactively design
and optimize databases and their underlying hardware and OS platforms to
meet future capacity planning needs in a high growth environment.

Required Skills and Competencies:
- 8 or more years experience with the target platform, generally
experienced in other DB platforms, including worked on Sun Solaris/Linux.
Strong UNIX shell scripting preferred.
- OCP 11g certification a plus.
- 3+ years Oracle RAC experience.
- Must have worked on Oracle 9i/10g/11g environments, and Must have
worked on (10G/11G RAC, ASM, OEM 10g grid, Data Guard , Flashback
technology, 9i/10g/11g upgrades, Rolling/Oracle critical patchset
implementation).
- Must have in depth knowledge of Oracle Business Intelligence
Enterprise Edition and Oracle Data Integrator. Create conceptual, logical
and physical models  (ERD, normalized and dimensional models).
- Knowledge of metadata management strategies and implementation,
Conduct requirements gathering and design sessions with customers, Produce
written deliverables for technical designs, Understanding of indexing,
partitioning and data design performance considerations for industry
standard DBMS (Oracle), Understanding of data warehousing design (ETL) and
development best practices. Ability to communicate effectively in a large
distributed software development organization.
- BS in a technical discipline.

Contact Information:
Gary Wright - President - Wright Associates
Phone - (508) 761-6354
Email - ReplyWrightAssociates AT Verizon DOT Net
WEB Site - www.WrightAssociates.org