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

BILVANTIS TECHNOLOGIES; Bengaluru; On-site; INR 2,500,000 - 4,200,000; Full time

Job summary

BILVANTIS TECHNOLOGIES in Bengaluru seeks a PostgreSQL Development – Technical Lead with 8–12 years of experience. You will design, develop and optimize PostgreSQL-based database solutions, migrate Oracle logic, and collaborate with application teams to ensure scalable data processing.

As a lead, you will mentor peers, enforce SDLC/Agile practices, monitor health, implement backup strategies, and document architectures for reference and compliance.

Qualifications

• 8 to 12 years of SQL development experience.
• Design, develop and maintain database systems using PostgreSQL.
• Write and optimize complex SQL queries for data retrieval.
• Write and optimize PL/PGSQL procedures and functions.
• Migrate from Oracle to PostgreSQL for stored procedures and syntax.
• Collaborate with developers to integrate database solutions.
• Analyze and improve database performance for scalability.
• Implement backup and recovery strategies.
• Monitor database health and troubleshoot issues.
• Document designs, procedures and structures.

Responsibilities

• Lead PostgreSQL development efforts as a Technical Lead.
• Design and optimize database schemas and queries.
• Coordinate migration from Oracle to PostgreSQL.
• Mentor team members and ensure SDLC/adoption of Agile practices.

Skills

PostgreSQL

Oracle

SQL

NoSQL

PL/SQL

Procedures

Functions

Job description

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

8 Yrs to 12 Yrs

Full-Time

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.