Experience: 10+ Years | Department: Data Engineering | Location: Dayal Infosystems

Role Overview

Dayal Infosystems is seeking a Data Architect to lead the architecture, design, modernization, and lifecycle management of our enterprise data ecosystem. In this role, you will own the overarching data strategy across transactional databases, data warehouses, file systems, and data lakes supporting our core product suite.

You will be responsible for bridging the gap between high-throughput OLTP systems and modern analytical data platforms (OLAP/Lakehouse), ensuring ultra-high availability, security, scalability, and performance across all product data layers.

Key Responsibilities

Enterprise Data Architecture & Modernization
Architect, build, and maintain scalable data platforms, encompassing relational databases, NoSQL stores, object storage, modern data warehouses, and data lakes.
Design and execute zero-downtime database migration, consolidation, and modernization strategies across hybrid or cloud environments.
Lead architecture patterns including OLTP vs. OLAP, CQRS,



Read/Write Separation, Sharding, Distributed Databases, and Event-Driven Architectures.
Analytical & Lakehouse Ecosystem
Drive the design of modern analytical architecture (Medallion Architecture: Bronze, Silver, Gold layers) for product analytics and reporting.
Architect real-time and batch data pipelines utilizing Change Data Capture (CDC), Debezium, and Kafka for seamless integration between operational databases and analytical stores.
Evaluate and implement contemporary Data Lakehouse frameworks, storage formats, and query engines.
Database Engineering & Performance Optimization
Serve as the deep technical expert for core relational databases (with a heavy focus on MySQL 8.x ecosystem and engine internals).
Design robust High Availability (HA), Disaster Recovery (DR), GTID Replication, and backup/restore strategies to ensure near-zero RPO and RTO.
Optimize complex SQL queries, index structures, schema

📌 Data Architect (Meerut)
🏢 Dayal Group
📍 Meerut