PostgreSQL PL/SQL Data Engineer

Job Title: PostgreSQL PL/SQL Data Engineer Experience:

7+ Years Location:

Hyderabad Employment Type:

Full-Time About the Role We are seeking an experienced

PostgreSQL PL/SQL Data Engineer

to design, develop, and optimize high-performance data solutions using

PostgreSQL . The ideal candidate will have deep expertise in

PL/pgSQL (PL/SQL-style procedural programming) , complex query optimization, and large-scale data processing. In this role, you will work closely with application teams, architects, and analytics stakeholders to build reliable, scalable, and secure data layers that support enterprise applications and reporting needs. Key Responsibilities Database Development & Programming Design, develop, and maintain

complex SQL and PL/pgSQL functions, procedures, triggers, and packages

in PostgreSQL. Implement advanced data transformations, validations, and business logic within the database layer. Develop and optimize

views, materialized views , and stored routines for performance and scalability. Performance Tuning & Optimization Analyze and optimize complex queries using

EXPLAIN / EXPLAIN ANALYZE . Tune indexes, partitioning strategies, and query execution plans. Identify and resolve performance bottlenecks in high-volume transactional and analytical workloads. Data Modeling & Architecture Design and maintain

logical and physical data models

for OLTP and analytical use cases. Implement data normalization and denormalization strategies as appropriate. Support data warehousing and reporting requirements. Data Engineering & Integration Build and maintain data pipelines for ingesting, transforming, and exporting data. Integrate PostgreSQL with upstream and downstream systems via APIs, batch jobs, or streaming solutions. Ensure data consistency, quality, and integrity across systems. Security, Reliability & Operations Implement database security best practices, including roles, privileges, and row-level security. Support

backup, recovery, replication, and high-availability

configurations. Participate in production support, incident analysis, and root cause investigations. Collaboration & Governance Work closely with application developers, DevOps, and analytics teams. Participate in code reviews, design discussions, and architecture planning. Create and maintain technical documentation and operational runbooks. Required Skills & Qualifications Core Technical Skills 7+ years

of experience in database development and data engineering. Strong expertise in

PostgreSQL

database internals and architecture. Hands-on experience with

PL/pgSQL

(procedural SQL programming). Advanced proficiency in

complex SQL queries , joins, window functions, and CTEs. Strong experience with performance tuning and query optimization. Data Engineering & Operations Experience with large datasets and high-throughput systems. Knowledge of indexing, partitioning, and vacuuming strategies. Familiarity with replication, failover, and backup solutions in PostgreSQL. Nice-to-Have / Preferred Skills Experience migrating from

Oracle PL/SQL to PostgreSQL . Exposure to ETL/ELT tools or data orchestration frameworks. Experience with cloud-managed PostgreSQL services (AWS RDS/Aurora, Azure Database for PostgreSQL). Familiarity with scripting languages such as

Python or Shell . Knowledge of data governance and compliance standards. Soft Skills Strong analytical and problem-solving skills. Excellent communication and collaboration abilities. Ability to work independently and manage complex data initiatives. Detail-oriented mindset with a focus on data accuracy and reliability.