Software Engineering Professional-PostgreSQL

BT Group; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

BT Group is seeking a hands-on Backend Engineer with deep PostgreSQL expertise to lead application development with strong database engineering skills, including performance tuning, security (RLS), and DBA responsibilities. The role spans backend development, database design, and DevOps-enabled delivery.

You will design scalable backend services in Java/Spring Boot, optimize data-intensive APIs, and collaborate with cross-functional teams to deliver robust systems.

Qualifications

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

Responsibilities

• 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.
• Design and maintain robust, scalable PostgreSQL schemas.
• Write highly optimized SQL queries, functions, and stored procedures (PL/pgSQL).
• Perform query tuning and execution plan analysis for performance optimization.
• Manage indexing strategies, partitioning, and data modelling.
• Monitor and troubleshoot database performance and reliability issues.
• Implement and manage backup, recovery, and disaster recovery strategies.
• Configure and maintain replication, high availability, and failover mechanisms.
• Tune database parameters (autovacuum, memory, connections, etc.).
• Design and implement Row-Level Security (RLS) policies and RBAC controls.
• Ensure data protection, masking, encryption, and auditing.
• Integrate database changes into CI/CD pipelines and collaborate with DevOps for deployments.

Skills

Backend development

PostgreSQL expertise

RLS and RBAC security

DevOps practices

Linux experience

Performance tuning

SQL and PL/pgSQL

HA and replication

Tools

Java/Spring Boot

PostgreSQL

postGIS

Docker

Kubernetes

CI/CD tools

Linux

Job description

What youll be doing

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.

Essential 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

Desirable Skills / Experience

• 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.