Dayal Group
Data Architect
Meerut, India
hirly Pro
Get in front of the people hiring at Dayal Group
- Reach the hiring manager at Dayal Group on LinkedIn, from your own account
- hirly applies to this job for you, with unlimited applications
- A resume and cover letter written for this job, unlimited
- The hiring manager and recruiter at Dayal Group, with contact details
$49 a month · ₹1,999 for 30 days in India · cancel any time
Get past the screening software and onto a recruiter's desk
hirly rewrites your resume for this job — matching the keywords and skills in the posting, moving your most relevant experience to the top, and writing a cover letter to fit. About 30 seconds.
- Keywords matched to this posting
- Fit score before you apply
- Cover letter included
Matched against 2.8M live jobs from 220,000+ employers in 200+ countries.
Tailor my resume for this job →Apply from your AI assistant
Connect hirly to Claude or ChatGPT and ask it to apply to this job. hirly tailors your resume, fills the employer’s form and asks before sending.
Some employer sites stop an application at a CAPTCHA or sign-in and hand it back with a link. Applying needs a paid plan. Works with any assistant that supports MCP.
hirly's read of this role
- Seniority
- Mid level
- Country
- IN
- Work mode
- On-site / unstated
- First seen by hirly
- 23 Sept 2026
Derived automatically from the posting. Upload your resume above to see how the role scores against it.
the posting
Data Architect
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
1. 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 .
2. 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 modern Data Lakehouse frameworks, storage formats, and query engines.
3. 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 designs, transaction models, locking strategies, and execution plans for mission-critical production systems.
4. Data Governance, Security & Compliance
- 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.
5. Strategy, Operations & Mentorship
- 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.
Qualifications & Skills
Must Have
- 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.
Good to Have
- 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).
Education
Bachelor's or Master's degree in Computer Science, Information Technology, Software Engineering, or a related field.
Listed on hirly, a job board. hirly is not the employer: Dayal Group is hiring for this role.
Similar jobs
- Microsoft Dynamics 365 F&O Data ArchitectThe HR Ally · Bangalore, Karnataka, IndiaFirst seen 6d ago
- Data ArchitectAccentureFirst seen 7d ago
- Data ArchitectAccentureFirst seen 7d ago
- Snowflake Data ArchitectSolvd · Pune, IndiaFirst seen 10d ago
- Data ArchitectHeinz · Bengaluru - Brookfield GCCFirst seen 10d ago
Browse similar roles
Want this one?
Upload your resume and hirly rewrites it for this job and writes the cover letter — in about thirty seconds, before you sign up.
Tailor my resume for this job