Database Engineer - PostgreSQL/SQL

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.