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.