SDE 2 Database

Ginesys

Gurugram District

On-site

INR 1,200,000 - 1,600,000

Full time

5 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
Health insurance
Recognition policy
CTC transparency
Annual off-site
Travel opportunities
Coffee with the CEO

Job summary

Ginesys is seeking a Software Engineer – Database (PostgreSQL) to join our Product Engineering team in Gurugram. Move business logic out of stored procedures, design clean data models, and write migration scripts to safely transition clients.

You will work with Data Architects, QA, and DevOps on data modelling, migration, archival, and performance tuning for large enterprise ERP databases, with AI-assisted development and modern cloud-native practices.

Qualifications

  • Deep hands-on PostgreSQL skills including PL/pgSQL, triggers and views.
  • Strong data modelling, normalisation, keys, constraints and partitioning.
  • Experience migrating large datasets and reconciling data.
  • Familiarity with Flyway or Liquibase for migrations.
  • Ability to read complex legacy SQL and stored procedures.

Responsibilities

  • Analyse existing procedures, functions and triggers and document logic.
  • Design normalised data models for ERP domains.
  • Write and maintain migration scripts (Flyway).
  • Develop PL/pgSQL functions and rework routines to new models.
  • Create compatibility views to preserve reports.
  • Write data conversion and reconciliation queries for financials, stock and tax.
  • Build data archival and restore processes.
  • Optimize queries, indexes and views for large clients.
  • Leverage AI tools to assist SQL writing and validation.

Skills

PostgreSQL
PL/pgSQL
SQL optimization
Data modelling
Data migration
Git
AI-assisted development
Performance tuning

Education

Bachelor's degree in CS/IT

Tools

Flyway
Liquibase

Job description

Job 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
  • 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

Ginni Systems Ltd. • Gurugram District

On-site
INR 1,500,000 - 2,800,000
Ginesys Academy for holistic training
Comprehensive health insurance
Rewards and recognition policy
+2
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. • Chandigarh

On-site
INR 900,000 - 1,500,000
Ginesys Academy
Rewards program
Transparent compensation policy
+4