SDE 2 – Database

Ginni Systems Ltd.

Gurugram District

On-site

INR 1,500,000 - 2,800,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Ginesys Academy for holistic training
Comprehensive health insurance
Rewards and recognition policy
Transparent compensation policy
Annual off-site and company events

Job summary

Ginesys is India’s leading retail technology platform powering 1,200+ customers and 50,000+ users through a unified suite. We seek a Software Engineer – Database (PostgreSQL) to modernize our Retail ERP, moving business logic from stored procedures to clean data models and safe migration scripts.

You’ll collaborate with Data Architects, QA, DevOps, and Teams to rewrite legacy SQL, optimize performance, and build scalable data services.

Qualifications

  • Proficient in PostgreSQL with PL/pgSQL, triggers and views.
  • Strong SQL optimization and data modelling skills.
  • Experience migrating large datasets with Flyway or Liquibase.
  • Ability to read and refactor legacy SQL code.

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.

Skills

PostgreSQL
SQL optimization
Data modelling
Git
Agile/Scrum
AI-assisted development
Legacy SQL
Multi-tenant databases
C# / .NET basics

Education

Bachelor's or Master's in Computer Science / IT

Tools

Flyway
Liquibase

Job description

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
  • 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.
  • Strong data modelling skills: normalisation, keys, constraints, and partitioning.
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
  • Stored Procedure and Trigger Refactoring
  • Data Migration and Reconciliation
  • Data Archival
  • High-volume Transaction Processing
  • Performance and Scalability Engineering
What We Look For
  • 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

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SDE 2 Database
SDE 2 Database

Ginesys • Gurugram District

On-site
INR 1,200,000 - 1,600,000
Ginesys Academy
Health insurance
Recognition policy
+4
SDE 3
SDE 3

Ginesys • India

Remote
INR 2,600,000 - 4,200,000
Ginesys Academy for holistic training
Excellent rewards and recognition
Annual off-site and events
+2
Senior Architect
Senior Architect

Ginni Systems Ltd. • Kolkata

On-site
INR 4,000,000 - 7,000,000
Ginesys Academy
Health insurance
Rewards policy
+3
VP - Platform
VP - Platform

Ginesys • Gurugram District

On-site
INR 5,000,000 - 9,500,000
Ginesys Academy for holistic training
Rewards and recognition policy
Transparent compensation policy
+4
QA Engineer (Automation)
QA Engineer (Automation)

Ginni Systems Limited • Kolkata

On-site
INR 1,100,000 - 1,900,000
Ginesys Academy for holistic training
Comprehensive health insurance
Excellent rewards and recognition
+2
QA Engineer
QA Engineer

Ginni Systems Ltd. • Gurugram District

On-site
INR 900,000 - 1,300,000
Ginesys Academy for holistic training
Comprehensive health insurance
Annual off-site
+2
Product Manager
Product Manager

Ginni Systems Ltd. • Gurugram District

On-site
INR 2,500,000 - 4,200,000
Ginesys Academy for holistic training
Excellent rewards and recognition
Transparent compensation policy
+3
Principal SDET
Principal SDET

Ginesys • Gurugram District

On-site
INR 4,200,000 - 7,000,000
Ginesys Academy
Rewards & recognition
Transparent compensation
+4
Business Development Manager
Business Development Manager

Ginni Systems Ltd. • Lucknow

On-site
INR 600,000 - 1,200,000
Ginesys Academy for holistic training
Excellent rewards and recognition
Transparent compensation policy withno
Business Development Manager
Business Development Manager

Ginni Systems Ltd. • Indore District

On-site
INR 600,000 - 1,200,000
Ginesys Academy
Rewards program
Transparent compensation
+4