Hiring.Camp

SDE 2 – Database

Ginni Systems Ltd.

·

Today

Location
Gurgaon, India · Kolkata, India
Department
IT
Seniority
Mid
Education
Master
Source
Keka

Description

About Ginesys
Ginesys is India's leading retail technology platform, powering 1,200+ customers and 50,000+ users through the unified GinesysOne suite — ERP, Cloud POS (Zwing), Order Management (Browntape), GST Compliance (EaseMyGST), and BI (InsightX). We are evolving from a System of Records to a System of Intelligence through Ginesys.AI.

About the Role

We are seeking a Software Engineer – Database (PostgreSQL) to join our Product Engineering team and help drive the modernization of our Retail ERP platform. You will move business logic out of stored procedures and triggers, design clean new data models, and write the conversion and reconciliation scripts that move clients to them safely.
This role requires deep hands-on PostgreSQL skills, strong data modelling, and the ability to read complex legacy SQL. You will work closely with Data Architects, Technical Leads, QA, and DevOps.

Key Responsibilities

  • Analyse existing stored procedures, functions, and triggers and document the business logic they contain.
  • Design normalised tables and data models for ERP business areas.
  • Write and maintain database migration scripts (Flyway).
  • Develop PL/pgSQL functions and procedures, and rewire existing routines to the new data model.
  • Build compatibility views so existing reports keep working.
  • Write data conversion scripts and reconciliation queries for financial, stock, and tax data.
  • Build data archival and restore processes.
  • Optimize queries, indexes, and views for large client databases.
  • Use AI tools to write and check SQL, and review and test what they produce.

Required Technical Skills

PostgreSQL

  • Strong hands-on experience with PostgreSQL: PL/pgSQL functions and procedures, triggers, and views.
  • Expertise in SQL query optimization, indexing strategies, execution plan analysis, and performance tuning.

Data Modelling

  • Strong data modelling skills: normalisation, keys, constraints, and partitioning.
  • Experience designing scalable database schemas for enterprise applications.

Data Migration

  • Experience with data migration, conversion, and reconciliation on large datasets.
  • Experience with database migration tools such as Flyway or Liquibase.

Legacy Code

  • Ability to read and understand complex legacy SQL and stored procedures.

AI-assisted Development

  • Comfortable using AI coding tools in daily development.

Version Control

  • Experience with Git.
  • Experience working in Agile/Scrum environments.

Team Responsibilities

  • Review database changes for correctness and performance.
  • Document data models and database logic.
  • Work with development teams on data access patterns.

Preferred Skills

  • Experience migrating from SQL Server or Oracle to PostgreSQL.
  • Experience with multi-tenant (database-per-client) setups.
  • Basic C# / .NET knowledge.
  • Domain knowledge of retail, ERP, accounting, or inventory systems is highly desirable.

Educational Qualification

  • Bachelor's or Master's degree in Computer Science, Information Technology, or a related discipline.

What You'll Work On

  • Enterprise Retail ERP Platform
  • Data Model Modernization
  • Stored Procedure and Trigger Refactoring
  • Data Migration and Reconciliation
  • Data Archival
  • High-volume Transaction Processing
  • Performance and Scalability Engineering

What We Look For

  • Deep hands-on database skills.
  • Excellent analytical and problem-solving skills.
  • Precision with data and numbers.
  • Ownership mindset with a focus on delivering business value.
  • Good communication with development teams.

Why Join Us

  • Opportunity to modernize a large-scale enterprise Retail ERP platform.
  • Work on cloud-native, event-driven, and distributed systems.
  • Solve challenging scalability and performance problems.
  • Collaborate with experienced architects and product engineering teams.
  • Play a key role in shaping the technical direction of a mission-critical product
Benefits:
We like to think that talent grows at Ginesys and stays at Ginesys. To ensure this, we provide our employees with the best working environment, the latest technology and continuous support. We go out of our way to retain the small business feeling with which we started and stimulate innovation and collaboration through teamwork and our non-hierarchical approach. We offer competitive salary, and other fantastic perks and benefits, such as:
Ginesys Academy for holistic training and development Comprehensive health insurance coverage Excellent rewards and recognition policy
Transparent compensation policy with no unnecessary deduction in CTC Annual company off-site and a variety of events, celebrations throughout the year
Travelling opportunities between our offices across the country. Annual Ginesys walkathon & related sporting events. Quarterly Coffee with the CEO and more!

