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.

Solid analytical and problem-solving skills specific to data modeling and query optimization.

Skills: sql,database,database schema,postgresql,python,relational databases,mssql,oracle

📌 Database Platform (India)
🏢 Team Geek Solutions
📍 India