PostgreSQL Development - Technical Lead

Agriitex Systems And Services; Bengaluru; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Agriitex Systems And Services is seeking a PostgreSQL Development Lead with 8–12 years of SQL development experience in Bengaluru, India. You will design, implement, and optimize PostgreSQL databases, migrate Oracle PL/SQL code, and collaborate with cross-functional teams to deliver scalable data solutions.

You will drive performance tuning, data warehouse considerations, and agile processes using Jira and Confluence. Strong communication and proactive collaboration are essential for success.

Qualifications

• 8 to 12 years of SQL development experience.
• 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 PostgreSQL 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.

Responsibilities

• Lead PostgreSQL development efforts and guide the team to deliver scalable DB solutions.
• Design, implement, and maintain PostgreSQL databases and related data models.
• Collaborate with developers to integrate DBs with applications and processing workflows.
• Tune performance, run diagnostics, and optimize queries and PL/pgSQL code.
• Oversee backup, recovery, and high availability planning.
• Monitor health, troubleshoot issues, and enforce standards and documentation.

Skills

PostgreSQL

Oracle

SQL

NoSQL

PL/SQL

Tools

Jira

Confluence

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.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.