The Role
Leads enterprise data architecture, modernization, and lifecycle management across OLTP, OLAP, lakehouse, relational, NoSQL, and cloud platforms. Designs highly available databases, migrations, streaming and CDC pipelines, governance controls, security, disaster recovery, and performance optimization. Partners with engineering and product teams, evaluates data technologies, conducts incident analysis, and mentors data engineers, DBAs, and developers.
Summary Generated by Built In
Data Architect
Experience: 10+ Years | Department: Data Engineering | Location: Dayal Infosystems
Role OverviewDayal 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 Responsibilities1. 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.
- 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 modern Data Lakehouse frameworks, storage formats, and query engines.
- 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 designs, transaction models, locking strategies, and execution plans for mission-critical production systems.
- Establish and enforce company-wide data standards for security, compliance, data quality, lineage, and metadata management.
- Implement robust access controls including Least-Privilege Access, Row-Level Security (RLS), Column-Level Security, encryption (at-rest/in-transit), data masking, and audit logging.
- Conduct Root Cause Analysis (RCA) on complex, cross-system performance bottlenecks and production incidents.
- Collaborate with Software Engineering, DevOps, Infrastructure, and Product Leadership to align data capabilities with product roadmaps.
- Benchmark and evaluate emergent data technologies based on performance, cost efficiency, reliability, and scale.
- Mentor data engineers, DBAs, and software developers on schema design, query optimization, and architectural best practices.
- 10+ years of progressive experience in Database Engineering, Database Administration, and Data Architecture for enterprise-grade product environments.
- Deep technical expertise in MySQL 8.x (innodb mechanics, performance tuning, replication topologies, HA/DR setups).
- Proven track record in Data Architect roles, designing both transactional (OLTP) and analytical (OLAP/Data Lake/Data Warehouse) systems at scale.
- Hands-on experience with streaming & CDC architectures (e.g., Kafka, Debezium, Canal, or similar tools).
- Strong understanding of Medallion Architecture, distributed data storage, and modern file formats (Parquet, ORC, Avro, Delta/Iceberg).
- Expertise in database security controls (RLS, encryption, masking, auditing) and automated database management.
- Strong proficiency in Linux environments, shell scripting, and automation.
- Hands-on experience with multi-database stacks: PostgreSQL, MongoDB, Redis, Cassandra, Elasticsearch, or ClickHouse.
- Experience with enterprise MySQL environments (MySQL Group Replication, Galera, Percona XtraDB Cluster).
- Deep experience with Cloud Native Database & Analytics platforms (AWS RDS/Aurora, Redshift, Snowflake, Databricks, BigQuery, or Azure Synapse).
- Experience with Infrastructure as Code (IaC) for data infrastructure (Terraform, Ansible) and Data Orchestration tools (Airflow, Dagster).
- Bachelor's or Master's degree in Computer Science, Information Technology, Software Engineering, or a related field.
Skills Required
- 10+ years of progressive experience in database engineering, database administration, and data architecture for enterprise product environments
- Deep technical expertise in MySQL 8.x, including InnoDB mechanics, performance tuning, replication topologies, and high-availability/disaster-recovery setups
- Proven experience designing transactional OLTP and analytical OLAP, data lake, and data warehouse systems at scale
- Hands-on experience with streaming and change data capture architectures, such as Kafka, Debezium, or similar tools
- Strong understanding of Medallion Architecture, distributed data storage, and modern file formats including Parquet, ORC, Avro, Delta, and Iceberg
- Expertise in database security controls, including row-level security, encryption, masking, auditing, and automated database management
- Strong proficiency in Linux environments, shell scripting, and automation
- Bachelor's or Master's degree in Computer Science, Information Technology, Software Engineering, or a related field
- Experience with PostgreSQL, MongoDB, Redis, Cassandra, Elasticsearch, or ClickHouse
- Experience with MySQL Group Replication, Galera, or Percona XtraDB Cluster
- Experience with cloud-native database and analytics platforms such as AWS RDS/Aurora, Redshift, Snowflake, Databricks, BigQuery, or Azure Synapse
- Experience with Infrastructure as Code using Terraform or Ansible and data orchestration tools such as Airflow or Dagster
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Dayal Group is a diversified Indian agribusiness focused on improving crop and livestock productivity. It manufactures and markets plant nutrient and water-soluble fertilizers, micronutrients, organic fertilizers, biofertilizers, pesticides, improved and hybrid seeds, and plant growth products. Its animal-feed operations provide nutrition products for dairy cattle, poultry, and aquaculture, supporting farmers with agricultural inputs designed to increase yields.
