An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
Job Description
- 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.
- 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.
- 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.
Skills
PythonC#SQL.NETExcelSQL ServerAccountingIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
Similar Jobs
View allNew IT / Software Development & Related roles in Kochi.
One email a day. Unsubscribe any time.

