An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
Job 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
Skills
PL/SQLData Modeling ToolsData MigrationC#GoSQL.NETPostgreSQLOracleSQL ServerDevOpsSOCGitQAAccountingIf 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
Similar Jobs
View allLooking for something similar?
New Others roles in Gurgaon.
One email a day. Unsubscribe any time.

