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.

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

•
• Robust 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.
• Positive written and spoken English.

Valuable 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 f

📌 Associate Database Developer Kochi
🏢 Sioniq - JOS
📍 Kochi