Associate Database Developer

SIONIQ - JOS; Ernakulam; On-site; INR 301,000 - 312,000; Full time

Job summary

SIONIQ - JOS in Ernakulam, Kerala is seeking an Associate Database Developer to design, implement, and manage robust, scalable database systems supporting ERP modules and business-critical applications. You will translate requirements into tables, relationships, and constraints, and collaborate with .NET developers to align with EF Code First entities.

The role emphasizes SQL proficiency, ER modeling, documentation, and attention to detail, with a focus on performance optimization, indexing

Qualifications

• Strong basics in RDBMS concepts including normalization and keys.
• Good SQL skills: SELECT, JOINs, GROUP BY, subqueries, CTEs, DDL and DML.
• Understanding of ER modeling and how to read or draw ER diagrams.
• Ability to translate business scenarios into data models.
• Clear written communication for developers.

Responsibilities

• Design tables, relationships and constraints for new ERP modules.
• Turn functional requirements and UI prototypes into table and column mappings.
• Prepare design documentation for tables and prototypes for developers.
• Write query logic documents for API development: tables, joins, filters, calculations and business rules.
• Create ER diagrams (DBML / dbdiagram.io) for each module.
• Collaborate with .NET developers to map schema to EF Code First entities.
• Suggest indexes for high-volume transaction tables.

Skills

RDBMS basics

SQL proficiency

ER modeling

Analytical thinking

Documentation

English communication

Education

Bachelor's degree in CS/IT

Tools

SQL Server

C# / .NET

Entity Framework

dbdiagram.io

Python

Job description

Job Overview

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.

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).
• Probation Period: 6 Months
• 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.