Database Platform

EXP: 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 (writing, not just calling)


• Functions (writing, not just calling)


• Triggers (writing, not just calling)


• Performance tuning


• Indexing strategies




• 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.