Java Back End Developer + PostgreSQL

Naukri E-hire; Karnataka; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Naukri E-hire is looking for a hands-on Backend Engineer with deep PostgreSQL expertise to drive application development, database design, and platform reliability.

Design scalable Java (Spring Boot) services, build data-intensive APIs, and implement advanced SQL, PostGIS, and RLS/RBAC security in a Linux environment.

You will collaborate across backend, DevOps, and cross-functional teams to ensure clean architecture, observability, and repeatable deployments through CI/CD pipelines.

Qualifications

• Strong backend development with Java/Spring Boot.
• Deep PostgreSQL knowledge incl. PL/pgSQL and PostGIS.
• Experience with performance tuning and DB security (RLS/RBAC).

Responsibilities

• Design and develop scalable backend services using Java (Spring Boot) or equivalent frameworks.
• Design and maintain robust, high-performance database schemas.
• Write optimized SQL queries, functions, and stored procedures.
• Monitor, troubleshoot, and optimize database performance and reliability.
• Collaborate with frontend, DevOps, and cross-functional teams.

Skills

Java/Spring Boot

PostgreSQL

PL/pgSQL

PostGIS

SQL performance tuning

RBAC/RLS security

CI/CD

Docker

Kubernetes

Linux

Tools

Docker

Kubernetes

GitHub Actions

Jenkins

Job description

As a hands-on Backend Engineer with deep PostgreSQL expertise you will be responsible for application development with strong database engineering skills, including performance tuning, security (RLS), and DBA responsibilities. The role will contribute across backend development, database design, and DevOps-enabled delivery.

Backend Development

• Design and develop scalable backend services using Java (Spring Boot) or equivalent frameworks
• Build and optimize data-intensive APIs and services
• Collaborate with frontend and cross-functional teams to integrate backend systems.
• Ensure clean code, modular architecture, and maintainability
• Implement best practices for error handling, logging, and observability.

PostgreSQL Database Expertise (Primary Responsibility)

• Design and maintain robust, scalable, high-performance database schemas
• Write highly optimized complex SQL queries, functions and stored procedures (PL/pgSQL)
• Perform query tuning, execution plan analysis and performance optimization
• Should have worked on postGIS.
• Manage indexing strategies, partitioning, and data modelling
• Ensure data consistency, integrity, and efficient storage utilization.

DBA & Database Operations

• Monitor and troubleshoot database performance and reliability issues.
• Implement and manage backup, recovery, and disaster recovery (DR) strategies
• Configure and maintain replication, high availability (HA), and failover mechanisms.
• Tune database parameters (autovacuum, memory, connections, etc.)

Security & RLS (Critical Skill)

• Design and implement Row-Level Security (RLS) policies in PostgreSQL
• Manage role-based access control (RBAC) and fine-grained privilege.
• Ensure data protection standards (masking, encryption, auditing)
• Conduct periodic database security assessments and vulnerability reviews.

DevOps & Platform Contributions

• Integrate database changes into CI/CD pipelines (schema migrations, version control)
• Work with containerized environments like Docker/Kubernetes DB services
• Automate database deployments and monitoring
• Collaborate with DevOps teams for environment setup, performance tuning and release management.

Skills:

Required Skills & Experience

• Strong experience in backend development using Java/Spring Boot (or similar)
• Deep expertise in PostgreSQL (version 12+)
• Advanced knowledge of SQL, PL/pgSQL, postGIS and query optimization
• Hands-on experience with database performance tuning and troubleshooting
• Strong understanding of RLS, RBAC, and database security principles
• Experience with HA setups, replication (streaming/logical), and failover
• Familiarity with CI/CD pipelines and DevOps practices
• Experience working in Linux environments

Good to Have

• Experience with cloud platforms (AWS RDS/Aurora, Azure Database for PostgreSQL, GCP Cloud SQL)
• Knowledge of CI/CD tools (Jenkins, GitHub Actions, Azure DevOps, etc.)
• Knowledge of containerization (Docker, Kubernetes etc)
• Experience with Infrastructure-as-Code is plus.