EDW/DW INFRASTRUCTURE ARCHITECT

Target Labs, Inc; Columbus (IN); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading technology company is seeking an experienced Database Architect to support EDW projects and manage database standards. The ideal candidate will have 9-10 years of IT experience, with strong Oracle Database expertise and a solid background in data warehousing. This role involves coordinating with various teams, optimizing systems for performance, and ensuring smooth implementation of database changes.

Qualifications

• 9-10 years of IT experience.
• Strong knowledge of Oracle Database Architecture and Design from DW/EDW aspect.
• Experience in different types of BI/DW projects.

Responsibilities

• Creating and maintaining standards for Database Objects and Code promotion.
• Support ongoing EDW Projects and prepare initial database setup guidelines.
• Coordinate with external teams for infrastructure-related issues.

Skills

Oracle Database Architecture

Data Warehousing

Unix Shell Scripting

Data Modeling

Linux

Performance Optimization

Job description

• 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.
• - Should have good Unix shell scripting skills.