2,344,773open jobs
147,103companies
284,475added this week
Browse all
Location
In office (Gurgaon)
Seniority
Middle

First seen by Alion on Nov 17, 2026.

Overview
Company
Impact
Profile match
Ginesys provides retail management software covering point of sale and back office. Its platform handles merchandising, inventory, billing and omnichannel order routing. Apparel and lifestyle retail chains form its main customer base.
Backed by Seedfund

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.

Skills

Flyway, Liquibase, PL/PGSQL, PostgreSQL, SQL

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,344,773 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Backend
Similar stack
Same company
Gurgaon
In office · Full-Time · 12+ years exp · Pune
Python
SQL
Scala
Python
pySpark
Databases
Google BigQuery
AI/ML
Spark
DevOps
Puppet
GCP
Chef
Jenkins
Git
Docker
Kubernetes
Configuration Management
TeamCity
Bitbucket
Management
Confluence
Agile
Scrum
Apply
In office · Full-Time · Bengaluru
Go
JavaScript
Java
Node JS
DevOps
GCP
Azure
AWS
Kubernetes
Apply
In office · Full-Time · 8+ years exp · Bachelor's Degree · Bengaluru
Python
Go
JavaScript
Java
TypeScript
SQL
Node JS
Java
Spring Boot
Databases
Redis
Databricks
AI/ML
dbt
Frontend
GraphQL
React.js
DevOps
Datadog
CI/CD
AWS
Kubernetes
AWS Lambda
GitLab
Analytics
A/B Testing
Management
Agile
QA
Playwright
Jest
Apply
Full Stack Engineer 1 hour ago
In office · 5+ years exp · Bengaluru
JavaScript
TypeScript
Node JS
Frontend
Angular
DevOps
Rest API
Management
Agile
Scrum
Apply
Remote (India) · Full-Time · India
Python
Go
Bash
DevOps
Rest API
gRPC
GCP
Prometheus
CI/CD
Git
Docker
Kubernetes
Grafana
Self-Healing
Google GKE
Linux
TCP/IP
DNS
Management
ServiceNow
Apply
Hybrid · Full-Time · Bachelor's Degree · Gurgaon
Apex
Apex
Lightning Web Components
MuleSoft
Visualforce
AI/ML
Claude
Prompt Engineering
AI Agents
LLM
OpenAI
DevOps
Rest API
Azure
CI/CD
AWS
Kubernetes
SOAP
Management
Draw.io
Agile
Scrum
Apply
Analyst Programmer 7 hours ago
In office · Full-Time · Gurgaon · Bengaluru
Python
SQL
Databases
Snowflake
DevOps
CI/CD
Git
Incident Management
Analytics
ETL/ELT
Management
Agile
Apply
Engineer - Highways 5 hours ago
Equity · Hybrid · Full-Time · Gurgaon
Apply
Equity · Hybrid · Full-Time · 4+ years exp · Master's Degree · Gurgaon
Apply
Operations Manager 5 hours ago
In office · Full-Time · 10+ years exp · Noida · Gurgaon
Apply
See all jobs
This is one of many
2,344,773 more open roles from verified company boards, updated every day.