Here’s our story; now tell us yours
Ginesys is India’s best omni retail suite backed by Ginesys, the first integrated Retail specific ERP software for online retail, offline retail and distribution. It is the largest Indian company in the retail tech industry catering to both online and offline needs. 1200 + brands including (Manyavar, V-Mart, Skechers) are accelerating their businesses with Ginesys. With a team of 400+ employees, Ginesys One plans to revolutionize retail by being a single-stop cloud-based retail suite. We have a pan India presence with offices in major cities including Gurgaon, Kolkata, Bangalore, Hyderabad, Mumbai, Coimbatore & Goa and are expanding rapidly. We love the challenges of retail and are busy solving them to create a great retail tech suite. Ginesys core mission is to continue to build world-class internal service capabilities, in a bid to deliver outstanding external service value to customers. We are an ISO-certified and SOC compliant company having won myriad awards for our innovation and support. For further information, please visit our website http://ginesys.in


Skills

SQLPostgreSQLOracleSQL ServerGitSOCAgileScrumDevOpsComplianceERP

Similar Jobs

30

SDE 2

Ginni Systems Ltd.·Kolkata, West Bengal +1

Today

Software Development Engineer 2

Amazon Company·Remote

SDE 2

AiDASH·Bengaluru, Karnataka

2mo ago

Software Development Engineer - 2

SatSure Analytics India·Mumbai, Maharashtra

3mo ago

Software Development Engineer 2

Adobe·San Jose, California·Remote, Onsite

5mo ago

Software Development Engineer - 2

Brightchamps·India·Remote

8mo ago

Software Development Engineer III-2

Clearwateranalytics·Office - Bengaluru, India

Today

SDE-2, AI Authoring, Technical Content Experience (TCX) Engineering

Amazon Company

Software Development Engineer – (SDE-2)

Payinstacard·Hyderabad, Telangana

4d ago

Software Engineer 2 – Wireless Access Point Development

Hewlett Packard Enterprise (HP)·Cupertino, California +1·Hybrid

1w ago

Software Engineer 2 – Wireless Access Point Development

Hewlett Packard Enterprise (HP)·Cupertino, California +1·Hybrid

1w ago

Software Engineer 2 – Wireless Access Point Development

Hewlett Packard Enterprise (HP)·Cupertino, California +1·Hybrid

1w ago

Software Engineer 2 – Wireless Access Point Development

Hewlett Packard Enterprise (HP)·Cupertino, California +1·Hybrid

1w ago

Software Engineer 2 – Wireless Access Point Development

Hewlett Packard Enterprise (HP)·Cupertino, California +1·Hybrid

1w ago

Software Engineer 2 – Wireless Access Point Development

Hewlett Packard Enterprise (HP)·Cupertino, California +1·Hybrid

1w ago

Software Engineer 2 – Wireless Access Point Development

Hewlett Packard Enterprise (HP)·Cupertino, California +1·Hybrid

1w ago

Software Engineer 2 – Wireless Access Point Development

Hewlett Packard Enterprise (HP)·Cupertino, California +1·Hybrid

1w ago

Software Engineer 2 – Wireless Access Point Development

Hewlett Packard Enterprise (HP)·Cupertino, California +1·Hybrid

1w ago

Security Engineer - Offensive Security Team (SDE 2) -

Kredivo Group

Software Development Engineer 2-2

WEX·India

1w ago

Enterprise Security Engineer (SDE 2)

Kredivo Group

IT GRC Specialist (SDE 2)

Kredivo Group

Python Developer | SDE 2 | JCP

Fynd·Mumbai, Maharashtra·Onsite

3w ago

Android - SDE 2

Primetrace Technologies·Mumbai, Maharashtra

1mo ago

Fullstack Developer | SDE 1/2 | Commerce

Fynd·Mumbai, Maharashtra·Remote

1mo ago

Software Engineer 2 - Development Infrastructure

Abnormalsecurity·US·Remote

SDE 2 - Backend

Seekho·Bengaluru, Karnataka

Backend Engineer (SDE-2)

rfcareers·Bengaluru, Karnataka

1mo ago

SDE 2 Infra

Fampay·Bengaluru, Karnataka·Onsite

1mo ago

Software Development Engineer 1-2

WEX·India·Remote, Hybrid, Onsite

1mo ago