Associate Database Developer

Keka Inc.; Ernakulam; On-site; INR 254,000 - 304,000; Full time

Job summary

Keka Inc. is seeking an Associate Database Developer to design, implement, and manage robust, scalable database systems for ERP modules.

You will translate requirements into table structures, ER diagrams, and mappings, and collaborate with .NET developers to integrate schemas with Entity Framework Code First. The role emphasizes data modeling, performance tuning, and adherence to naming and documentation standards.

Qualifications

• Bachelor's degree in computer science, information technology, or related field.
• Strong fundamentals in relational databases and data modeling.
• Solid SQL knowledge: complex queries, joins, subqueries, CTEs, DDL/DML.

Responsibilities

• Design tables, relationships and constraints for ERP modules following design standards.
• Translate requirements into table/column mappings and API query logic.
• Prepare design docs for tables and prototypes for frontend developers.
• Create ER diagrams (DBML/dbdiagram.io) for modules.
• Collaborate with .NET developers to map schema to EF Code First.
• Suggest indexes for high-volume tables.

Skills

RDBMS basics

SQL skills

ER modeling

Logical thinking

Documentation writing

Attention to detail

English proficiency

Education

Bachelor's degree in CS/IT

Tools

dbdiagram.io

DBML

Excel

SQL Server

Entity Framework / .NET

Job description

We are seeking an Associate Database Developer to design, implement, and manage robust, scalable, and secure database systems. The ideal candidate will be responsible for defining database architecture, ensuring performance optimization, and supporting business-critical applications.

Key Responsibilities:

• Design tables, relationships and constraints for new ERP modules, following SIONIQ SQL naming and design standards.
• Turn functional requirements and UI prototypes into table and column mappings.
• Prepare design documentation for tables and prototypes, so developers can build each screen.
• Write query logic documents for API development: which tables to use, joins, filters, calculations and the business rules behind each screen or report.
• Create ER diagrams (DBML / dbdiagram.io) for each module.
• Work with .NET developers to explain the schema and query logic and help them map it to Entity Framework Code First entities.
• Suggest indexes for high-volume transaction tables.

Required Skills & Qualifications:

• Strong basics in RDBMS concepts: normalization (1NF to 3NF), primary and foreign keys, joins, constraints and indexes.
• Good SQL skills: SELECT, JOINs, GROUP BY, subqueries, CTEs, DDL and DML.
• Understanding of ER modeling and how to read or draw ER diagrams.
• Logical thinking and the ability to turn a business scenario into a data model.
• Ability to explain logic clearly in writing so developers can build from it.
• Attention to detail and discipline in following naming and documentation standards.
• Good written and spoken English.

Good To Have:

• Hands-on practice with SQL Server (academic projects count).
• Basic knowledge of C# / .NET or Entity Framework.
• Python for scripting or automation.
• Familiarity with dbdiagram.io, DBML, Excel or any data-modelling tool.
• Interest in ERP systems, accounting or inventory domains.

Eligibility Criteria

Bachelor’s degree in computer science, Information Technology, or related field. (No backlogs) 2024 and above pass-outs

Strong academic performance with project/internship experience.

Terms of Employment

Agreement Period: 3 Years from the date of joining (including probation).

During probation, working days will be 6 days a week.

After successful completion of probation, regular working days will be 5 days a week.

Performance Review: Regular assessments during probation for confirmation and future growth planning.

Salary – 25000 CTC, Net in hand around 18500. Performance variable pay 2500/month (will be released yearly based on performance). Revisions after 1 year.