- 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.
- 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.
- Experience designing scalable database schemas for enterprise applications.
- Experience with data migration, conversion, and reconciliation on large datasets.
- Experience with database migration tools such as Flyway or Liquibase.
- Ability to read and understand complex legacy SQL and stored procedures.
- Comfortable using AI coding tools in daily development.
- Experience with Git.
- Experience working in Agile/Scrum environments.
- Review database changes for correctness and performance.
- Document data models and database logic.
- Work with development teams on data access patterns.
- 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.
- Bachelor's or Master's degree in Computer Science, Information Technology, or a related discipline.
- 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
- 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.
- 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
Skills Required
- Strong hands-on PostgreSQL experience, including PL/pgSQL functions and procedures, triggers, and views
- Expertise in SQL query optimization, indexing, execution plan analysis, and performance tuning
- Strong data modeling skills involving normalization, keys, constraints, partitioning, and scalable enterprise schemas
- Experience with database migration, data conversion, and reconciliation on large datasets
- Experience with database migration tools such as Flyway or Liquibase
- Ability to read and understand complex legacy SQL and stored procedures
- Comfort using AI coding tools in daily development
- Experience with Git
- Experience working in Agile/Scrum environments
- Bachelor's or Master's degree in Computer Science, Information Technology, or a related discipline
- Experience migrating from SQL Server or Oracle to PostgreSQL
- Experience with multi-tenant database-per-client setups
- Basic C#/.NET knowledge
- Retail, ERP, accounting, or inventory systems domain knowledge
What We Do
Ginesys One is the leading omnichannel suite of complete solutions for the entire retail value chain. Our cloud-based Ecommerce Order Management System, POS, ERP, BI, and GST software simplifies retail operations, enabling retailers to manage inventory, sales, and accounting seamlessly. With over 1200 customers and 50,000+ users across various verticals of retail, including apparel, footwear, fabrics, consumer durables, FMCG, departmental stores, supermarkets, and furnishings, we have established ourselves as experts in the retail space. Our pan-India presence includes offices in Gurgaon, Kolkata, Mumbai, Hyderabad, Goa, and Bangalore. Visit our website to learn more about how Ginesys One can transform your retail operations









