8300 Old courthouse road, Suite. 250, Vienna, VA - 22182
EDW/DW INFRASTRUCTURE ARCHITECT
06-27-2012
EDW/DW INFRASTRUCTURE ARCHITECT
Title: EDW/DW Infrastructure Architect
Location: Columbus, IN
Job Profile/Responsibilities:
Activities
Creating and Maintaining standards, guidelines and operating procedures for Database Objects and Code promotion
As a Reviewer
Participate in EDW project design reviews
Review PDM and recommend changes with performance, storage best practices in mind
Review security considerations, security exceptions .
Question impact analysis on shared objects.
Support ongoing EDW Projects
Initial Database setup guidelines (Requests for schema, role, table spaces).
Process for Physical data model deployment / changes.
Co-ordinate code promotion with the appropriate support groups.
Coordination with external teams
With Apps and Ops DBA teams in case of issues, backup/restore and day to day activities.
With Oracle support for any service requests with help of Apps DBA Team.
With the Ops Unix teams in case of infrastructure(server and OS) related issues and day to day activities.
Database and infrastructure capacity planning for future projects within the EDW program.
Co-ordination with the external teams to arrange the needed capacity.
Work closely with the Business Intelligence and Data warehousing organizations in identifying and planning the Infrastructure optimization for lower cost & higher performance.
Work towards continuous improvement of project processes, performance, manual activities etc.
Co-ordinate with the CEA team to align EDW Technology stack to the tools and technology roadmap.
Work with the CEA and CBS teams on pilot/proof of concept projects related to infrastructure and tools changes impacting EDW.
Interact with Project Manager and Business users on a day-to-day and develop a detailed understanding of issues of the operation to meet the requirements.
Required Skills:
- 9-10 years of IT experience.
- Strong knowledge of Oracle Database Architecture and Design from DW/EDW aspect.
- Should have experience in different types of BI/DW projects like Development, Support, Enhancements and Admin exp/knowledge to related SW/Tools (such as ETL, OBIEE, Appworx etc).
- Experience with Solaris, Linux and RAC.
- Exposure/experienced in aspects of data modeling. Experience in Erwin will be an added advantage.
- Experience in Architecture, Design and implementation of Large scale Data warehouses.
- Extensive knowledge on Application to application interaction.
- Some exposure to Data warehouse Performance optimization concepts.