We are looking for an experienced
SQL Developer
with strong expertise in
PostgreSQL
and database development. The ideal candidate will have hands-on experience in writing complex SQL queries, developing stored procedures and functions, optimizing database performance, and supporting data migration activities. The role also requires familiarity with AI-assisted SQL query generation and optimization to improve development efficiency.
Key Responsibilities
- Design, develop, test, and maintain SQL scripts and database objects in PostgreSQL.
- Write productive and optimized SQL queries using DDL, DML, joins, subqueries, CTEs, window functions, aggregations, and views.
- Develop and maintain Stored Procedures and Functions using PostgreSQL procedural SQL.
- Analyze and optimize SQL query performance through indexing and execution plan analysis.
- Support database design, schema updates, and data integrity initiatives.
- Perform data migration, import/export, and bulk data loading activities.
- Load and validate Excel/CSV data into PostgreSQL databases.
- Troubleshoot database-related issues and provide performance tuning recommendations.
- Collaborate with cross-functional teams to understand business requirements and implement database solutions.
- Utilize AI tools effectively for SQL query generation, optimization, and productivity improvements while ensuring accuracy and performance.
Required Skills
- 5–8 years of experience as an SQL Developer or Database Developer.
- Strong proficiency in SQL and relational database concepts.
- Hands-on experience with
PostgreSQL
and
pgAdmin
.
- Expertise in:
- DDL & DML
- Complex Joins
- Subqueries
- Common Table Expressions (CTEs)
- Window Functions
- Aggregations
- Views
- Indexing
- Experience in query optimization and performance tuning.
- Hands-on experience developing Stored Procedures and Functions in PostgreSQL.
- Knowledge of database migration and data loading processes.
- Experience importing/exporting data using Excel/C
📌 SQL Developer (Pune)
🏢 Acveti
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.