Database Engineer
First seen by Alion on Aug 14, 2026.
Experience : 5+ Years.
Notice Period : Immediate Joiner.
Location : Pune/Remote.
Database platform : PostgreSQL preferred; strong MS SQL Server or Oracle experience is equally acceptable.
Key Responsibilities :
- Design normalized, scalable database schemas from the ground up.
- Write and maintain stored procedures, functions, and triggers.
- Develop and optimize complex production SQL (joins, CTEs, window functions, views).
- Tune query performance using execution plans and indexing strategies.
- Own migrations and data integrity across releases.
- Troubleshoot production DB issues.
- Partner with app developers on efficient data models (support role, not building the app layer).
- Participate in reviews with a database-quality lens.
Job Requirements :
- 4+ years of experience where SQL/RDBMS engineering is the primary, career-defining skill.
- Strong hands-on experience with PostgreSQL, MS SQL Server, or Oracle (Postgres preferred).
- Proven experience designing normalized, scalable database schemas from scratch (schema design, ER modeling, data modeling for scale).
- Excellent SQL skills, including complex joins, CTEs, window functions, views, stored procedures, functions, and triggers.
- Experience writing and optimizing production-grade SQL queries.
- Strong understanding of relational database design and normalization.
- Experience with database migrations and maintaining data integrity across releases.
- Experience debugging and resolving production database issues end-to-end.
- Basic to moderate Python skills - secondary/nice-to-have only, not a core requirement.
- Familiarity with building/consuming REST APIs - secondary, not a core requirement.
- Familiarity with Git and collaborative development workflows.
- Strong analytical and problem-solving skills specific to data modeling and query optimization.
Skills
PostgreSQL, SQL, Database Tools, DB, REST API, RDBMS, DBMS