oracle jobs

About Company

A multi-billion IT MNC strengthening their India Technical Leadership at Chennai India through chosen lead architects who as part of a small elite distributed team will directly contribute to the architecture evolution


Job Description

Organization: A multi-billion IT MNC

Position: Oracle Database Architect

Location: Chennai, India

Responsibilities

· Responsible for the design, development, and implementation and re-engineering of the foundation for managing the reporting systems

· Maintain the data architecture and its components to ensure that it supports the overall reporting architecture and meets the overall functionality, system scalability and performance requirements

· Ensure that the architecture and systems are sufficiently flexible to support the numerous changes to the reporting databases required over time

· Design, develop and maintain data models and related data components

· Tune reporting applications at all levels [Database, SQL, middleware and application logic]

· Provide Reporting solutions which can scale up and meet performance requirement

· Develop metadata standards for all data components, data models and business rules

· Determine potential data aggregations

· Develop change management and control processes and procedures for all standards, data definitions, data model, business rules and metadata

· Attend all walkthroughs/reviews for data requirements gathering, data models and database designs

· Provide support to other team members in the development of a comprehensive metadata solution

· Interact with Production database managers and develop business rules, data mapping and data lineage and audit standards in conjunction with them.

· Job requires working closely with divergent teams like Developers/QA/DBA/SA

Skills Required

· Excellent Data Modeling, Data Analysis skills

· Excellent Application performance analysis/tuning, SQL tuning skills

· Ability to tune SQLs at all levels including Database, middleware and application logic

· Extensive skills in design, development and maintenance of data models and its components, Database Design and development

· Knowledge of performance tuning of Physical databases and conceptual understanding of the internal architecture of the underlying RDBMS

· Project planning and management, Requirements Elicitation skills

· Data integration, Data warehouse/Reporting development and management

· Knowledge and skills in Dimensional modeling highly desirable

· Excellent communication, facilitation and presentation skills

Qualification and Experience

· Bachelors in Engineering/MCA or higher

· 8+ years of IT experience primarily in DB Application Programming/ Administration/ Performance Tuning

· 2+ years of specific experience on application performance analysis and tuning essential

· 4+ years experience with logical data modeling with Oracle and two years dimensional modeling

· 3+ years of experience with physical database design in Oracle and in developing data, data model and databases standards and/or business rules standards

· 3+ years of experience with SQL is a must

· 3+ years of experience with Oracle DB Administration desirable

2+ years of experience with multi-terabyte data warehouses essential