SDE 2 – Database
Ginni Systems Ltd.
·Today
- Location
- Gurgaon, India · Kolkata, India
- Department
- IT
- Seniority
- Mid
- Education
- Master
- Source
- Keka
Description
About the Role
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