ID: 2913 | 8-12 yrs | Bengaluru

Roles and Responsibilities:
Role Overview
- As a Data Architect, you will own the conceptual, logical, and physical design of data models, with a robust focus on PostgreSQL-based platforms. You will translate business requirements and source-system structures into well-governed schemas, data contracts, integration patterns, and implementation standards.
- This role is ideal for professionals who combine strong data modeling capabilities with hands-on PostgreSQL, advanced SQL, and Python skills and who can guide delivery teams from architecture through implementation and production optimization.
- Key Responsibilities
- Data Architecture & Modeling
- Create and maintain conceptual, logical, and physical data models based on business processes, reporting needs, source-system structures, and non-functional requirements.
- Design normalized, denormalized, canonical, and dimensional models and select the appropriate modeling pattern for each use case.
- Define entities, attributes, relationships, keys, constraints, reference data, hierarchies,



and business rules.
- Develop source-to-target mappings, data dictionaries, naming standards, metadata specifications, and model documentation.
- Review existing data models and recommend improvements for scalability, consistency, reuse, performance, and maintainability.
- PostgreSQL Architecture & Engineering
- Design PostgreSQL schemas, tables, views, materialized views, sequences, constraints, indexes, and partitioning strategies.
- Analyse and optimize database performance using execution plans, indexing, statistics, query tuning, partition pruning, and workload analysis.
- Provide guidance on PostgreSQL configuration, high availability, backup and recovery, replication, capacity planning, and operational support.
- Support cloud-hosted PostgreSQL platforms, including Amazon RDS or Aurora PostgreSQL, where applicable.
- Establish database development standards, migration practices, version contr

📌 Architect - Database (Bengaluru)
🏢 JK Tech
📍 Bengaluru