Data Architect - Oracle & Microservices Data Modeling

Notice Period : Immediate Only Mandatory

Location : Any PWC Office

Exp: 10 + Years

Job Description :

Role Summary : Data Architect Oracle & Microservices Data Modeling

Focus Area : Oracle, Data Modeling, PL/SQL, Normalization, Entity Relationship Diagrams (ERDs), Microservices Architecture, Data Assessment, Domain-Driven Design (DDD), API Contracts, Agile

Required Skills: Oracle Database administration, Data modeling, data migration approach

Overall Experience Requirement :

- 5+ years of experience working with Oracle (PL/SQL, schema design, performance tuning).

- 3+ years of experience designing data models for microservices or distributed architectures.

Role Description :

- Assess and document existing relational data models, focusing on Oracle-based systems and legacy applications.

- Identify dependencies, shared schemas, and tightly coupled data entities across business domains.

- Define target-state logical and physical data models aligned with microservices and bounded context principles.

- Design data partitioning, ownership boundaries, and communication patterns (e.g., eventing, API contracts) between microservices.

- Collaborate with application architects, integration teams, and domain owners to align data models with service boundaries.

- Provide guidance on data migration, transformation, and reconciliation strategies during the separation process.

- Ensure data security, compliance, normalization, and performance in target-state models.