First seen by Alion on Nov 17, 2026.
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

