PostgreSQL Development – Technical Lead (Exp: 8 Yrs to 12 Yrs)

Bilvantis Technologies; Maharashtra; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Bilvantis Technologies in Maharashtra, India seeks a PostgreSQL Development Lead with 8–12 years of SQL experience to guide design, development and optimization of PostgreSQL-based solutions. You will lead cross-functional collaboration with development teams to deliver robust data systems.

The role includes migrating Oracle stored procedures to PostgreSQL, building PL/pgSQL functions, data warehouse maintenance, and performance tuning, with emphasis on backup/recovery and reliability.

Qualifications

• Minimum 8–12 years of SQL development experience.
• Hands-on PostgreSQL development and performance tuning.
• Experience migrating Oracle stored procedures and packages to PostgreSQL.
• Strong knowledge of PL/pgSQL and complex queries.
• Experience with data warehouse design and maintenance.
• Good communication and cross-functional collaboration.
• Familiarity with SDLC and Agile methodologies.

Responsibilities

• Lead design, development and maintenance of PostgreSQL database solutions.
• Collaborate with application teams to integrate database systems with front-end apps.
• Optimize SQL/PL/pgSQL queries for performance and scalability.
• Plan and implement backup, recovery and security strategies.
• Monitor database health and troubleshoot issues proactively.
• Document database designs, procedures and configurations.

Skills

PostgreSQL

Oracle

SQL

NoSQL

PL/pgSQL

Data warehousing

Agile methodologies

SDLC

Cross-functional collaboration

Communication

Tools

Jira

Confluence

Job description

Job Description: PostgreSQL Development – Technical Lead (Exp: 8 Yrs to 12 Yrs)

We are seeking a talented and motivated PostgreSQL Development Lead to join as a Technical Lead.

• Experience should have 8 to 12 years of SQL development.
• Design, develop, and maintain database systems using PostgreSQL.
• Write and optimize complex SQL queries to ensure efficient data retrieval and processing.
• Write and optimize complex PL/PGSQL procedures and functions to ensure efficient data retrieval and processing.
• Migration from Oracle to Postgres SQL for Stored Procedures, Packages and query syntax.
• Collaborate with application developers to integrate database solutions with front-end and processing applications.
• Analyze and improve database performance, ensuring system stability and scalability.
• Implement backup and recovery strategies to safeguard data integrity.
• Monitor database health and troubleshoot issues as they arise.
• Document database designs, procedures, and structures for reference and compliance purposes.
• Stay updated on new technologies and tools related to PostgreSQL and database management.
• Experience in data warehouse design and maintenance
• Experience in agile development processes using Jira and Confluence.
• Experience in cross-functional teams.
• Understanding on the SDLC.
• Understanding on the Agile methodologies.
• Communication with customer and producing the Daily status report.
• Should have good oral and written communication.
• Should be a good team player.
• Should be proactive and adaptive.

Key Skills: PostgreSQL, Oracle, SQL, NoSQL, PL/SQL procedures, and functions.