SDE 2 – Database

Posted: 52 minutes ago
2-5 years
Gurgaon, India | Kolkata, India
work from office
Full Time
Closes 16 Jan 2027

Posted: 52 minutes ago
Let Jobaaj One apply for you

An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.

Job Description
About Company
Similar Jobs
Please verify your account first! Send OTP

Job Description

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

PL/SQLData Modeling ToolsData MigrationC#GoSQL.NETPostgreSQLOracleSQL ServerDevOpsSOCGitQAAccounting

If 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.

About Company

Ginni Systems Ltd. (Ginesys) is a complete retail ERP and POS software solution provider for fashion, grocery, and specialty retail brands, helping them manage their supply chain, point of sale, inventory, and omnichannel operations.

Similar Jobs

View all
Loading...

Looking for something similar?

Bag Logo
Jobaaj
Get jobs like this by email

New Others roles in Gurgaon.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.