Oracle Database Administrator with Dimensional Data Modeling

JOB DESCRIPTION

We are seeking an experienced Oracle Database Administrator with strong expertise in Dimensional Data Modeling to manage, maintain, and support Oracle databases for a 12-month contract engagement.

Key Responsibilities:

• Manage, maintain and support Oracle databases including schema design, data storage, performance monitoring and routine maintenance activities
  
• Focus on the design and maintenance of conceptual and logical data models (3NF) and their application within IT project and business data governance processes
  
• Define data modelling standards and apply within all work products
  
• Own and develop artefacts that exploit data models to understand data and data integrations, including modelling data flows and developing CRUD matrices to understand master data
  
• Analyze complex datasets to identify trends, anomalies, data gaps and business insights that support decision making
  
• Ensure accuracy, consistency, completeness and integrity of data across Oracle-based systems through validation and quality checks
  
• Work with multiple IT roles including Data Analysts, Solution Architects and Information Architects to embed the use of data models within both project and strategic activities
  
• Work with business data governance teams to embed the use of data models and associated definitions within governance processes
  
• Build expert level knowledge of business data and apply in the creation of data models and supporting artefacts describing R&D data and data flows
  
• Locate and define new process improvement opportunities
  

REQUIREMENTS

Mandatory Skills:

• Dimensional Data Modeling
  
• Experience with Oracle Database and proficiency in SQL, PL/SQL and database query optimization
  
• Experience of developing and applying conceptual and logical data models (3NF)
  
• Experience of using at least one data modelling tool, ideally ERStudio or Erwin
  
• Understanding of fundamental design principles behind a scalable application and data design
  
• Strong exposure to IT Project Lifecycle
  
• Life Science Domain Experience
  
• Ability to interpret and communicate technical information into business language
  

Educational Background:

• Bachelors or Masters Degree from a reputed institution
  

Experience: 8+ years
Duration: 12 Months
Location: PAN India